Here is a database design question.
A Client Note can be added for a Work Order at any time.  
This means that a Client Note can be added BEFORE the Work
Order is even received.  In this case, a WorkOrderID will

I am new to access!  Can anyone tell if you can copy from
one table to another.  My table are set up identical with
the same charateristics for each column - date/time or
text.  I am trying to combine two tables that pertain to

I recently upgraded from Access 200 to Access 2002 and
had been opening a MDB file that had been created under
Access 97 and converted so that I was able to use it in
2000. I tried to open the file today and get the error

I want to try to make this is understandable and
uncomplicated as possible.  I have asked for help before
and all that have answered have been nothing but helpful.  
So in advance I appreciate everyones help.

Hello: I am working on a new table, I am relatively new at
this.
I am entering the field names
Example: First Field Name [BRAND]-text-field size 10.

I have a customer table and a music table.  On a form,
based on the customer, I have a subform where I pick an
artist, then pick their album title.  What I need to do on
the subform is, when the artist is chosen, only show the

I have a relational database including look up tables (i.e. departments for employees).  On the form, I am then able to "pick from list" of the available departments.  Is there any way in which another entry can be entered "on the fly" with a caption such as "add new" to append ...

I'm want to set the fieldsize of some fields in some
table...
I use a For loop to run through all fields but when a want
to set the size property

I am looking for help in the design of a database that
you will be able to enter info about an aircraft such as
tail number year of manufacture Ect... Then in maybe a
sub form I need to enter each time the aircraft is used

In a table, how do a make a cell autopopulate with the
value the is in the cell above it.
For example I have 10 rows of weather data (wind, cloud
cover, temperature, ect).  For each record the temperature

How Do I Capitalize first letter of every word in a field.

I am creating a database containing accounting
information.  I read the Normalizing articles and watched
the Webcast, but I still have a question:
There will be information on Customers, Vendors, and

Just happened to notice in the Relationships permits multiple fields.
In five or six years of heavy Access-ing, I haven't ever run into a reason why you might want two fields in a parent table tied to two fields in a child table.
To the contrary, all roads seem to lead to a single ...

I have created an Access Project (.adp -- msde)
and i want to know if it is possible to limit the data
that can appear in a partcular column. i.e. if i have a
coloumn called filmType, how do i ensure that the only

How can I print out table structure from MS Access
database?
Thanks
TA