How do I print out a query design (as per design view)?

The database exists without a primary field.  I now want
to add a primary field.  How can I do it at this late
stage.

Each time I load my database in Access 2003 I am prompted for : 1)  unsafe
expressions and 2) upgrade to Jet SP 8.0.
How can I turn these off?

I was looking through this newsgroup today and came across this website that
listed the "10 Commandments of Access":
http://www.mvps.org/access/tencommandments.htm
My question is about the second commandment, which proclaims lookup fields

Ok I'm posting this here as you guys have been so helpful in the past.
I've been asked to do a query to work out the total working hours taken to
do a job.  I've done it as a function because its the only way I could
figure out.

Basic, but I don't find it:  how to set column width in an Access
report.  I have double-clicked on columns in the base table to make
them narrowest and have tried using Design View.  Pulling lines in
Design View cuts off heading names but doesn't narrow basic column

When I open up Access 2003, by clicking on an .MDB, the object screen that
has the Tables, Queries, Forms, ... is always minimized.  Can the default be
changed to open as maximized?

Can someone explain to me what is the purpose of using more the one
primary key in a table?
What will be the result of doing so?
If I have a table of Products which has two primary keys:

The original field has 1, 2 or three characters, i.e
1, 12, or 1234.  I need to put preceding zeros so it wil
always fill up five spaces, i.e.
00001 or

Hi, long time lurker first time poster
Have an issue when I try to delete a record from a form, the msgbox message
I coded in to confirm the delete pops up fine,when you click yes on that it
brings up that "you are about to delete 1 record(s) ..." message that you get

Hi, I have a simple one table database for photo equip. I want to make a
form that will have a search button on it with a text field next to it, to
type in what I am searching for. I want to search the "Description" field on
the table (called) cameratype. I need to be able to type ...

Could someone tell me how to resize a control like a label or listbox when
the form opens to be the EXACT same height and width of the forms detail
section?
For reasons important to me, but not essential to describe here, I would

I have a list of facilities in a combo box.  Once I
select a facility I would like the address to appear in
the text box.  I'm stumped any help would be greatly
appreaciated.

With A2K, I have a split database, usual set-up with
tables only in 'back-end' with a .mde 'front-end'
distributed to about 15 users.
My question is about reports. Is there a technique for

I'm having trouble getting my switcboard to become the first thing to load up
when I enter my database. Also, a similar problem, I do not want anyone to
see the amount of records that are in the databse, but when the form is
opened to enter data, on the bottom of the window is ...