I am testing a table structure, and want to delete all of the records,
which are primary keyed with auto number. If I just delete the records,
and create a new record, it picks up whatever the last record number
was. I remember once that I had to do a query to clear that index.  BTW ...

I have a access table that has a counter field which has data type auto
number.
But in my datasheet view, say the below data:
Counter        Product

hi
i have an MSAccess about a state agent, i want to create a query that
remindes me about the rents due by the tenant within the next 7 days,however
i have contract start date field where every month from the start of that

I have an access 97 database that I am attempting to open in access
2003.  It sez:  "unrecognized database format'C:documents and
settings\My Name\desktop\tilium roster.mdb'.
I click help and it gives it as error 3343 with suggested solutions.

I have a report already created with certain information.  I want to
create another report that only includes a few items from the original
report.  How do I do this if these none of these items have anything in
common?  I only want the new report to include 5 items from the ...

Hi there. Just when I think I know what I'm doing in Access, it kicks my butt
on the simplest of issues!
I have a form that allows users to select criteria for printing a report. It
generates an Sql to get the appropriate record from the file called "Glass"

I'm trying to set up a database with student information (last name, first
name, etc) in a table and the answers given to each of 5 quesitons on a quiz
in 5 separate tables.  Each table has an autonumber primary key.  I set up
all the tables, and I thought I'd set up a form.  In ...

I would like this bit of code to work, but if there is nothing in
tblParameters that fits ls_where, I get an error "Invlid use of null"
Is there a way to make this work?  The documentation said it returns a null
if it doesn't find a row, so why is this illegal?

I'm learning from Access 2000 for dummies and need to have this repor
done today. I need some guidance. I have two tables:
Customers
name

I am very new to access and was trying to create a data field that
automatically calcuates the age of a person at death from the two previous
fields (one being the date of birth and the other the date of death). I have
very limited knowledge about this, but I am learnigng! Any ...

I am using Access 2002 and have a variable that I need to access throughout
the program several times.  I have set it as a Public variable in a module.  
I use the Forms!F4562.G_SeqNum to carry the variable from open form to open
form but when I close the first form I can then no ...

I thank you for see in my web site today and pick out the best web site you
and goodlock thank yoyu
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

How would I create a splash screen to appear for 3 seconds then load up my
login form?

I apologize in advance if this is a dumb question.  I have created an
information sheet in excel that my bank uses.  We need to track new accounts.
Each day, the bankers email the information sheets to me where i open the
excel sheet and enter the information onto the system.  I ...

Greetings all,
   I have a folder called 'Employees' and in the folder I have 4
spreadsheets, all with the same structure on sheet1.  The spreadsheets are
called bobpay.xls, tompay.xls, stevepay.xls, and tammypay.xls