I read somewhere that you can add a "All" option to a Combo box that will
display all records based on a particular field. I have a list of names and I
would like to have the option of displaying single individuals or all
individuals.

I minimize and hide the access window when my database opens.  Because of
this none of my shortcut menus show when the user right clicks.  I would like
to show the shortcut menus when the user right clicks on reports so they
might have printing options.  Is this possible or must ...

I have some code that I would like to use over and over again.
The code is used in the WHERE part of a query. I may also apply this
principle to other code as well.  It is quite long and used multiple times in
multiple forms and queries. I would therefore like to create a ...

I am using 2 combo boxes at the top of a form to help people search on
Lastname and client number.  They work well, however the text stays the same
as we move to different records.  How can I clear the text from the combo box
after the update is made.

OK this has happened to me a few times now so I don't think it can be purely
user error or accident.  Has anyone ever encounter the situation where you
were working along in your codes and a few minutes later you went back in
behind the form to look at something and found that ...

Windows XP, MS Access 2K
====================
Hi,
I'm having some problems with running the StartMDB.exe from the AutoFE

I have created a custom menu with the code from the button on my form in a
module. I'm using the exact same coding for my menu item as the button on my
fom, only replaced with public, function instead of sub and focus on active
form.   I'm getting ..."external name not defined".. ...

Is there a way to save data that the user entered in a combo box, when the
data is not in combo list?  That way new information is automatically updated.
thanks in advance.

I have a text box on my form with a button..on the button, I have the
following code:
Me.List0.RowSource = "SELECT POMain.poid, POMain.Date, POMain.PONumber AS
[PO Number], POMain.Source, POSource.Name, POMain.EDI, PORECINFO.RecDate AS

Hi,
I would like to "Logical OR" several Yes/No values in a subform, and then
based on the result, set a Yes/No value in a main form.  I  would appreciate
a snipit of code if anyone has some available...

I am reading data from two different spreadsheets.  One is a type currency
and the other is a double.  When the two values are different, it suppose the
perform the process but it doesn't do it.  What do I need to do?

I have a form that on it has a list box (lstClaimNumber) and below it there
is a label (lblClaimCount) to say how many claim numbers there are in the
listbox.  Below is the sql statement that is used to fill the listbox.  The 2
lines below the sql statement do the counting.  ...

I have a continuous form that shows records for every employee, and I have a
RecordSetClone ComboBox in the header.
What I am trying to accomplish is when you open the form, all you see is the
RecordSetClone ComboBox in the header, and when you select an employee, only

I have a button on a form which launches a second form having a calendar
control. The first form stays open. I set the calendar, and click a "Done"
button on the second form. In the click event (calendar form), I set a text
box (main form) equal to the selected date. So far, so ...

I created a function in a form that opens a report with a filter or not,
depending on what the user decides. The user enters the hydranttID in a
textbox in the form if he wants to print a report with the information about
that hydrant only. If he leaves the textbox blank, it ...