Greetings.  I have a table (tblLastNum) containing the last report
numbers for several sites, such as:
AL    001
MS    009

I've got two tables: Products(Prod_ID, Prod_Name) and Systems(Sys_ID,
Sys_Name)
Systems are made up of multiple products.
I've got a Systems form which references the list of Products.

Hi, I need help with run time errors.
The application is running on Access 2002.
It is recordset, loops the records from query, one by one row,
in ADO it gives error 80040e21, invalid argument, -2147217887,

When the following  runs, I get error saying "Jet can't find input
table/query qdfMarkedAddnlOwnerRecs"  The error occurs in
line #150  Sub cmdSaveVehicleRec_Click()  frmVehicleEntryForm.
120         Set MyDB = CurrentDb        ' Set MyDB =

I'm thinking this ought to be easy (just not for me - lol).
Field Price has values like this:
12500
9999

I have the following code as the control source for a textbox on a subform:
=IIf(Form.Parent!grpPayFixed=2,Form.Parent!txtStrike,[Float])
This code had been working in the past, but now the continuous form's text
box is blank.

Hello Friends
I am asking a very silly question but i dont find any solution fo
this..
I am selectiong a recordset and want to populate a combobox where id

1- What is the AutoExec Macro?  Is it the same thing as AutoKeys Macro?
2- I'm looking to Control Keys equally on startup for my entire app. I
understand that
  the AutoKeys Macro is the place to go but it seems that some keys

Say I'm walking a subset of the records in tblAddnlOwners
via DAO. Suppose there are 5 records in the extract and that
I MoveFirst, MoveNext and MoveNext. Then,
when on the 3rd of 5 records, I determine the

ok I was generating a combo of things into a unique identifier.
Private Sub generatenumber()
Dim db As DAO.Database
Dim rs As DAO.Recordset

Hello friends
Can anyone tell me how to deselect the item selected in the list box
If Me!lb_test_property.ItemsSelected.Count > 0 Then
   For Each varItem In Me!lb_test_property.ItemsSelected

I have recently inherited a database. The switchboard (and other forms)
displays the name of the database on it (top, center). Currently the
name that appears is Reviews. There are plans to roll out the
application (i.e. making copies of the database) to other locations

I got a problem with VBE6.DLL (VBA reference)
On my machine everything work well.(access 2k, vesion dll 6.0.84.35)
First machine NO PROBLEM (access 2003, vesion dll 6.4.99.72)
Second machine problem (access xp, vesion dll 6.4.99.69)

I'm fairly new to access and the way it works and I have been building
a relatively simple database.
It is basically a database where staff members can search for what
training they (or others) have completed by staff name, staff group or

OBJECTIVE: to be able to see the last 10 customers i've seen in a
certain form (call that form Exchange).
MEANS: a date field in the Customers table should be set to Now() every
time I move a record within the Exchange form.