I am creating an Access database that uses information that is imported
through text files. I have 4 tables:
- tblLateData - 9 fields including ID (PrimaryKey), Order #, and ServiceCode
(empty)

Dear NGs,
First, I apologize for cross posting, but I just noticed this group and
it seems much more fitting to post this question here.
I recently downloaded and read a bunch of material on normalizing your

i'm working on teaching my .mdb to adjust an inventory value based on a
quantity that is shipped to a customer.  i've set up a tiny practice DB to
work out how to do this before i try to implement it in the real version.  
i've checked the value of my variables and i can calculate ...

My challenge boils down to this: I have multiple-users going after 1 table,
each user has 1 or many of their own records which they can read and update;
they can only look at other users records; e.g. user1 can read/update records
flagged a or b or c while user2 can read/update ...

New Problem 1: Have database file "Expenses" and created a similar database
"Medical Expenses." Now receive error message: Table 'TempMsysAccessObjects'
already exists' How to fix?
Old Problem 2: Cannot download MS Office XP Professional Updates for two

I am using Access VB and recordsets to create tables, and set relationships
between tables.  When a new dataset is loaded, I need to remove tables and
begin again. There will be differnt tables and different field names.  I want
to programatically remove most of the tables, but ...

I have a form that inputs data into a table. I have 3 click buttons. One Adds
the Record to the table (Goes to next record), another Clears the form(Undo
the Record) and I have a third that closes the form. If there is no test
entered, form closes. If there is text typed, and ...

I want to use System date as Consultation done by me on particular date.
How can I?

I need to know if there is a way to create a database by using more then one
catagory? For example I have 3 with using Suspect/Hostage which include their
demographics. How would I do this in a table/form?
Example: Name, Age, Race, Height, Weight, Color Eyes, DOB are in all.

I am trying to create a reporting program for our Public Safety Department
and they want the records to be automatically numbered using the format
YYMM-### (Example: first report for the month of Sept. 2006 would be 0609-001
then 0609-002. etc. and then in October 2006 it would ...

Is there anyway to set up a form using Name, Age, DOB, Race, Hair Color, Eye
Color, Sex more then one time? For example I have Suspect/Hostage
Description. There can be more than one Suspect/Hostage.

Can anyone tell me how I do I use the tab control? I added a tab control with
4 pages and I can't get the tabs to go in order after I enter the data into
the first page it automatically goes to the start of the form and new record.
Thanks

We have a nursery and I am trying to evaluate the inventory for the
government crop insurance.
My Table structure for the plants is a follows
ProductID - primary key

i have been tasked with coming up with a solution to accomodate a voting
session during a conference.
There will be approx 40 Voters.
Approx 50 Questions (all different formats; i.e. Best from 1-10, Multiple

how to write chemical equation the word have ability to write mathmatical
equation so plz i need an answer as soon as u can?
thanx