I'm trying to find a listing of definitions (with examples
if possible) of all of the 82 available property options
in Access (something I can hang at my desk for a quick
reference).

I am trying to merge the current record into a document. Word fires up ok,
but when it goes to get the data it spawns a new instance on Access.
The screen flickers and if you can see the error message it is from word who
spawned the new instance of Access and it complains that ...

I'm using list boxes that my user can use to enter data
into Forms.  Is there a way of letting the user select
more than one row at a time from the list and add them to
the Form?

We have a few reports designed for paper size a4. This
reports were originally developed for european users. now,
we will have to distribute the same reports to north
america. the problem is the different paper size that is

I understand the difference in Dim, Private, Public (Global) as to the SCOPE
of the variable and where it can be used.
My question is: What are the pros and cons of keeping a variable private as
apposed to declaring all variables as Public in one module. I am working on

I have a several Forms with several enterable fields.
After I enter data and hit [Enter], the fields go blank. I
can leave the Form and come back and the data is there. I
am assuming that when I hit [Enter], Access is opening

I have been trying to figure out how to use the afterupdate function and I
need some help.
In a form I have a combobox and I want to lock the value in the box once the
user has entered/chosen a value - how do I do that???? I can see I need to

I have a form with a tab control having 10 pages. Each of the 10 pages can
have 10 comand buttons. I can create the code to populat the click events
behind each of the command buttons, but at the end of the day, I have
hundreds of repetitive events.

I have installed to a new machine and the default units are inches.
Where do I find this option?
Thanks,
Robin Chapple

I am working with Access 2003. I have two tables, the first being
COMPANY and the second being VENDOR. Each row in COMPANY and VENDOR
are unique, however there is a one-to-many relationship. For every row
in the COMPANY table, there could be tens of rows in the VENDOR table.

I have a field [Last Update] and I am attempting to add a literal
instead of a separate label. I am using:
="Last Update " & format(Last Update, "medium date")
and I get the error message Invalid Syntax.

I have a simple database with one table that has the fields userID,
date, comments, votes. I need to figure out how to setup a query to
list each id only once and also total up the number of votes that id
hade for the previous month. The userID will have about 60 different

I am new to Access and I was wondering if there a way to
have the field headings in the datasheet view align
vertical instead of across (like, row headings instead of
column headings?)

I am very new to Access, but have a good knowledge of other microsoft products.  I am plowing through this on a crach couse trying to learn access.  I am doing alright, but ran into a problem which is probably simple but I don't know what to do
I am using Access 2002 and was ...

Here is my problem, I designed a database that has mupitle
users, I have a subform that has 22 fields of data.  
Problem is that when someone goes in an updates a field,
like the Date, the old one is over written.  I would like