I have a report that I want to do a filter on based on what someone selects
on the form.  I keep getting errors on this expression in VB and can't figure
out where I've gone wrong (I'm sure it's the quotation marks or something).  
Please help:

I keep getting an error on a Dim statement saying that the word "database" is
a unknown user defined function. I am working on this database as the orginal
developer died and I am kind of baffled by certain database calls do not work
with it. The code I have under a click event ...

(A2003): I've got a combo box that I've setup to dropdown as soon as it gets
the focus.
I would like my users to be able to use the up and down arrow keys on the
keyboard to select an item in the combo box, but whenever I press one of

I am pretty new to this, and have been driving myself crazy trying to figure
this out.  Any help is tremendously appreciated!  I am trying to make what I
thought was a simple recipe database.  I have a main table and connected form
for each recipe.  I am trying to create a second ...

I need to issue a warning message if a set of conditions apply to the current
record. I need to do this when I move off the record WHETHER OR NOT I have
made an update.
Currently, I have the code in the 'before update' event and the users are

I’m having difficulty with a case statement.  I am validating that specific
fields in a form are filled out.  Below is the one case statement that
doesn’t work  When the code gets to this point, it apparently bypasses the
remainder of the case statements and saves the form.  When ...

I have a form with a command button that opens a report in preview. The form
has a combo box from which you select the record that should be shown on the
report but when I click on the command button I get all the records not just
the one I have clicked What's wrong with my code?

is it possible to have a switchboard menu item function as a hyperlink when
clicked? Nothing I have tried seems to work.

I'm sure I'm making this entirely too difficult.
I would like to limit the list of one combo box based on the value chosen in
another combo.  That would actually cascade on down.
Think of it like the first combo you select the state, then based on that

I have a form with 17 checkboxes (yes/no).  On another form I only want to
see the checkboxes that have been checked (yes).  This is easy, but the hard
part is to not leave empty spaces on the form that are where the checkbox
should be.  I have seen other posts about right ...

I have a form whose controls gathers values from various sources (some table
data, some user-entered data) and then writes the provided values to a table
record.
There is a list control on the form that is currently populated by a lookup

When a bound form is openned, it automatically loads the first record of the
bound recordset.  How do I prevent this from happening?

I'm trying to pass a value from my modal popup form to a text field on
another form.  Works great except that only the index is passed.  Any way I
can choose which column gets passed to the text box?  My popup form uses a
combobox to select employees from a list.  If the user ...

In my Access application, I just referenced another mdb file that
contains an email application I want to use.
In my application, I now see the forms and code of the email
application.

Hi I have a button on a form that prints a report based on a query i
do NOT show the report it just prints the report when the button is
clicked however i would like a message box to show how many pages are
needed to put in the printer to match the ammount of pages printing