Search results for query: *

I've already got this at the top of my form's code: Option Compare Database Option Explicit

I did everything you mentioned except step 3; how do I declare optionYes? (even though it's on the same form as BtnAdd, it's still giving me the optionYes "variable not defined" error)

Here is my "Global Code" module utilizing the code from the FAQ. Now when I click the command button "BtnAdd" on my form Region6, nothing happens. Option Compare Database Function IsLoaded(ByVal strFormName As String) As Integer ' Returns True if the specified form is open in Form view or...

I just made some corrections to the code and now it highlights this line (that comes immediately after the private sub line) If optionYes = True Then ^^^^^^^^^^^^^^^^

After making all the necessary changes from the FAQ's generic code and adapting it to the Text/List/Combo boxes of my form, I'm still getting this same error of "Compile error: Variable not defined" with this line highlighted: Private Sub BtnAdd_click() Any suggestions?

If I go ahead and delete the second "Option Explicit" declaration, it then gives me this error (upon clicking the command button 'BtnAdd'): "Compile error: Variable not defined" It then goes on to highlight this line: Private Sub BtnAdd_click()

I think I found the FAQ you're referring to: http://www.tek-tips.com/faqs.cfm?fid=4001 However, after I input it into my userform code, upon loading the form I immediately get the error message "The expression On Click you entered as the event property setting produced the following error...

I currently have a listbox where selected entries are exported to a brand-NEW Excel worksheet (each time) after the user clicks a command button to run the following VBA code. However, I'd like it to create just ONE new Excel worksheet initially and then append later selections onto that same...

Is there a way to perform the described function without using the VB commands PHV listed (such as through macros or otherwise)?

No

I currently have a form that has an OLE Object on it that was created by copy-and-pasting from a Microsoft Word document. The problem is that it only allows me to edit the text when I double-click the Object in Design View. In normal Form view, double-clicking does nothing. Is there any way to...

Hi, I'm trying to create a command button to directly open up an existing Word document; is there any way to do this with VBCode? Thanks.

Still no go w/ "3digititemnumber" as Text; now gives error as "Syntax error". However, after changing "3digititemnumber" to a Number, the code from your previous code now works!

3digititemnumber" is defined as Text LBx is populated and selected

Thanks for your response PHV, but it's still giving me the same error. Any other ideas? Thanks.

Hi, I keep getting "Run-time error '3077': Syntax error (missing operator) in expression. here is my code: rst.FindFirst "3Digit Item Number = " & LBx.Column(0) I never got this problem when "3Digit Item Number" used to simply be "MSID" instead. Anyone know how to fix this? Thanks.