I have a table with the following fields:
[LicenseNum], [yrYear], [ttlPaid]
which couldh have the following data:
A1234 - 2003 - $2,309,390

If I have a table with an autonumber as primary key which I would
depoplulate and then repoplulate by appending from another table with
the same structure, will it always work?  i.e, record 1 autonumber =
1, record 2 autonumber = 2... etc.  It works in my testing, but it

I have a combo box that prompts for a participant name. If the
participant name is not in the list I have a procedure that will open
another form to allow the participant's name to be entered. When the
form opens, I place the "openarg" value in the participant name field

i have a querying problem that i need to solve.
i have to sets of parts. Valves and Repair Kits.
there is a manufacture part number for both that i can match on.
the problem is that i know that there are valves in my list that dont have

I've been looking for an answer to this for a while now, and cannot find
anything. Was wondering if someone here had any ideas?
I would like VBA code for generating a text string made of multiple combo
box selections. This would probably have to happen on FieldX GotFocus

I currently have a VBA database in Access 2003. It is 63,000 KB.
This takes up a great deal of space. I recently added a few new forms,
tables, and macros and the DB droped to 27,000 KB.  All of my data is still
there. I do not know why this had happened. I imported a small table ...

I have a table with some information in it.  Then I decided to create a form,
so that I wouldn't have to enter all that data into the table directly.  
Here's the problem, when I enter information in the form, it doesn't show up
in the table.  Say I entered a Primary key of 5 into ...

I have a table that has Columns with the names Status, ID, and Time Stamp.
I want to make a query that if the Id's are a duplicate but the Status are
different, I want whichever time stamp is most recent for the status to
display.

If I have a combo-box with the abbreviations of the US states, I'd
like it to work as follows:
If I have two states with the same initial (Tennessee and Texas), if I
hit the "T" key repeatedly, I want the combo-box to select the second

I think I asked this before, and I didn't understand the answer. So
please bear with me and point me in the right direction
I have a table of Clubs, each club can have one or more
Administrators. Each administrator can mange more than one club.  I

Can I move my old e-mails to a back-up server all at one tim so I can clean
up my desktop and sort old e-mails at a later date?

I am using an Access 2003 Database in a network consisting of both Windows
XP/Access 2003 computers, and Windows Vista Business/ Access 2007 computers.
WIth access 2007, i can use the program IF and ONLY IF no one else is in it.
IF they are i get this error: Your Network access ...

Hi
I have two Tables like below;
Table1
F1    F2    F3

I have a shared network drive storing some Access database
All the using has full permissions
When one user open the database, there is a file *.ldb is generated. And
if another user wants to open the original *.mdb file, double click it, but

When I try to run one of my reports I am getting an error message which says
there isn't enough free memory to update the display,  close any unneeded
programs and try again. The report will not run.
I have tried all of the following: