Search results for query: *

Remove the declarations "Dim theDB as Database" and "Set TheDB = CurrentDb". "Set RS = TheDB.OpenRecordset(strSQL)" now becomes "Set RS = currentDB.OpenRecordset (strSQL)". This worked for me.

Exit out of the database. When you re-open the database, hold down 'shift'. This will override the startup options. You can then go into 'Tools' 'Startup...' fix any changes you made.

I am using MS Access 2000. In addition to a max table size (MSDN did not list the actual size), is there a limit to the total amount of data that access can handle. Would Access be able to handle 100 tables, for example, with each filled with data to their maximum capacity? M. Dillon

I am linking the tables in my MS Access front end with the tables in my dataserver through the "Link Tables..." feature via ODBC. The data in the tables will eventually reach several GB's. Will the MS Access front end be able to handle several GB's of data as well, or will Access...

Go to the design view of your subform. In the footer of the form, create a text box called SubTotal. The control source becomes "=sum([Amount])" without the quotes. Now on the mainform, create another text box. Set the contol source in it to be...

In MS Access 2000, I wanted a form that I just created to be loaded upon startup of access. I went to "Tools" and then "Startup...". I entered the form name, and deselected all of the checkboxes. When I start the database, the form comes up as expected, and only a partial...