Can someone tell mt how to get a "All" value in a parameter for a query. I
have two parameters for a query, the fist I would like to add a parameter,
but the second I would like to have the option to not add a parameter, so
this would fill the field with all records that meet the ...

I want a macro to be run each time a user uses the standard scroll buttons on
the bottom of the form to scroll through records.
I have tried the most obvious events on form (before/afterupdate) but i cant
get anyhing to work.

I have a help document in Acrobat which i want to open when im using my
database. I would like to have a button which would open this document when i
click on it. Can this be done?

We are attempting to convert our existing Access jet database to MSSqL.
We have a Form on which is a Combo box that selects records for a subForm.
The current syntax for the Event procedure on the main form that selects the
records for the subform is as follows...

small business only 4 emp.1099 forms. just need to chart expences and profits
ect. also have office in my home this is a del. service pay is tips only

This box appears when I am in the main form for customer details and I
attempt to access a linked form registration more than once.  I have to exit
the main form and re-enter to look at another customer's record.
You tried to lock table. while opening it, but the table cannot be ...

once i selected a value in the combo box i dont want it to be avalible to be
selected again. this is in use as an appointment system eg. if i select a
time for an appointment i dont want to be able to pick the same time again to
prevent double booking

Is there an easy way (before i create a form and use that) to create tool
bars with large icons on similar to that on outlook express etc?

I managed to get a template in Word to read data from Access as a mail merge
document.
If this is the correct way to send letters to database held contacts, how
do I stop users of my mail merge document messing with the template? I have

I need to undertake a check on a field content.  If the
field is blank (ie no record exists) than the field can
be edited and the record added.
However, if the field has information stored in it, I

My application has many forms open at once and I need a way to step
backwards - one form at a time - to get to some earlier one.
Can this be done with a function key, and how is this done?
Frank

When I display a table within a subform in datasheet mod,
the background

A friend created a form for me in access that has check boxes.  However, its
not allowing to select any number of choices from the set of independent
choices.  It's functioning functioning like a option button control (only 1
choice) .

I have a combo box with the drop list based on a table. The drop list have
two columns with the bound column assigned to the first column and is based
on the ID field of the table. The second column is the description (text
data type) of the item of that ID field. I set the ...

Hi. I have ComboOther on my form that has a row source:
SELECT Member.MemberID, Nz([NickName],[FirstName]) & " " &
[LastName] AS [Member Name]
I want the default of field OtherName to be