SendObject, Snapshot in Access 2002 and 2003


G

Guest

I created a DB in Access 2002 that had VBA Private Sub that ran from a Form
Button. This button would open a report based on the Form and use the
SendObject command to also e-mail it to a recipient. The Sub is below.

Private Sub ReprintEmail_Click()
On Error GoTo Err_ReprintEmail_Click

Dim stDocName As String

stDocName = "InvoiceOrderNum"
DoCmd.OpenReport stDocName, acNormal
DoCmd.SendObject acReport, "InvoiceOrderNum",
"SnapshotFormat(*.snp)", "(e-mail address removed)", "", "", "Appliance
Sales Order ID " & Forms!ReviewOrders5![OrderID], "", False, ""


Exit_ReprintEmail_Click:
Exit Sub

Err_ReprintEmail_Click:
MsgBox Err.Description
Resume Exit_ReprintEmail_Click

End Sub

I never had any problems and the code worked great until I recently got a
new PC with Office 2003. I did some modifications on the DB for something
else that did not pertain to this code at all. My co-workers are still using
Access 2002 but I am using Access 2003. When this button is clicked in 2002
it immediately comes up with a parameter box asking for a format which has
not been an issue until I got the new Office 2003. I have changed the
'Format' to all of the following with no luck: "Snapshotformat (*.snp)" ,
"Snapshot Format", "(*.snp)", acformatsnp, and "Snapshot Format (*.snp)". My
co-worker and I think it has something to do with the Object Library
reference. Please help. Thanks, JBB
 
Ad

Advertisements

D

david epsom dot com dot au

Do you have the snapshot viewer installed?

What exactly does the message say?

(david)
 
G

Guest

We do have the viewer installed. As I said in the original post, it worked
until I upgraded my PC with Office 2003 and my co-workers are still on Access
2002. This is a database that several different people use. The message
looks just like a parameter box as if you set one up for a query. It just
says "Format". We know that it is an issue with the References Object
Library now. We put the Microsoft Access Object Library 10.0 from 2002 in
with the MS Access object Library 11.0 from 2003 and it allowed both versions
of Access to create the Snapshot file. The problem now is that the Object
Library 10.0 will not stay tagged to the database once added and then opened
with Access 2003. We need a way of attaching the older object library and
keeping it there so it is not an issue. Thanks, JBB

david epsom dot com dot au said:
Do you have the snapshot viewer installed?

What exactly does the message say?

(david)

jaminblair said:
I created a DB in Access 2002 that had VBA Private Sub that ran from a Form
Button. This button would open a report based on the Form and use the
SendObject command to also e-mail it to a recipient. The Sub is below.

Private Sub ReprintEmail_Click()
On Error GoTo Err_ReprintEmail_Click

Dim stDocName As String

stDocName = "InvoiceOrderNum"
DoCmd.OpenReport stDocName, acNormal
DoCmd.SendObject acReport, "InvoiceOrderNum",
"SnapshotFormat(*.snp)", "(e-mail address removed)", "", "",
"Appliance
Sales Order ID " & Forms!ReviewOrders5![OrderID], "", False, ""


Exit_ReprintEmail_Click:
Exit Sub

Err_ReprintEmail_Click:
MsgBox Err.Description
Resume Exit_ReprintEmail_Click

End Sub

I never had any problems and the code worked great until I recently got a
new PC with Office 2003. I did some modifications on the DB for something
else that did not pertain to this code at all. My co-workers are still
using
Access 2002 but I am using Access 2003. When this button is clicked in
2002
it immediately comes up with a parameter box asking for a format which has
not been an issue until I got the new Office 2003. I have changed the
'Format' to all of the following with no luck: "Snapshotformat (*.snp)" ,
"Snapshot Format", "(*.snp)", acformatsnp, and "Snapshot Format (*.snp)".
My
co-worker and I think it has something to do with the Object Library
reference. Please help. Thanks, JBB
 
Ad

Advertisements

D

david epsom dot com dot au

The message "Format" has nothing to do with the snapshot. It
is a message from your query or report, one of which uses the
"Format" function.

Any reference problem could cause any number of different
errors like this, so you need to check ALL of your references,
not just the Access Object Library.

Resetting any library causes all of the libraries to reset,
so you need to check ALL of your references, not just the
Access Object Library.

It is extremely rare for the Access Object Library to be
the cause of problems like this, so you need to check your
other references as well.

(david)

jaminblair said:
We do have the viewer installed. As I said in the original post, it
worked
until I upgraded my PC with Office 2003 and my co-workers are still on
Access
2002. This is a database that several different people use. The message
looks just like a parameter box as if you set one up for a query. It just
says "Format". We know that it is an issue with the References Object
Library now. We put the Microsoft Access Object Library 10.0 from 2002 in
with the MS Access object Library 11.0 from 2003 and it allowed both
versions
of Access to create the Snapshot file. The problem now is that the Object
Library 10.0 will not stay tagged to the database once added and then
opened
with Access 2003. We need a way of attaching the older object library and
keeping it there so it is not an issue. Thanks, JBB

david epsom dot com dot au said:
Do you have the snapshot viewer installed?

What exactly does the message say?

(david)

jaminblair said:
I created a DB in Access 2002 that had VBA Private Sub that ran from a
Form
Button. This button would open a report based on the Form and use the
SendObject command to also e-mail it to a recipient. The Sub is below.

Private Sub ReprintEmail_Click()
On Error GoTo Err_ReprintEmail_Click

Dim stDocName As String

stDocName = "InvoiceOrderNum"
DoCmd.OpenReport stDocName, acNormal
DoCmd.SendObject acReport, "InvoiceOrderNum",
"SnapshotFormat(*.snp)", "(e-mail address removed)", "", "",
"Appliance
Sales Order ID " & Forms!ReviewOrders5![OrderID], "", False, ""


Exit_ReprintEmail_Click:
Exit Sub

Err_ReprintEmail_Click:
MsgBox Err.Description
Resume Exit_ReprintEmail_Click

End Sub

I never had any problems and the code worked great until I recently got
a
new PC with Office 2003. I did some modifications on the DB for
something
else that did not pertain to this code at all. My co-workers are still
using
Access 2002 but I am using Access 2003. When this button is clicked in
2002
it immediately comes up with a parameter box asking for a format which
has
not been an issue until I got the new Office 2003. I have changed the
'Format' to all of the following with no luck: "Snapshotformat (*.snp)"
,
"Snapshot Format", "(*.snp)", acformatsnp, and "Snapshot Format
(*.snp)".
My
co-worker and I think it has something to do with the Object Library
reference. Please help. Thanks, JBB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top