Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mdillon

    Annoying Problem (Needs a Simple Solution)

    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.
  2. mdillon

    allow full menus

    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.
  3. mdillon

    Table Size Limit

    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
  4. mdillon

    Table Size Limit

    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...
  5. mdillon

    Error in field

    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...
  6. mdillon

    HELP! Startup problem

    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...

Part and Inventory Search

Back
Top