Search:
Type: Posts; User: clickman
Search:
Search took 0.03 seconds; generated 2 minute(s) ago.
-
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...
-
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...
-
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...
-
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...
-
Awww Guess I was thinking " Its right there!" Ha,
Thanks to all for educating me (again).
-
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...
-
Yes I do, and that is the beauty of the forums. Forum posts and answers don't seem to age with time. :D
-
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
-
@SamOscarBrown and @OptionBase1
I'm so embarrassed - doing face-slap at my end. Thanks for the info.
-
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...
-
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...
-
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...
-
Humm,, Where is the "strArr()" that is Dim'd, or is that not needed for this code block.
-
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???
-
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...
-
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...
-
-
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
-
#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....
-
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!
-
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...
-
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...
-
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...
-
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()
...
-
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...
-
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!
...
-
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...
-
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
-
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...
-
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...
-
That did not do it. Just showed the one attached.
187326
-
Trying to add a better image
-
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...
-
Same error -- using the Field Index works.
-
-
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...
-
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....
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|