Is there a way to set a field in a table as the primary
key in either the make table query or in a macro?  Thanks.

I'm trying to figure out how to change the row, column,
data fields w/in pivot tables using VBA, not the pivot
table wizard.  Can anyone help?
Also,

I am not a very experienced ACCESS user and have Access
2002 in Office XP.
I have set up a group of macros that work but display
messages such as -- can't find file -- which is valid if

I have saved a macro as a shortcut.  It runs fine as long
as the database is open.  If the database is not open, it
tells me it can't find it.  Is this normal?  If not, what
is the purpose of having a shortcut to a macro if you

I have a button that I use to automatically send a report
to users in a Snapshot file format. This is working fine
on all bar one PC. All other users get the email created
and the snp file attached bar one. Which creates the email

Anyone have ideas as to why after upgrading to XP
professional, an Access97 macro will not run. This is the
command prompt.
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE"

I haven't used access in a year and now everything I used
to know fell out of my head.
I know there is a way to get Access to automatically run a
macro upon opening a database.  If you want it to not run,

I have a cleanup macro that cleans up several databases
which I call clean.  I use it everyday.
Is there a way in which the macro can run automatically
every day at a predetermined time without user input.

I have a data base that contains employee information. it
also contains the Contractor name that employee works for.
I want to be able to double click on Contractor field of
the employee form and return the Contractor Information

The large bleeding bump on my forehead is from beating my head on the wall.
I have a form with 3 subforms.. In add mode I enter the main form
information then go to an unbound combo box and select a detail scope.
Using the OnChange event I open an "Add Scope form" that shows the

Can anyone tell me what I am doing wrong??
------------------------
if Now() = #06-08-04# Then
Do something....

I need to create a form that has checkboxes. 10 columns of
different Divisions with 9 rows of hours such as 10-11,
11-12, 12-1 and so on. In each row under each column there
are 10 to 35 checkboxes that each one represents as count

Hi all, here is my problem:  Currently I have a form that
has a check box that determines whether or not a Customer
is a member.  If the customer is a member then they get
the member price, and if they aren't a member then they

This has never happend to me before,  I'm using Access
2002.
I have a Macro that calls an Update Query and a Delete
Query, the query results are popping up on the screen.  

I have a database that was created in Access 2000.  Some
of our clients have upgraded to Access 2003 and we are
having trouble with a macro.. We are trying to save a
table as a .txt file.  The macro saves the table as