thank you for the info....I'm trying it and want to make sure I have this
correct:
The table name containing the data is 'employeedata'
The field in that table containing the id number is 'employeeidnumber'

Please help! I've used this code to open a PDF:
Private Sub Map_Click()
Shell """C:\Program Files\Adobe\Acrobat
6.0\Reader\AcroRd32.exe""C:\TransServer\GFMap.pdf"

I was wondering if it is possible to change the datatype of an existing
field in code ? I was trying something like:
 db.TableDefs("Table1").Fields("Field1").Properties ("type") = dbText
but this does not seem to work.

Hello:
I'd like to know if it is possible to hide a tab control based page upon a
value in field in another table.  I have a tab control where I want to hide
pages based upon whether a check field in another table is checked no.

Is there a DoCommand to minimize a window
I have this line
DoCmd.Close acForm, "SwitchBoard"
Which is fine for some forms but the Switchboard I want to minimize not close.

Using Access XP
I want to place a label on a switchboard and when a user clicks it, another
database opens.
Let's say the label's name is lblOpenCheckbook and the file I want to open

I posted this in access.forms last week, but perhaps this newsgroup is a
better place for it:
Hi all,
I have a subform displaying records in Continuous view. I'd like to be able

I want to create code that will check certain fields to make sure they have
data.  Easy enough......but,  My form has a subform that might have 2 or 3
records within it. I want to make sure the subforms records are complete.
What is the process to make a check in the main forms ...

i am working on access 2000. i have a form on which i have 7 combo-boxes getting values from 7 different queries. i want to know that after i have seen the value of a combo-box, i would like to have a reset button which will empty the combo-box's value to nothing-empty. what is ...

I am creating purchase orders that I need to send to specific suppliers via
email.
The purchase order tables contains the email address of the recipient.
Does anyone have a good routine that will enable me to send  purchase orders

I have built a login screen using text boxes and a query by form.  When the
LOGIN button is clicked another form is opened that contains the information
found in the record.  Everything is working beautifully, unless no record is
found.  Then the form opens with a blank record. ...

Is there a way to have the columns in a listbox (on a form) wrap the data?

I am trying to call a sub from a form.  The sub I want to call is called
restore and it is in the subform rgaParts.  I have tried many variations to
call it and nothing is working.  The sub is declared as public.  I am using
Access 2000.

I have a contiuous form that has a date and time field in the records.
The date defaults to =Date, the time defaults to =Time.
This works great except that as soon as I put in the required fields for a
record, it automatically creates the next record with the current date & time.

I have a form with four controls:
cboTopic (choose a topic)
dtmTrainingDate (text, date entry)
mslbxTest (multiple select box, choose names)