I want to create a new table and have it linked to another table. I want to
move all the data from the primare key to the new table so that I can link
them. How do I copy the data to the new table (column)? Is there a better way
to link these tables? Don't they have to have one ...

I am using Access 2003 to construct a database for work.  This database will
be used by multiple people, so I was going to split the database (putting the
BE on the network server and the FE on each pc).  This is my first time under
going this process, so bear with me.

I have been working on adding some reports on the same access program
that is in two locations.
Can I just copy and paste the reports one program to the other or
import the reports from one to the other?

I'm use an access to create a text file which includes dates.  The
file export to a .txt comma delimited file works ok, EXCEPT:
The date, when it appears in the text file also includes the time.
The Access (Office XP version) does not include a facility to strip

I have two data bases. One from 2003 and one from 2004. All have 4 position
alpha-numeric  ID. Is there a quick way to compare both lists, for matches,
for omissions, for entrys in only one or the other. This without manually
matching one to one. (there are thousands).

using the command wizard, how do i create a command button on my access page,
that will bring up a word document?'

How do I go about creating a database to log pdf or word document like
machine calibration certificates that is mail to me.I am looking for a system
that can be used to track the dates of these aswell as expiry dates, but I
also would like to have a quick link to the actual ...

I want to abort the menu of an existing app and get to the main Access screen
so that I can begin to make modifications to the app.

I'm trying to design a table and a form. There's a fieldname  called Smoking
in my table.This smoking field name has a boleean data type.It  asks if the
patient smokes and if yes the the checkbox will be ticked and no it will not
be ticked.There's patients whose smoking status is ...

In an older version of Excel I remember using cells from another sheet in a
formula. Sadly, I did not save an example. In my 2003 Office Professional
version I can't seem to do that. Can anyone show me an example to access, say
Cell F18 from sheet X in a formula in sheet Y. Also, ...

i working in software company in my company our all work in workgroup i am
admin if i want to see my netowrk on perticular pc which setting in xp on my
pc or client pc

How can I set up a field in a data base to automatically be filled in based
upon the users selection in the switch board.Example if the user selects
project 1 in the switchboard when he goes to the form the project name field
will automatically indicate project1

I created a database table and am using another table as a "lookup" for one
of my columns.  The problem that I have: I want to be able to select more
than one item from the lookup table for each field.  How do I do this?  I
can't use checkboxes, becuase there are too many ...

I just purchased the Microsoft Student/Teacher addition and found out that I
would be needing Microsoft Access also, How can I do this?
I guess I should have researched better and purchased a version with Access.
Thanks for your help.

i have an mdb that i can not open.
it gives me a sharing error when i try to open - even with shift key or when
i try to import objects.
what can i do?