i keep questions in a table, each question has a different answer type. eg
answer could be a number then there will be limits for the answer or it
could be multiple choice question, then choices must be kept or it could be
a yes/no question ,

I would like to have the Link tables manager to pop up
apon starting a database for the first time.  But I
cannot figure out how to do this.  
Can any body offer any suggestions.

I posted this before and I am hoping someone can help or
lead me in the right direction..
I am about to redesign my departments Database structure.  
Basically we have to many and no one knows who is doing

Hi, I am trying to establish relationships between tables
by using the ID numbers as the foreign key.  For example
using the ActivityID as a foreign in the tblBusiness to
link tblActivity and tblBusiness.  Access allows me to do

Hope some one can help.  I have been racking my brains for
ages and can not think of a solution.  I must point out
that I used to be quite good at Access but I am now rather
rusty to say the least.  My dilemma is this;

Hi I am trying to use the Input Mask Wizard but I keep
getting a Memory Overflow error coming up???
Can anyone explain what this is and how to stop it so that
I can use the Input Mask Wizard.

I have a database that keeps a record of how many payments
our collectors gets per day.  They data that is entered
would look something like this...
CGE 1 6/16/04

I have 5 check boxes in a record and I want to be able to limit input of data so that only one check box can be ticked.  It's probably really straight forward, but can't find out through the usual help menus.  Is it a validation rule expression, maybe?
Would really appreciate help ...

Hope some one can help.  I have been racking my brains for
ages and can not think of a solution.  I must point out
that I used to be quite good at Access but I am now rather
rusty to say the least.  My dilemma is this;

Hope some one can help.  I have been racking my brains for
ages and can not think of a solution.  I must point out
that I used to be quite good at Access but I am now rather
rusty to say the least.  My dilemma is this;

I am not very experienced at designing a database as I
only input data before or created a small database.  I
now need to create a database with the following
information and can't get my head round the tables and

My database will record and report production information from a manufacturing operation.
I need to lookup product information per machine and store the information in a daily production table. MachineID will be a foreign key in the daily production table.
However, the product ...

I would like to format the currancy fields so when I enter a number "169" and press tab, it automatically enters it with 2 decimal points "1.69".  The field is formated to currancy.  I have tried several things on the format, on enter, on exit, etc. but nothing seems to work ...

I created a table in either a Sql Server db or an MDB file with 3 or more integer type fields together.  For example:  RecordID int (key), f1 int, f2 int, f3 int, f4 int
Then I tested entering data into this table through the table's datasheet view.  
if you enter 1 in f1, 2 in f2 ...

I am receiving  the error "ActiveX componenet cannpt create object" when trying utilize the Switchboard Manager in Access 2002 and Access 2000. Whaat is the recommended fix for this. I have already un-installed and re-installed the software with no luck.