With help from Klatuu, I was able to refine some code that I have previously
written to remove a filter and move to a specific record. I then needed to check
the status of the record before allowing the move to the new record.  I did this
using a function (see below). The problem ...

I set up 2 list boxes.  When the user clicks the create button, the left list
box is populated with all the available model #s.  After the left box is
populated, the user clicks on as many model #s, as required in the left box.  
He then clicks the copy button and the model # is ...

I have a form that show various insurance claims; WC, MVA, GL, PL.  I have a
subform for each type of claim showing various details of each claim.  Is it
possible to have only the corresponding subform show depending upon the type
of claim the current record is?

I have a form field with transparent background.
If i use conditional formating and conditions are not met it changes the
transparency to normal showing then background color White.
Is it possible to use conditional formating and only change the background

I have a continuos form with a command button that I would like the caption
of that command button to change depending on the transaction type of the
record.
For example, if the first record displayed is transaction type "123" then

I cannot get the conditional formatting in an embedded report to
work.
There is no VBA involved.
The conditional formatting value (through the Access tool) is

I have a multi-user database that I want to send to others so they can try
it out.  The problem I noticed though is the drive letter access looks for is
the one I created the database on which is "G".  Is there a way to tell
Access to use the current drive (whatever the drive ...

Hi
Hope you can help. Im building a purchase order form within Access 2003 and
i would like the form to auto fill in the supplier details from another table
once i have chosen the supplier from the unique id drop down menu on the

I have a form with several unbound text boxes.
txtSTART_DATE
txtEND_DATE
txtTOTAL_WORK_DAYS

Is there a way to do conditional formatting in a listbox? i.e. row different
colors according to criteria? I have Access 2003
Thanks,
Sam

does anyone know how to play a 'wav' file in access 2007.  All i want to do
is play a 'wav' file when two conditions are met?

im trying to change the 'control source' of the field "balance" from the form
"HSBC Form" at the click of a button...
here's my code so far:
Private Sub Command13_Click()

Is there an API cal I can use to get the operating system?
Thanks

I have a text box on a form where the user can enter their password. I have
the following code to not allow the user to continue typing more than 4
letters into the text box:
Private Sub Password_KeyDown(KeyCode As Integer, Shift As Integer)

I have an insert function on a form in VBA (see below).
When I try to insert a record the record is displayed on form but the
following error message pops up:
The Microsoft Office Access Database Engine cannot find a record in the