Search results

This silly thing vies me an error on the following line cbx_UserID.SetFocus Run-time error '2108': You must save the field before you execute the GoToControl action, the GoToControl method, or the SetFocus method. WTF?? :confused:

I know how to do this in VB.NET but VBA is killing me!!! I have a form with a combo box. I would like to create an "on change" event where it updates the text boxes on that same form depending on what's been selected in the combo box. I don't know how to change the combo box's selected index...

I set up my MS Access 2007 database with a password. I've written a program in VB.NET to communicate with the database. However, now that it's been passworded, obviously the queries don't work. What do I have to add in my program to access the database? Would I have to put it somewhere in the...

THANKS! It runs now.

I'm simply trying to make a message box display when a user clicks on a button. I go to the "On Click" section in the properties sheet. I select Code Builder I simply put msgbox("This is a test") I save it I open the form, I click the botton and NOTHING happens What am I missing here...

Right now on my form I have a comobox options within. The query takes the selection from the form combobox like so: [forms]![formname]![comboboxname] It successfuly retrieves what the user selects, but how can I do the same thing but with a listbox that has a multiselect?? Would I have to...

Awesome. It worked. Thank you! BTW sorry about the double post. I got an error when I first tried to post. I checked the forum to see if it went through, and it didn't. Guess there was some lag. Any thoughts on the mutliselect list box? Something tells me VBA might be involved, not 100% sure...

Right now on my form I have a comobox with 3 options. The third option is an "all of the above" case. The query takes the selection from the form combobox like so: [forms]![formname]![comboboxname] The problem is: I can't figure out how to tell it to take both option1 and option2 as the...

I COMPLETELY Agee with you. However, I'm doing it for work. The users of the database are hard headed and insist that Access' GUI is confusing and hard to learn. So they want me to make an already user friendly interface "more friendly" Neither of your example code work... (and I did check the...

I can't even get a simple button to execute my event procedure!! on the OnClick event I tell it to change the caption of a label to something else, and it doesn't even do THAT! label32.caption="Whatever" Is that not correct code?!?!

I can barely find answers in google or MSDN. I'm trying to find a tutorial, or at least some sample code on how to programmatically create a report. What I have now is a Form that opens up with the Access database with drop down menus that allows people to use my own interface to customize a...