is there a way to select all using a drop down list?
I would like to give the users the option to select all available
departments from the drop down list when they want to query all records
rather than just one item.

I would like to have a form not save and not pop up the save prompt when a
user closes the form.  I'm guessing I just need to put some simple code in
the On Close event with the sub form_close().  But I can't find anything that
just says no save.  Please let me know what code I ...

what command tells me if i'm at the last record..
thanks in advance, m.

Friends,
when I cancel the form's unoad event I get the following error.
Run-Time error '2501':
The Close action was cancelled.

I already created a Function that is searching files, using
"Application.Filesearch" (see below).
But this does function not "see" HIDDEN Files (for expample a Word Document
with a setting "Hidden=True").

I am using a rectangle to display how full or empty something is; the
displayed information is based on user input from over 20+ bound textbox
fields and is also based upon an option group. The only way that I have been
able to update the rectangle fill is to use an afterupdate ...

I am needing to have a form(image) display for 5 seconds as soon as the
database loads, then load another form that the users can input data into.  
Any way to do this?

I have database with 10 tables, the main one of which has 80 fields and
13000 records. There is a main form which shows data from the central table
and has about 20 calculated text boxes, some of whcih rely on quite complex
vba functions to calculate.

This code reads 3 list boxes and produces the report based on those choices.
The last one "Reviewers" is giving me an error Type Mismatch.
Everything is the same as the other two, I don't see whats wrong???
Thank you....

My code almost works.
This code is from a command button on a form.  The user has 3 list boxes to
choose form.  My results reflect two of the choices.  COuld you please help
me add the third.

Hello,
I've encounter a problem with a subform.
Every time I scroll trough the records on my main form, I expect the data in
the subforms will be adjusted automatically.

Tony,
I get the later with no message see code below...
Private Sub Quantity_AfterUpdate()
  Dim intQtyMsg As Integer

Hi im currently using an Freedom of Information database and have a question
regarding searching the database.
there is a field called request details where details of the persons request
for information is typed in.

Using WinXP, Office 2003
How do I tell my DTPicker8 to be on yesterday's date when the form
opens?
Thank You

I have tried both pieces of code below without success, and keep getting the
error MS Access has encountered a problem and needs to close message??
Does anyone have any further suggestions?
Thanks