473,379 Members | 1,245 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

snapshot from access97 ?

Hi all,

Is there something wrong with my access97 SR-2 installation ?
1) Under MACRO, when I choose action SendObject, I could select
Snapshot Format for "Output Format". (BTW Is there a way to insert
email address into the "To" in the action arg, during run-time ?)

2) But under the Command_Click event, docmd.OutputTo or
docmd.SendObject does not seems to accept acFormatSNP ?

Thanks for any help.
Nov 13 '05 #1
4 2514
"sean" <se****@pc.jaring.my> wrote in message
news:11**************************@posting.google.c om...
Hi all,

Is there something wrong with my access97 SR-2 installation ?
1) Under MACRO, when I choose action SendObject, I could select
Snapshot Format for "Output Format". (BTW Is there a way to insert
email address into the "To" in the action arg, during run-time ?)

2) But under the Command_Click event, docmd.OutputTo or
docmd.SendObject does not seems to accept acFormatSNP ?


The named constant acFormatSNP didn't come along until later versions of Access.
Use "Snapshot Format" (including the quotes).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
"Rick Brandt" <ri*********@hotmail.com> wrote in message
The named constant acFormatSNP didn't come along until later versions of Access.
Use "Snapshot Format" (including the quotes).


Thank you so much. But from the access help, i could not find such info.
sean.
Nov 13 '05 #3
"sean" <se****@pc.jaring.my> wrote in message
news:11**************************@posting.google.c om...
"Rick Brandt" <ri*********@hotmail.com> wrote in message
The named constant acFormatSNP didn't come along until later versions of
Access.
Use "Snapshot Format" (including the quotes).


Thank you so much. But from the access help, i could not find such info.
sean.


Access 97 Help was likely written before Snapshot format existed. It wasn't
added until Service Release 1 of Office 97.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #4
I am also having trouble with Snapshot and SendObject, I have
discovered that if I run Access 2003 it works, then when I return to
Access97 it then works it seems that SP2 is changing a file somewhere
Patrick

On 23 Nov 2004 01:03:11 -0800, se****@pc.jaring.my (sean) wrote:
Hi all,

Is there something wrong with my access97 SR-2 installation ?
1) Under MACRO, when I choose action SendObject, I could select
Snapshot Format for "Output Format". (BTW Is there a way to insert
email address into the "To" in the action arg, during run-time ?)

2) But under the Command_Click event, docmd.OutputTo or
docmd.SendObject does not seems to accept acFormatSNP ?

Thanks for any help.


Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Jean-Marc Blaise | last post by:
Dear all, It seems there is a problem with some snapshot table functions, if you try to divide by some element that is unset or equal to 0. This generates a trap file with the db2fmp.exe...
4
by: Civilian_Target | last post by:
Is there any way in DB2 to automate the taking of a snapshot, for example, a function that will cause a db2 snapshot to be taken every 5 minutes and written to a uniquely named file? Am I better...
1
by: Rick Brown | last post by:
I'm trying to find a way to output a Access97 report to a file without losing any of the formatting. The Microsoft Snapshot Viewer does this perfectly but the person opening the file needs the...
5
by: tom | last post by:
Hey All- I've exported a report to Access's "snapshot" format and want to put it on a website for users to view. However, when I click on the link to the snapshot file, I notice that my browser...
1
by: Mario Crevits | last post by:
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with Access97 for several years now. We are in an Access97-2000 migration project. I'm writing a wizard for the end-users to...
6
by: Roger | last post by:
I have a report with a image displaying our company logo if I create an snapshot of this report, it appears to create an 'snp' file, but nothing is stored in the folder I tried both linked and...
5
by: Steven Taylor | last post by:
Hope someone can help. I have an application whereby in order to create one document type I effectively print out 3 or 4 access reports in correct order. So the user goes to the printer,...
8
by: grant | last post by:
Hi I've copied Stephens code into my db, and can get it to work, but only on "plain Jane" reports with no images. Most of my reports has an unbound image obluect in them that I set to an...
3
by: Ramchandar | last post by:
Hi, I am creating reports using VBA code. I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.