Search results

I found it thanks set db2 = Opendatabase (Application.CurrentProject.Path & "\order1.mdb")

I have some code that needs to open another database in the same folder as the current database. I have two databases that will be located in the same folder. I do not want to hard code the location because the location can be changed. I need to open a database called order1.mdb which...

I just got it to work. I moved it inside of my loop and now it works. I was just about to delete this post. thanks for the quick reply I think the problem was that some of my controls were not Integer values (even through my variable type was), so it was throwing off the code, but when I...

I need to obtain the value (a long integer) from each control on my form but one line of code is giving me an error message. The error message says "Run-time error 2455, You entered an expression that has an invalid reference to the property value" The line that is giving me the error is...

Thanks, it worked. I really appreciate the help

How can I add a field to an existing form NOT newly created form using VBA? I currently have VBA code creating a new field in a table. This table has an associated form. I want this new form field to also appear in the form automatically through vba. I tried to create a control to add to...

How do you add a field to an existing query using vba? Using MS Access module I need to add/append a table field to an existing select query and save the query using vba code. 1. I will specify the name of the field to be added 2. I need to specify the table it is added from 3. I need...