I'm pretty new to Access and I would like to know from a performance
standpoing if there is a record / row size that is too big for an Access
database.
My record size will be about 4k to 6k and I will have a max of 10,000

The "Do you want to store multiple values for this lookup?" option does not
come up when I try to create a lookup column. Any ideas? Thanks.

I have a very datab ase which lists my clients, addresses and other
information about them - including their unique reference number.
I now want to create a database of invoices written in the last 2 years and
link this to the client batabase. If possible I'd like to autocomplete ...

I am looking for a simple Access application (2003 or higher), much like the
FedEx QuickShip program, except I only need the Shipping (with capability to
print shipping label) and View History features.
It would allow me to:

I have a database I'm trying to setup, it shouldn't be that difficult, but
I'm having a problem figuring out the best way to set it up.
The fields are Item, ItemType, Amount, and Year.
For me the problem is the Amount field. The Amount values differ, they

This is the third time I've tried to post this but it never appears.
I'm new to Access but have managed to compile a database that mostly suits
my needs.
My one problem so far is the need to present certain info in two formats.

I've created a simple CRM database suing Access 2007 on our companies share
drive.  We have a small office with only 5 people using the database.
Is it possible to collect from data off line while visiting a client and
sync to the database when I'm back in the office?

I am trying to create something of a survey database. I have seen the sample
database "At Your Survey", but I am not sure how to tweak it to what I need.
I have a form that is for safety observations. Supervisors will observe
procedures and mark them as "safe" or "at-risk". I ...

This shold be simple, but I can't find and info on it. When starting a new
record I would like to populate a field with the record number and save it in
in the table.

I have a table of Contacts.  Some of my contacts know other contacts, and I
would like to indicate that in their record.  However, for Data Type, I
cannot create a drop down list of contacts from within the table to choose
from.

I have no experience with access, so please let me know if this task is too
big.
Is it feasible for me to develop a databse for my private music students
that tracks and reports on the following:

I am beginning to wonder if i overcomplicate my database. i am going to add a
field to my T_partnumbers for unit of measure (UOM) and can not decide if i
should do it like i have in the past and use a combo (on my forms of course)
with a row source to a T_UOM with Ea, LB, OZ, Ft ...

Nagamori main business of Tape Tape for a variety of difficult and
specialized manufacturers of various industrial Adhesive. Sealing tape,
printing tapes, high temperature double-sided tape, PE foam, EVA foam, fiber
tape, cloth plastic, polyethylene imine milling tape ... ... ...

I have a list box that is populated as data is entered into the form.  (I'm
reusing a database that worked well, but needed editing for a different
project.)  In the original database, the records were identified
correctly--first item entered is record 1, second item entered is ...

I hope this is the correct group, my question spans several topics.
I have created a db from the Access 2000 time and billing wizard. Mostly it
works ok. There are about a hundred peculiarities that I do not yet
understand. But for now, this is the thing I have decided to work on.