I use the command:
"DoCmd.OutputTo acReport, docname,
acFormatSNP, "D:xx.snp", False"
to generate an output as an Snapshot-Viewer File.

I have 2 linked tables that have the same kind of data. Table 1 is the live
data and Table 2 is archived data. Both have the same field_names. I want to
build a query that selects all appropriate data from each table.
As an example, both tables contain customer_number, ...

I want to learn how to print off a list of the mail merge recipinets to save
having to keep copies of each letter on file- have tried office help and all
my colleagues no one knows in office 2003

I am using MS-Access 2002 sp-2 standard version. Now I need to create
package of my application. Do I need developer version? Can I buy only
access developer or do I have to buy office developer version?
Thanks.

while in category view I deleted a category not thinking that I had contacts
associated. there was no "are you sure prompt" which helps newbies like me.
Now I cannot recover the lost contacts. Is there a way to retrieve the info.
Info is not in deleted items.

I currently have a table containing data where the primary key indicates the
year the data was entered e.g. 04-123, this relates to a form design.
I want to start a new table with the primary key being 05-123 etc, but want
the design related to this new table to be the same as ...

I've placed a "Print Invoice" command button on the bottom of a form, but
when I select the button, ALL of the invoices are printed.  How can I just
print the current form that I'm working with?
Here's the current print procedure:

I have just put the front end of an "established" access2000 onto a new XP
PC.
The new machine is running XP Pro and Office Pro 2003.
When performing a selection, I get the prompt "run time error 429" and

Hi, beginner here.
I have a form that automatically enters the next ID number
for new entries.  The problem is, I want this ID number to
return back to 0 at the beginning of each year.  For

I have a table which includes an field that sometimes has multiple
email addresses separated by a comma.
I need to select these from the database and expected to use the comma
as a criteria. An error message has advised to include the text in

I'm a bit new to access.  I have a present database that I just maintain.  
But I would like to find out what drives in my intranet the tables are coming
from, and perhaps on what other databases is that table utilized in, if this
is possible but no big deal if it cant be done

I'm trying to open a Browse for file dialog box.  But I get errors:
1. Dim statement gives me a "Type Mismatch" error.
2. When I remove the Dim statement, the Set statement give me a "method
failure" error.

how can I set an Access database to display properly on anyones monitor using
any display settings?

I've created a database for a volunteer organization.  I'm finally about
ready to turn it over to the person who will maintain the data going forward.
Whenever I try to burn the file on a CD (using Roxio Easy CD Creator 5), it
saves the file as Read Only (which is not what I ...

Hi.  I have a form with 120 textbox controls, each of which has a label
hiding a command button which when clicked, goes through a series of
functions to get text data based on user choices, MyString.  I then wish to
return to the original form (still open) original text box, and ...