I'm looking for some information on how to best design a transaction table
for monthly payments in regards to rentals. The specifics things I can think
of is each account has a account number and each unit has a number. Payments
are posted using both the account number and unit ...

I am trying to create a database for payroll.  I need ti insert formulas in
access. Can anyone refresh me on how to do that?

I am trying to create a database which needs to have formulas in it for
payroll. How do i create the formulas in access?

1. Does anyone know why/how an autonum field in a table in Access (2000) can
jump from 837 to 258978675? If I do an (SQL)insert, then a DMAX, I get
258978675 (or whatever is the next (high) #).
If I do a manual insert, then 838 is allocated as the autonum field. On a

I've thought about using Outlook but have kind of gotten off that idea for
awhile. I'm thinking of just setting up a table that will list the things to
do for a given day and loading it when the program starts with an append
query. Now the things that I want on it are 1st of every ...

How can I over ride an individuals color settings for
windows menu bars, command buttons, and tabcntrl objects
in an access form.
Some users on my network have chosen some hideously dark

A question to all the smart guys and girls out there!!
I'm trying to create a correspondance database for the office in which I work.
We get meeting requests, invitations for functions, and general
correspondance.

How can you set a primary key number (autonumber) to start
from a particular number - eg "10000"
I have invoices issued from an old accounts package - and
am creating a new database to replace it, but do not want

Here is what I have so far (on paper, not in practice):
STUDENTS (table)
StudID (PK autonumber)
StudFName, StudLName, StudAdd ....& other details, also, I included other

I have a database that is split when I try to create a One to Many
relationship between tables I am not allowed to select the cascading options.
I have tried with different table combinations but none have allowed these
options.

How do you set up a make table quert to have a blank row and auto number that
row then assign that row as a primary key?
Thanks,
Corby

Hi All, please help me with this problem.
I have a database that has its own Menu and Submenus, and a document in Word
that uses Mail Merge data from this database (I could have created a report
for this document, but, as far as I know, Access does not have the JUSTIFIED

I created a check box in a table; my intent was to create an option group.  I
created an option group (3 choices) in form design and it works there but in
the corresponding table theres just the check box that was created in table
view.  

I used Frontpage to update my website.  All the changes (added some links,
removed some text) were saved and everything seemed fine; I opened the site
and checked that each change appeared.  The next day I was unable to open the
site in Frontpage (can't find server on port 80), ...

I would like to know if it is possible to import data into an autonumber
field and maintain the current data in the field.