Search:

Type: Posts; User: clickman

Page 1 of 5 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    10
    Views
    595

    Re: BeforeColEdit Problem

    Here is how it is done at the BeforeColEdit Event


    Private Sub DataGrid_BeforeColEdit(ByVal ColIndex As Integer, ByVal KeyAscii As Integer, Cancel As Integer)

    '<Prevent user from deleting a...
  2. Replies
    10
    Views
    595

    Re: BeforeColEdit Problem

    Hi Sam,

    It is called by the inherent VB code when I click in a cell in my data grid - and then "do something".

    All those VB DataGrid events as in:

    BeforeColUpdate
    AfterColUpdate...
  3. Replies
    10
    Views
    595

    Re: BeforeColEdit Problem

    Since the time I hit the Delete key on my keyboard, and at the breakpoint that I have placed at the line


    Private Sub DataGrid_BeforeColEdit(ByVal ColIndex As Integer, ByVal KeyAscii As...
  4. Replies
    10
    Views
    595

    [RESOLVED] BeforeColEdit Problem

    I have a datagrid where I am trying to prevent the user from deleting a value, say "123"




    Private Sub DataGrid_BeforeColEdit(ByVal ColIndex As Integer, ByVal KeyAscii As Integer, Cancel As...
  5. Re: Can't Remove Strange Icon from Form

    Awww Guess I was thinking " Its right there!" Ha,

    Thanks to all for educating me (again).
  6. [RESOLVED] Can't Remove Strange Icon from Form

    I have a strange icon at the upper right of one of my forms. I cannot seem to "grab" it to delete it or move it. I is a really small triangle with an exclamation point in it. Cant select it to see...
  7. Replies
    11
    Views
    1,306

    Re: Overflow Error

    Yes I do, and that is the beauty of the forums. Forum posts and answers don't seem to age with time. :D
  8. Replies
    11
    Views
    1,306

    Re: Overflow Error

    This really saved me. I learned something valuable.

    I had a code line that said




    Dim l_ItemID As Integer

    l_ItemID = frmMonkey.xMonkeyGrid1.ItemID
  9. Re: Issue with using run time current form name

    @SamOscarBrown and @OptionBase1

    I'm so embarrassed - doing face-slap at my end. Thanks for the info.
  10. Issue with using run time current form name

    In my code I have places where I obtain the current form name. (See Below)

    Getting the name of the current form works fine using the g_objCurrentForm.Name statement given below,

    My issue is...
  11. Replies
    11
    Views
    7,791

    Re: Read text file into combo box [RESOLVED]

    OK. So I post the code here with the "Dim strArr() as String" commented out. It yields a running example, just like it does if it is not commented out, and I will take that as it being in there as...
  12. Replies
    11
    Views
    7,791

    Re: Read text file into combo box [RESOLVED]

    OMG, Really???

    I would not have asked the question if I had an idea.

    First, my expectation is that any Dim Statement would use the item Dim'ed in the code block that is posted, and which has...
  13. Replies
    11
    Views
    7,791

    Re: Read text file into combo box

    Humm,, Where is the "strArr()" that is Dim'd, or is that not needed for this code block.
  14. Re: How to check null value of datagrid cell in VB6

    Saved my Bacon too! 20 years later

    This will not work:

    Debug.Print IsNull(DataGrid.Columns(ColIndex))
    Is the reason because Null is by definition not a value???
  15. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    Yes, for the example I posted, when all the names are ("Fake Name Billy " & i ) that works. In the case where every name is different, the .AddItem ""item" will be different, and require separate...
  16. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    Here is code to set the cbo width automatically based on the length of the longest item in the cbo, AND to set the height.

    Steps:
    Create a form
    Add a Frame
    In the Frame add a combobox named...
  17. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    Humm .. throwing error..
  18. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    How about that.

    Sure enough it does work inside a frame. Now to figure out why it is not "working" inside my frame.

    Got it on setting the number of items using a variable.

    Thanks
  19. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    #1 What is the 13? Is that the number of items you want to have shown? I am thinking that it is based on the code itself.

    #2 This too, does not work if the combobox is inside a frame....
  20. Replies
    18
    Views
    1,911

    Re: setting combo box drop down height

    This worked for me [edit: outside of a frame]

    Just to think, you posted something like a bazillion years ago. and it helps me here in 2023!
  21. Replies
    10
    Views
    1,015

    Re: Displaying a pdf file in vb6 form

    I will take a look, and add yours to my took kit. Thank You.

    That said, here is a single cannon shot


    WebBrowser1.Navigate App.Path & "\Data Files\Documents\my document .pdf"

    This has a...
  22. Replies
    10
    Views
    1,015

    Re: Displaying a pdf file in vb6 form

    I think that the title of my post was perhaps the start of the confusion. I was not trying to display a pdf in a form. I was wanting to display a pdf file in my web browser, just as it would display...
  23. Replies
    10
    Views
    1,015

    Re: Displaying a pdf file in vb6 form

    Yes that is the ticket. Now at run time the WebBrowser1.Navigate "C:\your_path\your_pdf_file.pdf" displays the Open Save Cancel dialog, whereupon user can take the desired action to Open Save or...
  24. Replies
    10
    Views
    1,015

    Displaying a pdf file in vb6 form

    I ran across this forum post about how to display a pdf.

    www.vbforums.com/showthread.php?866941-Displaying-an-excel-file-or-a-pdf-file-in-vb6-form




    Private Sub Form_Load()
    ...
  25. Re: AfterColUpdate does not fire after hitting Delete on keyboard

    You - the issue was that I was having a brain freeze and you unfroze it. No problems were happening with the code and things work great ... now that I know how things "work".

    I may move some code...
  26. Re: AfterColUpdate does not fire after hitting Delete on keyboard

    Well then, that behavior is exactly what I am experiencing. I guess that in my haste on the code, I would hit delete, and then hit enter so fast that I thought I was was hitting just the delete!

    ...
  27. AfterColUpdate does not fire after hitting Delete on keyboard

    I have a datagrid, and if I select a "cell", and then key in a new value, and then hit enter, the AfterColUpdate fires. ( I ascertain this by placing a break point on the event and it does stop/break...
  28. Re: Prevent Delete of Value in DataGrid "Cell"

    Oh that is a great idea. Started playing with it and seeing how it works. I can sure use this. Thanks


    Private Sub Form_Load()

    grdDataGrid.Columns(0).Locked = True

    End Sub
  29. Prevent Delete of Value in DataGrid "Cell"

    I have a datagrid that has a value in a "cell" [row/column]. I am able to prevent an edit of the cell by using the BeforeColEdit event - as in


    Private Sub DataGrid200_BeforeColEdit(ByVal...
  30. Replies
    5
    Views
    1,652

    Re: Excel VBA Print Issue

    Thank You so much - This really helped and the


    Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

    you mentioned, was added to my control, and did exactly what I wanted and...
  31. Replies
    5
    Views
    1,652

    Re: Excel VBA Print Issue

    That did not do it. Just showed the one attached.

    187326
  32. Replies
    5
    Views
    1,652

    Re: Excel VBA Print Issue

    Trying to add a better image
  33. Replies
    5
    Views
    1,652

    Excel VBA Print Issue

    I have an excel sheet and i find that when I click File|Print, or the the Ribbon bar "Print Preview and Print" , that i get a different dialog than when, in my VBA on a AcitveX Control, I have...
  34. Replies
    6
    Views
    1,012

    Re: Recordset - Use () in Field Name

    Same error -- using the Field Index works.
  35. Replies
    6
    Views
    1,012

    Re: Recordset - Use () in Field Name

    That works.
  36. Replies
    6
    Views
    1,012

    Recordset - Use () in Field Name

    I am importing an excel worksheet in the an Access database.

    The source excel file from a 3d party includes a column that is named"



    I am trying to import the values in this excel column...
  37. Replies
    7
    Views
    2,329

    Re: Copy Control(s) to another form

    I see is was ambiguous. I have tried selecting the Frame containing the objects and copy and pasting it across forms, but that did not work. I think that frame selection is what you were indicating....
  38. Replies
    7
    Views
    2,329

    Copy Control(s) to another form

    I have a form having a frame which includes a number of Command Button controls. I want to copy this frame (and its controls to another form). I tried the copy and paste Ctl-C, Ctl- V way but no...
  39. Re: Active X Designers vs Designers Problem/Error

    Resolved

    I have VB CodeSmart on my dev machine, and it is the one that calls it ActiveX Designers. The VB6 Project explorer calls it the Designer.

    Also I reinstalled VB6 on the 2d machine and...
  40. [RESOLVED] Active X Designers vs Designers Problem/Error

    I have 2 Win 10 machines with VB6 Professional on them. In machine 1 ( the dev machine), in the Project Explorer, I have an item called "ActiveX Designers", and under that, I see my various data...
Results 1 to 40 of 169
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width