importing

I have two access databases can I import them together? If I can how do I do
that? I'm new to access and any help will be greatly appreciated. Thanks in
advance.

On Thu, 7 Feb 2008 12:46:01 -0800, Terry
wrote:

I have two access databases can I import them together? If I can how do I do
that? I'm new to access and any help will be greatly appreciated. Thanks in
advance.

You can use File... Get External Data... Import to import objects such as
tables, forms, reports, etc.

If you have tables in both databases with data which needs to be merged into
one table, it might be easy - import the table and run an Append query; it
might be tricky, if you have Autonumber fields which may or may not be
duplicated between tables; it might be a nightmare, if there are duplicate and
near-duplicate and maybe-or-maybe-not duplicate records that must be resolved.
It all depends on the nature of the data and the structures of your tables.

John W. Vinson [MVP]

The second database doesn't have any data in it. It is just the program with
different forms and reports that I don't want to redo. I would like to add
them to the first database.

"John W. Vinson" wrote:

On Thu, 7 Feb 2008 12:46:01 -0800, Terry
wrote:

I have two access databases can I import them together? If I can how do I do
that? I'm new to access and any help will be greatly appreciated. Thanks in
advance.

You can use File... Get External Data... Import to import objects such as
tables, forms, reports, etc.

If you have tables in both databases with data which needs to be merged into
one table, it might be easy - import the table and run an Append query; it
might be tricky, if you have Autonumber fields which may or may not be
duplicated between tables; it might be a nightmare, if there are duplicate and
near-duplicate and maybe-or-maybe-not duplicate records that must be resolved.
It all depends on the nature of the data and the structures of your tables.

John W. Vinson [MVP]

On Thu, 7 Feb 2008 13:25:01 -0800, Terry
wrote:

The second database doesn't have any data in it. It is just the program with
different forms and reports that I don't want to redo. I would like to add
them to the first database.

Then you can open the first database and use File... Get External Data...
Import. Import the forms and reports and any Queries or Modules or Macros that
they use.

You may need to open them in design mode and change their Recordsource
properties, and/or the details of the query, if the table or fieldnames in the
two databases don't match.

John W. Vinson [MVP]

Thank you John I have another question. How do I print a certain report. I
would like to have a parameter value come up and you enter the record number
but I can't seem to get this to work. If you could help I would greatly
appreciate it. Thanks

"John W. Vinson" wrote:

On Thu, 7 Feb 2008 13:25:01 -0800, Terry
wrote:

The second database doesn't have any data in it. It is just the program with
different forms and reports that I don't want to redo. I would like to add
them to the first database.

Then you can open the first database and use File... Get External Data...
Import. Import the forms and reports and any Queries or Modules or Macros that
they use.

You may need to open them in design mode and change their Recordsource
properties, and/or the details of the query, if the table or fieldnames in the
two databases don't match.

John W. Vinson [MVP]

On Fri, 8 Feb 2008 09:03:00 -0800, Terry
wrote:

Thank you John I have another question. How do I print a certain report. I
would like to have a parameter value come up and you enter the record number
but I can't seem to get this to work. If you could help I would greatly
appreciate it. Thanks

Use a Parameter Query as the Recordsource for the report. A Report doesn't
have a paramter; the query upon which it is based does.

If you could post a bit more information about what you have tried and in
what way it "doesn't work" we might be more able to help.

John W. Vinson [MVP]

When I click print record it will print all of the records. How do I set the
parameter query up?

"John W. Vinson" wrote:

On Fri, 8 Feb 2008 09:03:00 -0800, Terry
wrote:

Thank you John I have another question. How do I print a certain report. I
would like to have a parameter value come up and you enter the record number
but I can't seem to get this to work. If you could help I would greatly
appreciate it. Thanks

Use a Parameter Query as the Recordsource for the report. A Report doesn't
have a paramter; the query upon which it is based does.

If you could post a bit more information about what you have tried and in
what way it "doesn't work" we might be more able to help.

John W. Vinson [MVP]

On Fri, 8 Feb 2008 09:49:00 -0800, Terry
wrote:

When I click print record it will print all of the records. How do I set the
parameter query up?

Terry, you're there - you can see your computer - you know the nature of your
data. I cannot and do not.

You would set up the query using an appropriate paramter on the Criteria line,
and use that query as the Recordsource for the report (rather than using the
table as the recordsource). Your "print record" button would launch the
report.

What's appropriate in your case? I don't know, given my lack of knowledge of
your application.

John W. Vinson [MVP]

on the Criteria line I have [enterrecordnumber], but it still doesn't work.
It prints all the records in form view not the record view and the parameter
doesn't come up.

"John W. Vinson" wrote:

On Fri, 8 Feb 2008 09:49:00 -0800, Terry
wrote:

When I click print record it will print all of the records. How do I set the
parameter query up?

Terry, you're there - you can see your computer - you know the nature of your
data. I cannot and do not.

You would set up the query using an appropriate paramter on the Criteria line,
and use that query as the Recordsource for the report (rather than using the
table as the recordsource). Your "print record" button would launch the
report.

What's appropriate in your case? I don't know, given my lack of knowledge of
your application.

John W. Vinson [MVP]

On Fri, 8 Feb 2008 11:06:00 -0800, Terry
wrote:

on the Criteria line I have [enterrecordnumber], but it still doesn't work.
It prints all the records in form view not the record view and the parameter
doesn't come up.

Terry... please.

Again...

I CANNOT SEE YOUR COMPUTER.

I don't know where you have the critera line - you haven't said.
I don't know what you're clicking to print - you haven't said.
I don't know even what it is you're printing - a Report (good)? the Form (bad
idea)? - you haven't said.

I would like to be able to help, but without more information I cannot.

John W. Vinson [MVP]