I found some code that lets me Filter a Report from a Popup Form. It uses 6
combo boxes with each box filtering my VehicleRecords table to the record I
am looking for. The code for this can be found here:
http://support.microsoft.com/kb/q208529

Can I turn off the Access error messages and replace them with my own
message box message? I thought I'd seen something about this in this group
but I've searched and found nothing.
Thanks

I would like to implement a filter on a form (using a command button) where
the situation is like this:
1.  the first parameter would ask (or have an input) for a code; this would
come from a series of fields (Source1-Source10) where "03D" for example can

I have 3 fields on my main form that are required fields, what I would like
to do is have a custom error
message that would say which fields need populated: ex "Customer Number and
Region must be completed"

Hi there, I have a main form (frmmain) with a combo box (cmbsitename)- with
different companies in it. Once the company has been chosen it then fills in
the rest of the form (fields that are locked), I then want to be able to edit
this data, so I click on a button (cmdsave) and ...

I have a database that logs truck driver hours. I cannot get it to total
only the most recent 6 days and 7 days and display that total for me in
both the form and reports. I am sure this will have to be done with VB, I
am just not VB savvy (yet). Can anyone help?

I am trying to assign a value to a variable (NoOfRides)
based on an SQL statement. When I run the procedure, I
get an error message saying "Run time error 13. Type
mismatch"

Is there anyway to retrieve the first character for each word from the field
formatted as text?
Example:
On the field there is "Ministry of Foreign Affairs" and we retrieve "MOFA".

this is more or less a pure coding problem in VB
I have a 'StudentSearch' form which has many criteria, Fname, Lname,
University, Course etc which are put in through text boxes or drop down lists
and the results of which appear in a listbox called Results.

I have created a form with 5 option groups.  Each group consists of several
options.  I then added a command button.  I added some/any code in the ON
CLICK event.  I then attempted to click on the button, i was presented with
the following message:

I have a form that has a tab control with 5 pages. On Page 4 is a calculated
control  (txtClientsTot) that I want to compare with a calculated control on
Page 3 (txtTotNbrClients).
I am using this code in the BeforeUpdate property of the control on Page 4

trying to query records in a large database and find records matching the
autonumber of the record and a class ID and training date range in another
field
When i use 5 or 8 or 689 or 890 the query returns records .

If i am on a sub, function, or module
Is there a way i can print the name of the sub, function and the module i'm
am right now?
--

I am getting an error message in a database when I use the Package Wizard to
convert my mde file into a distributable that I don't get in the original
.mdb file. The error is No. 3320 stating "Function is not available in
expressions in table-level validation expression".  Can ...

On a continuous form I need to enable or disable a checkbox based on the
value in another field.
Conditional Formatting is not available for checkboxes. Has anybody ever
done this some other way?