dcsimg

Search:

Type: Posts; User: WorkHorse

Page 1 of 13 1 2 3 4

Search: Search took 1.24 seconds.

  1. Replies
    3
    Views
    615

    MsOf10 Re: [Excel] City & state dropdowns

    I'm not sure what I am supposed to do with that. The 'Unique' column has a list of unique states, which is sort of on the right track (but it would require another sheet to hold that data). I need a...
  2. Replies
    3
    Views
    615

    MsOf10 [Excel] City & state dropdowns

    This is for Excel 2010.

    I basically just need to make a sheet that allows the user to select a City and State and displays the value for that city.

    I have a worksheet that has a list of cities...
  3. Replies
    5
    Views
    1,024

    Re: GetProcessesByName with array

    I need to look at what you posted a bit more...
  4. Replies
    5
    Views
    1,024

    Re: GetProcessesByName with array

    I've seen this offer for C#


    IEnumerable<Process> processes = new[] { "process1", "process2" }.SelectMany(Process.GetProcessesByName);

    What's the difference in my VB code?
  5. Replies
    5
    Views
    1,024

    Re: GetProcessesByName with array

    The conact solution is what I ended up coming up with. Why doesn't the IEnumerable with SelectMany work? Isn't there a linq solution for this?
  6. Replies
    5
    Views
    1,024

    GetProcessesByName with array

    I need to check all processes that match a certain list of names. How can I pass an array of names to GetProcessesByName? I tried this but it doesn't work.


    Dim procs() As IEnumerable(Of...
  7. Replies
    10
    Views
    5,562

    Re: DataGridView grid lines

    And I guess we don't need to a second check of whether the cell is in the column or row range.

    Private Sub DataGridView1_CellPainting(ByVal sender As Object, ByVal e As...
  8. Replies
    10
    Views
    5,562

    Re: DataGridView grid lines

    I now see what you are talking about. I changed the backgroundBrush so that it shows the text when the cell is selected. In the IsCellOnRangeBorder I changed it so that it doesn't subtract 1 from the...
  9. Replies
    10
    Views
    5,562

    Re: DataGridView grid lines

    I tried setting Grphics and then setting the rectangle after the grid was updated. I set the width and height to the cell width and height, and the X and Y to the cell bounds. But the X and Y from...
  10. Replies
    10
    Views
    5,562

    Re: DataGridView grid lines

    Since it is not especially difficult and not all that much code, could you post some example code to do this?
  11. Replies
    10
    Views
    5,562

    Re: DataGridView grid lines

    So, how do I do that? It's a big grid with lots of borders neeed. Am I supposed to use the CellPainting event and write dozens and dozens and dozens of lines of code to check and draw a line for each...
  12. Replies
    10
    Views
    5,562

    [RESOLVED] DataGridView grid lines

    I have a DataGridView (not data bound, not editable) that displays a bunch of data. I want to draw rectangles around some of the blocks of cells to set them apart visually. For example, I want to...
  13. Replies
    9
    Views
    3,073

    Re: Tabcontrol without tabs

    Thanks. I'll give it a try.
  14. Replies
    9
    Views
    3,073

    Re: Tabcontrol without tabs

    Because setting up 8-10 panels with somewhat complex controls on 9 user controls is a pain to work with in the IDE.

    Unless you have suggestions where I can easily flip trhough panels in the IDE.
  15. Replies
    9
    Views
    3,073

    Tabcontrol without tabs

    What I want is a tabcontrol where it doesn't show the tabs. I want icons in a toolstrip that will select the tabpages. The closest I can get is setting the ItemSize to 1 (if it is zero, it reverts to...
  16. Replies
    4
    Views
    1,865

    Re: CheckSpelling with CustomDictionary

    It is straight forward as I described:



    I posted my code. As it says above, the custom dictionary file "C:\test.dic" has the above 2 words in it. I type those same two words in a Word doc and...
  17. Replies
    4
    Views
    1,865

    Re: CheckSpelling with CustomDictionary

    That works the same as ActiveDocument.CheckSpelling. In VBA the Application object is implied because it is the "A" in VBA, so it doesn't (usually) matter whether it is used explicitly or not.
  18. Replies
    4
    Views
    1,865

    CheckSpelling with CustomDictionary

    I can't get Word to use a CustomDictionary passed as a parameter for CheckSpelling on a Document object. It works for CheckSpelling on an Application object but not a Document.

    I need to spell...
  19. Replies
    2
    Views
    462

    Excel line chart averages zeros

    I have a line chart in Excel that has some zero values. So the lines drop to zero, but I want the line to continue to the next value. I've done this before, but now I forget how.

    Basically, I have...
  20. Replies
    2
    Views
    374

    Excel-Missing item in set

    This isn't a VB question. I want to do this with a formula and not VBA.

    I have a block of cells of about 20 rows and three columns where the user enters Type, Amount, and Accept (Y/N). Any row can...
  21. Replies
    8
    Views
    701

    Re: Using GetPixel on Extrn. Applications

    The GetColor function returns a long, not a hex value, so I assume that lngcolor (the value return from the GetColor function) is a decimal (or, more correctly, a long) value. The value...
  22. Replies
    8
    Views
    701

    Re: Using GetPixel on Extrn. Applications

    What value do you get for iWorkFine?

    Stepping through the code, does "sro_client" come to the foreground?

    What value does GetColor return?

    If you are running this on VB2005, you are...
  23. Replies
    8
    Views
    701

    Re: Using GetPixel on Extrn. Applications

    Well, it only calls SetForegroundWindow under certain conditions. It appears that ActivateWindow would always cause xhWnd to become the foreground window one way or another. Does it? You also have a...
  24. Replies
    8
    Views
    701

    Re: Using GetPixel on Extrn. Applications

    GetPixel only returns what is painted, so you need to SetForegroundWindow xhWnd before calling GetPixel.
  25. Replies
    1
    Views
    1,003

    Re: WindowFromPoint problem?

    Getting the window from the point returns the SysTabControl32 (a sibling of the Edit control) because the SysTabControl32 is on top of the Edit control in the Z-order.
  26. Re: how to find window handle using process ID or thread ID?

    I don't think Windows establishes any special relationship between a process of thread ID and the parent window. The VB Programmer's Guide to the WIN32 API doesn't list any process or thread...
  27. Replies
    7
    Views
    1,585

    Resolved

    Absolutely fantastic! :cool: Everything is running smooth now. Thank you so much! :)
  28. Replies
    8
    Views
    645

    Re: String problem

    lLen = InStr(1, abovestr, vbCr)
    If lLen >= 1 Then
    Debug.Print Left$(abovestr, lLen - 1)
    End If
  29. Replies
    1
    Views
    351

    Re: Treeview Questions

    Collapses all nodes:

    For i = 1 To TreeView1.Nodes.Count
    TreeView1.Nodes(i).Expanded = False
    Next i
  30. Replies
    7
    Views
    1,585

    Re: [UNRESOLVED] Tabstrip text

    Thanks. Maybe you or someone can help translate. Everything seems to work fine until ReadProcessMemory. Then everything goes kaboom! If I pass an nSize of a small amount (like 50 or so), it doesn't...
  31. Replies
    1
    Views
    401

    Re: WebBrowser control question...

    I've found that sometimes with WebBrowser when you do something that opens another IE window, it doesn't always work. You get just what you described. It doesn't have anything to do with popup...
  32. Replies
    7
    Views
    421

    Re: String Problem

    No. It doesn't. I'm still not exactly sure what you are trying to do. If you want to fill a listbox with your ranks, you can do it like this:

    Private Sub FillList()

    ' Fill listbox with...
  33. Re: Why does this simple thing not work

    It does work. However, selected text in a textbox is not highlighted unless the textbox has focus. Keep in mind that if you click on a textbox, your mouse will set a new selection.

    Click Command1,...
  34. Replies
    20
    Views
    1,327

    Re: API in VB for Application, MS Access

    Try Private Declare instead of Public Declare.
  35. Replies
    7
    Views
    1,585

    Re: Tabstrip text

    But the string needs to be in the memory of the other process and needs to point to the pszText item in the TCITEM structure. Here's what Eyes.Only said in the other thread:



    I've retreived...
  36. Replies
    7
    Views
    1,585

    [RESOLVED] Tabstrip text

    I'm trying to get the text of tabs from a tabstrip in another application. I tried to follow the description in http://www.vbforums.com/showthread.php?t=256262. I'm not sure how to go about creating...
  37. Replies
    1
    Views
    538

    Is window fully painted

    How can I tell if a window is fully painted? I'm taking some screen shots of different windows, which works fine except that I have to bring the window to the front before I can capture the image and...
  38. Replies
    1
    Views
    427

    Disconnected recordset

    I'm using VB6, Access 2002, ADO.

    I've got an app where the user pulls up a record and then can fiddle with the data and either save it or not. When it pulls up the record, it makes a clone of the...
  39. Replies
    7
    Views
    646

    Re: Recursive combinations [please help]

    Bwwwahhhhahhhahhhhaa!!! :D

    I've at least managed to do what I asked for in the original post. Now I just need to work in the array.

    Sub DooDah()

    For x = 1 To 5
    Combo "", 0, x,...
  40. Replies
    7
    Views
    646

    Re: Recursive combinations [please help]

    No, no, no. The idea is to get combinations, not permutations (if I'm using those words right). ABC is the same as ACB as far as I'm concerned. I have an array of numbers. I need to find the best...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width