[AccessD] Detecting when an Access Report has been closed!

Charlotte Foust cfoust at infostatsystems.com
Mon Mar 15 12:48:37 CST 2004


You can sink the Close event of the report on your form using the
WithEvents keyword.  Check out WithEvents in on-line help (and in the
archives for extensive discussion).  If you need additional help, post
back.

Charlotte Foust

-----Original Message-----
From: Dick Abo [mailto:orthorabod at yahoo.com] 
Sent: Monday, March 15, 2004 10:39 AM
To: accessd at databaseadvisors.com
Cc: orthorabod at yahoo.com
Subject: [AccessD] Detecting when an Access Report has been closed!


 
I have a form from which the user views a report in Print Preview mode
by clicking the 'View Report' button.  I would like user to respond to
the question to 'Publish', or 'Not Publish' the report after the report
is viewed.  If the user decides to Publish the report, I export the
report to Word and then save it in Ascii format (MS-DOS text w/layout).


I could incorporate a separate button on the form that just generates
the Access 2000 report in acPreview mode.  I would prefer to detect when
the report has been closed by the user so that I can then ask the
question, "Publish or Not Publish" the report and to execute the
remaining code that is behind the existing 'View Report' button?  

Can you kindly give me some advice on how to do this! 

TIA,

Rick


Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list