What is the best way to do this
We have a list of contacts in 1 table. Another table contains a list of
[currently] 21 different committee's. Each contact may be a member of 1 or
more committee's or of none at all.

I have a form with 7 tabs that are labeled "Indicator A", "Indicator B",
"Indicator C", etc. Within each tab, there is a combo box, whose choice I
would like to be the label for the Tab. This would change when the user makes
a choice from the combo box, which is called ...

I'm trying to use Dlookup to prevent a new record from a form being saved to
a table if it is already in the table.  My problem is this - the records
contain a name and an award.  The award is created by concatenating 2
textboxes with a blank space in between.  In the "criteria" ...

I currently have a form (client accounts) within it a command button that
opens form (print options) the "print options" form opens as a popup modal
form and has a list of different reports to print.  I have been able to code
the following:

Is there a property to capture the windows login/username in the forms

I am trying to run a dcount in an unbound text box in a report using two
criteria.  One criteria is found in an unbound text box, named [age] in a
form.  (In this text box, it uses a formula I found on this site to
calculate someone's age using another field with their birthday.)  ...

I have an option group which controls the value in the 'OverallMark' field.
The 'OverallMark' field is unbound, but the value of the chosen option from
the option box field is stored here.
Each time i move between records, the 'OverallMark' field stays on the same

I've inherited an Access project and need to make some updates. I don't
know where to start or even how to word this question correctly.
When the form opens, it does a check on the username and assigns an
admin level.

I have an importroutine that adds records to a table.
I have to manipulate the files after import, so Access creates
_importError1, _importError2 and so on.
How can I delete all _importError-tables. The number of errortables  differ

I Have the following code for a command button to open up multiple instances
of a form
Does any one know how I can set the name of the new multiple insatnce of the
form .

can someone tell me what this means?
Public gintContactID As Integer
It is code that is in my database module and I am not sure what it is?  
Thanks.

I am using Access to send email to Outlook and it has been working fine.
However, the other day I happened to send an email at the same time Outlook
was (exact message) "...trying to retrieve data from the Microsoft Exchange
Server SMSS51M09."  This message pops up from Outlook. ...

I have created a combo box in a form in Access.   The combo box displays the
data sorted by name.  When I move through the names the related data in the
form does not correspond. ie: it should contain the name of the client whose
number currently displays in the client number ...

Using Access 2000
I have a table that contain  Excel, Word and Text files.
Is there some secret code that would allow me to open these files within
Access?

In the open event of SpoilForm I have the following:
Dim Job As Integer
Job = Nz([Forms]![ProductionForm]![JobNumber])
I want to use the value from the ProductionForm if it is available. If the