I have a combo box that is set up like this:
EmployeeID
Last Name
First Name

I have read the Help file and searched Google and Access sites for info
on this problem, but still cannot get it to work.
Firstly I a job info form (Pop-up - Modal-No, Has Module - Yes). In that
form there may be a reference to a previous job, in a text box

Can this be done?
How would I trap the error and present a more freindly message like "You
cannot have two cars with the same registration number" rather than the
complex, non user freindly message that access gives me.

I am trying to cancel the action if a user deselects a check box that the
domain count for that specific checkbox (blnAdmin) < 1.  There has to be at
least one record with the check box = True.  I have played around with this
and can't seem to get it to work.  On the error when ...

The command button wizard generates the following code to save a record.
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
I have been using docmd.save
What is the difference between these two? Are there advantages to the way

I have an app where the user enters sales over time. What is the most
efficient way to display the current year and current month sales on each
form? That way the user has an idea of where they are as tehy enter each
sale.

Any idea how to determine if a specific page of the tab control is currently
being displayed? For example, as the user moves through the recordset using
the form's navigation buttons, which page is being displayed?

I am doing something need data exchange between forms
is there any way I can call a function or sub of a form from another form.
actualy,
I can pass parameter using some txtfield.

Is it possible to set it higher than the 255 limit, by code or otherwise.

When I have a continuous form open with records, I can
specifically save the current record by
doing "shift+enter" (or save from the records menu).
How is that done from VBA?

Getting the time down to milliseconds.
I am trying to get the time down to the millisecond so I can use it to
create primary keys.  Can I get the time down to the millisecond in Access
2002 in VBA?

I'm a .NET programmer trying to throw together a quick Access app but can't
figure out the object reference methods.  I've got a main form with two
subforms, each in data sheet view.  Datasheet 1 has a client list, datasheet
2 has a project list (multiple prj per client) and the ...

This is probably the wrong group, but you have been so helpfull in the past
I though I would ask here.
What I have is Public function that prints Word doc file. Now these are
really just forms we have the tenant's fill out so we pass no data from the

I have an employee information form that has a yes/no checkbox for the
employee to be an administrator.  There must always be at least 1
administrator or they will not be able to login to the options section(which
is where the employee form link is located).  What would you put ...

  I want to open a new XL workbook and paste the recordset from a subform.
  Then I want the user to close (and ev. save) the workbook.
    Dim appXL As Excel.Application
   Dim xlbook As Excel.Workbook