I have a combo box that's filled with values from a table. The field in
question is named "Producer" and that field has loads of duplicate names in
it.
Is there a way to limit the combo box list to show just unique names?

I have a form of Patients, based on a query.  Within that form, there
are 2 subforms, based on different queries (Transactions and Visit
Balances).  It takes about 7-10 seconds for the form to load and
populate the data, which seems much too slow, as there are only 900

Access 2003. Using basic M/S tabCtrl. There are 11 tabs for the 11 pages of
the form (0 thru 10). Page 0 is personal information and pages 1 thru 10 are
used for data entry. The form header contains a combo box which is Visible
when any one of the 10 pages is displayed. Want to ...

I have text box named "UserInput" that needs to lookup whatever name the
user types in then display all records related to the name they type. The
names are based on a field called "Producer" that's in my table called
"Application".

I have the following code in a TruckID control to
validate the trip date for each truck.  If I enter a date
previous to the last date, the MsgBox appears with "The
last trip entered for this truck was on " and the OK

my combobox cboSearch contains a list of surnames and forenames (as well as
the customer id - invisible)
according to a certain selection, the form displays the corresponding data.
fine

Using the code below to requery after a tbx is updated
But the form moves to the first record after update the tbx - how can i keep
the form on the current record?
Private Sub txtAuthCeil_AfterUpdate()

I have a combobox containing all the material available.  the user could
choose from a list rather than having to type all the stuff.
the combo box's data source is coming from a query based on a tblMaterial
just containing one field which is the pk as well

Hi I would like to ensure all fields on the form are
filled before a user exits the db?
I have a quit button on my form and it is there for
people to exit entirely from access. I need to validate

I have form that we I click a button it goes off to SQL Server and creates a
recordset. The records that are in the recordset I want to input into a
local table to run reports against
I use the following string and then loop through the records (see below)

I am running into a problem.  Sometimes the following procedure will run and
stop half way through (MS Access 2002 w/ the latest SP's just locks up and
stops responding).  When it does that it leaves the strSlipPrinter as the
deafault printer and does not change back to the ...

Does anyone have the code to change items in a select box, depending on which
radio button has been selected by the user?
Thank you

Access XP on Windows XP.
After using a form, I'm closing and then deleting it, all in VBA.
I get the error message saying that I cannot delete an open form.
My deduction is that, the closing of the form is still in progress when the

I wan't to do evaluate a number with < and > - is this possible?
Or do I have to nest a If-then in there somewhere?
Select Case AgeGroup
   Case Is < 39

I would like some help in writing a code for a button on a form that when
clicked a search is run to find the records with the criteria nominated in
the text boxes.
I am new at this and am not sure how to begin as I have never done codes in