It must be the most frustrating piece of code in the (Access) world for
those of us with selective memory...
I want to look up a value of a field from a table based on the user's entry
in another field.

Firstly I hope I am posting this in correct forum ...... please advise if I
am not.
I have a table with 6 fields. I have a query which outputs records from that
table where one of the fields has a null value. I have a form with a listbox

Jeff gave me a great bit of code for error checking, and I want to use
something similar to see if a person tries to enter a restricted area if
they are too young.   No, it's not adult-related, but a student
work-experience issue.

I'm putting the following function in the "Before Update" event of a date
control on a form like this:
   =fncTestDateLimit()
Here's the function (it's in a regular module, not a form module):

Could I make sure somehow that, when a user clicks the NEXT button, and the
recordset has arrived at the end EOF, that the next button doesn't offer the
option of going to a new empty record.
For now a user triggers an error message saying that null values arn't

Is it possible to detect the current database is read only? If so, how?

I need for all compares in queries, keys etc. to differentiate between
upper and lower case.  How can I do that?
I have imported data that uses as the key a field that uses a different
meaning for an uppercase letter and the same letter lower case.  I tried

I am having some trouble with a combo box that is embedded on a subform. The
main form “Customers” has a subform on it called “WebDataSubform”. On this
subform is a combo box called “Location”. I want the combo box locations to
be specific to each customer but cannot for the life ...

I have form_A with a query as the record source.  I call form_A from
form_B and use parameters (Invoice number) as criteria in the query
underlying form_A.  I also want to call form_B from form_C using invoice
number.  How do I pass the invoice number to the query? Or should I ...

I getting a bit rusty and have run into a problem where a standard call on a
command button's code of
if me.dirty then. . .
produces a 2455 error message stating that I have entered an improper

ive got a form which totals up different costs depending on whether they have
been selected or not. If they have been selected they are given the value of
the textbox otherwise they are given 0.
The values are stored as InternetBill, ParkingBill, RentBill etc. This is

One of our windows XP  PC's has stopped running switchboards on Access 2000
databases.
when a switchboard starts the following error is generated
Run-time error 2147024769 (8007007f)

I'm looking for a way to verify that a database is open after running the
OpenDatabase method.  
I purchased and ran the AccessAnalyzer (very cool tool) and one of the
peformance recommendations was to open the database for linked tables.  I've

I've got a form that I'm using to call a routine which will query a table
(tblWorkOrders) for the number of records matching a certain type (stTemp).  
My code is as follows:
Private Function QueryWorkOrders(ByVal stTemp As String)

I have created a database that is on a shared drive. There have been several
occasions where someone accidentally presses the delete button and erases the
customers name. I have no way of getting that customers name back. So, I
wanted to know if there is a way or a formula I can ...