Is is possible to merge some 100 small tables into one
table, without having to create one make table query, and
then appending all the others in an append query.
The tables al be gin with the same word OUTFUT then a

Hi i was hoping someone could help me with a problem im having in access.
I have a many to many relationship between two tables tblPerson and
tblDoctor. These are related in a third table called tblLine which has the
primary key from tblPerson and the primary key from tblDocotr in ...

Is Access a DBMS or RDBMS

I have a form that is in two parts.
First part is the bio info. I want that after the user clicks on next button, that it goes to the next part of the form.
At the moment, the second part is just below the first. Is it possible to bring part 2 to the of the screen?
Thanks for your ...

I go to create a database from template and get an
error:"ActiveX component can't create object" What should
I do to fix that/

Can anybody help me with the following, hopefully simple, question?
I have two tables. I wish to add a new column to the beginning of each table
and to fill them with incremental values e.g. if one of the tables looks
like this:

I've recently, with a great deal of help from this group, been trying to
set up a system for an acupuncturist to keep records of what points he's
used in each session with his patients.
Doubtless I'll be back with several more questions as the project

I have a somewhat ordinary Purchase order with a header form and a subform
for detail line items.  I would like to be able to add items to the detail
by opening another form of all available items and selecting one item at a
time.  As each is selected they need to be added as line ...

Using Access 2000 on Win2000Pro
I have a date field in my data and I need to group and sort summarized data
by YearWeek  but the format() function is not doing what I need it to do.
The format function defaults the first week of the year as the week

User is part of precomputer employees. He keep 25 folders
numbered 1-25. With one complaint record in each folder, as
complaints were taken care of he moved them to other
folders grouped by date. I tried an inactive check box and

A very basic question, but can anyone tell me how to
change the default from metric to inches.

I've created a form in Access, and can input some
information direct to the tables, but when I try to do it
via the form, it tells me that the form is read-only. I've
checked the fields, and they all have "Enabled: Yes"

i have a form that is order/ordersubform:-
orderform
 ordernumber
 orderdate

Can MS Access be installed on a Unix server?

I'm having problems executing activex controls from Access.  I can add the
controls (checkboxes and radio buttons) the form w/o a problem, but when I
switch from design view to form view and click the control, I get an error
method before the xxx_OnClick method is entered.  Here is ...