won't work:
Private SUB commandbutton_click()
ON ERROR  GOTO ERR
If ISnull(field) then

I have two questions:
1.  When I go to datasheet view, the names of my fields are the names of my
controls.  In the query design (the query is the form's record source), an
example of a field name is "#Yrs: ConvertToYrs([Num])".  On my form, the

I am running a parameter query off of a command button on a form.  I am using
an input box to get the parameter.  How can I modify the code below so I can
use a wildcard with the value passed? - example if I only remember the first
few of the document number and want to see all ...

Access 2002.  In a Customer's table, I have separate FirstName and LastName
fields.  The form's Record Source is a query based on the Customer's table.  
At the form or query level, I also display the first-last names concatenated.
I need to ensure, using code, that the ...

I have created a form (based on a query) for adding new records.
On the form there are these fields:
GuestID (Autonumber)
RoomID

I am trying to use a combobox and recordset clone property to search for
records in a form. The record selected in the combobox should be compared
with the record set and then the form record should be moved to the selected
record as follows:

Scenario: My Main Form (Parent Form) has a bound text control on it called
txtDateClosed that the user is not permitted to access.  The only way this
field can be completed if they Click a command button on the Parent Form to
open the other form (Child Form) and complete the ...

The table has four fields
Sport (field1)
Team (Field2)
Last Name (Field3)

dears,
I have test 1 and test 2 table with 20 records each. test 1 and test2 are
linked with one-many relationship.. it has a field for autonumber e.g. fieldx
presently the fieldx is at record no.20. now when I want to enter real time

I am using 2 input boxes (startdate and enddate) on a Supplier Form as
criteria in a query so that I can display purchases between these dates.
I also have the above showing by supplier.
When the queries are first created, it all seems to work ok and reports can

Well everyone, I'm happy to announce that I got it.
I can now check the status of my printer in Access.
Whenever I got to print a report, if the printer is Off-Line, Out of
Paper or whatever, I have a form that pops up saying that the printer is

If you have an Access application on one machine at location A, can you
go onto it from Location B (Located offsite, another city, wherever)
view the reports on Location A, from Location B, and print them to a
printer connected to the computer at Location B, from Loction B?  I'm

If I have 5 unrelated tables with data that I will be concatenating together
once the user selects 1 field from each table, do I need a common field to
link them all together?  When I bring all 3 unrelated tables together, the
number of records grows exponentially.  An example of ...

In Access 2000, we have an app which has a back end mdb and a front end mde;
the tables bing linked into the mde.
At present, any of the users could open the mde by holding down the SHIFT
key and clicking on the icon.  The mde opens in development mode, giving

I Have a data base form that is tabbed to have several sub forms. I created
the first form "Contacts" and then created a form called "frmRegistration".
In
the registration form I have a combo box that I can select a building and