When I define a form based upon a table then I get this
feature on the bottom of the form that allows a user to
scroll through the records. Can I suppress this so it
doesn't appear?

Thanks for the help.
I solved the problem by creating a macro named AutoExec
and selected Maximize.  Apparently Access will
automatically execute a Macro with the name AutoExec.

How can I sort (in a query) a column consisting of 9 numbers, in terminal digit order?

I have a simple question (to anybody who isn't me)
I am launching a form called Shipping from another form
called Completed with the following link criteria;
Private Sub Shpd_Click()

I have a table where there are numbers stored for the
values.  How do I get those numbers to print out the
corresponding words in a report.  Example 1=yes 2=no
3=sometimes.  I have the beginning, but how do I put the

Hello, how can I do this?  I have 2 fields.  I need to have what is inputed in field1 be ADDED to(not replaced) to field2.  Also, after the update i need to have field1 empty again.  Any ideas?

IF I have 2 table (A & B) and I want to add them to the quanity of table C.  How would I do that.  But I want table C to be a running total
So if table C =  10
and I add 5 to table A and 10 to Table
Then Table C updates to 115

I have created a database with a form that comes up as an
initial menu.  Unfortunately, the form isn't maximized
inside Access, but is windowed.
I have noticed that whenever the database window is

I have a button on a form called "command9". When this is clicked I want to go through all the entries of a table called, "Device Table". I using the following code:

I have a table of customers, which includes contracts
they hold with our firm.
Most customers hold one only contract, however some hold
two and three and a few as high as 5.

I recently upgraded computer including a larger monitor.
When I now run my databases, they fill about 25 percent
of the new screen. How can I enlarge my databases to fill
more of the new screen? A couple of other questions -

Can someone tell me what's wrong with this statement?   I keep getting a
syntax error when I try to add a combo box to this form.
SELECT DISTINCTROW Contacts.UNIQUE_ID, Users.Name AS NovoName,
Contacts.Company, Contacts.Contact, Contacts.IDStatus, Contacts.[Create

Dear Friends,
I have seven tables(various details) linked to one table
(name)I created a query and form. But couldn`t add records
to linked tables.

I am getting the error above in a multiuser access 97
database, when users are adding or deleting records. I
have the form set so that a user can only see his/her own
records. The record lock is set to Edited Record.  The

One of my clients has a machine which has Microsoft Office 2003 Standard
installed.
We need to add Access 2003 to this machine. Do I need to purchase the full
version, or does Office 2003 Standard qualify me for the upgrade version?