Rookie post.
I am under the impression that when creating a report in Access 2003,
you can use only one "record source" (query or table) to provide data
(acknowledging that several tables or queries may may be used to create

I have a form page configured to open at a new record when selected. I would
like the insetion point to automatically select a specific field when this
form is opend. How do I do this?

Is it considered good db design to ALWAYS have an autonum field as the
primary key -- say, as opposed to some unique data field, like part
number or account number?
If so, what are the reasons?

With lots of help from Ken Snell & Doug Steele in the General Questions
Forum, I was able to create a module that lets the users choose a file for
import. The module is the api calls from
http://www.mvps.org/access/api/api0001.htm  It contains a number of

Thanks in advance to anyone who can help me...
I'm trying to write a query in code and am getting the message that "A
runsql action requires an argument containing an sql statement.
I used the query designer to create the query, then copied the sql statement

I added a new column to a databse.  Now whenever I type data into a cell all
cells in the column fill with the same data.

what is invalid handle address? I have tried to enable Microsoft office.com
but it won't allow any clip art to download

Anuone get any hints for building data dictionary or can anyone suggest a web
site for good info?