H
hmvicenik
Hi
I am designing an inventory control system in Microsoft Access 2000. I
have a report that displays year end inventory totals. However my
problem is that Access does not give developers the ability to track a
"Save" action. I thought there may be a Save Event Handler for Access
Reports hidden someplace within the Report structure of the Designer
mode. I have not found anything as such. I also looked out on
Microsoft News Groups and thoroughly through Google Groups and haven't
stumbled across anything helpful.
What I would really like to do is write/save the name of the report the
user is in, to a Report Archive table (for historical tracking - aka:
tax reporting). However my problem is, Access gives users the ability
to do a "Save As" to a report in Print Preview mode via the right click
mouse menu. Essentially making it a new report. I have code in the
'On Close' event of the report to scan a query of a table to see if the
report name already exists or not. However when a user does a "Save
As" method, this bypasses my code becase I cannot trap for a "Save As"
action. So when the report's 'On Close' event occurs, my code is
triggered and the 'On Close' event knows nothing about the "Save As"
that just happened.
Now I still am testing all of my code in Design mode so I don't know if
the behavior will act differently when I compile all the reports into
one executable (I doubt it will). My actual application front end
forms are written in VB6 and just refrences the Access Database for the
tables and reports.
So I guess my question is one of two things...
1) Is there a Save_Report Sub() procedure or Save Event Handler that
can be made accessible to the user within Access. If so how is this
possible? Is this a Reference that needs to be added or something
else?
2) If there is no Save Event Handler that can be manipulated or trapped
by code, then how can I disable the "Save As" option (from the right
click mouse menu) when a user does a Preview of the report and they
right click on their mouse? Please know that I still want to be able
to allow the user to do the "Save As", I will code that functionality
in, via input box, etc. I just want to be able to control some of my
other code in the Reports 'On Close' event so that it knows when a
"Save" action occurs. Right now with the "Save As" right click menu,
my code in the 'On Close' event will never know of any "Save" action
occurring.
Any help anyone can provide is REALLY appreciated.
Thanks,
Henry
I am designing an inventory control system in Microsoft Access 2000. I
have a report that displays year end inventory totals. However my
problem is that Access does not give developers the ability to track a
"Save" action. I thought there may be a Save Event Handler for Access
Reports hidden someplace within the Report structure of the Designer
mode. I have not found anything as such. I also looked out on
Microsoft News Groups and thoroughly through Google Groups and haven't
stumbled across anything helpful.
What I would really like to do is write/save the name of the report the
user is in, to a Report Archive table (for historical tracking - aka:
tax reporting). However my problem is, Access gives users the ability
to do a "Save As" to a report in Print Preview mode via the right click
mouse menu. Essentially making it a new report. I have code in the
'On Close' event of the report to scan a query of a table to see if the
report name already exists or not. However when a user does a "Save
As" method, this bypasses my code becase I cannot trap for a "Save As"
action. So when the report's 'On Close' event occurs, my code is
triggered and the 'On Close' event knows nothing about the "Save As"
that just happened.
Now I still am testing all of my code in Design mode so I don't know if
the behavior will act differently when I compile all the reports into
one executable (I doubt it will). My actual application front end
forms are written in VB6 and just refrences the Access Database for the
tables and reports.
So I guess my question is one of two things...
1) Is there a Save_Report Sub() procedure or Save Event Handler that
can be made accessible to the user within Access. If so how is this
possible? Is this a Reference that needs to be added or something
else?
2) If there is no Save Event Handler that can be manipulated or trapped
by code, then how can I disable the "Save As" option (from the right
click mouse menu) when a user does a Preview of the report and they
right click on their mouse? Please know that I still want to be able
to allow the user to do the "Save As", I will code that functionality
in, via input box, etc. I just want to be able to control some of my
other code in the Reports 'On Close' event so that it knows when a
"Save" action occurs. Right now with the "Save As" right click menu,
my code in the 'On Close' event will never know of any "Save" action
occurring.
Any help anyone can provide is REALLY appreciated.
Thanks,
Henry