Is it possible to Delete a Report using code?

  • Thread starter missinglinq via AccessMonster.com
  • Start date
M

missinglinq via AccessMonster.com

Am developing a module to allow end users, thru the Report Wizard, to
generate custom reports (I know, I know! But they insist!) and I want to
offer them the option of deleting the report after printing.

Thanks
 
K

Klatuu

I would not give them that much access to my application. I would create an
mdb that allows them read access to only the tables needed for the report.
Then let them use that for creating their reports.
 
F

fredg

Am developing a module to allow end users, thru the Report Wizard, to
generate custom reports (I know, I know! But they insist!) and I want to
offer them the option of deleting the report after printing.

Thanks
Click to expand...

DoCmd.DeleteObject acReport, "Report Name"
 
M

missinglinq via AccessMonster.com

Thanks Ken and Fred!

Not giving them access to *your* application, Klatuu, nor even *mine*, but
rather to *their* application, as per their request! Exactly what havoc can
they wreak by having access to the Report Wizard when it's invoked thru VBA
code?
 
D

Douglas J. Steele

missinglinq via AccessMonster.com said:
Thanks Ken and Fred!

Not giving them access to *your* application, Klatuu, nor even *mine*, but
rather to *their* application, as per their request! Exactly what havoc
can
they wreak by having access to the Report Wizard when it's invoked thru
VBA
code?
Click to expand...

They have the ability to change what you gave them, not just add new
reports.
 
M

missinglinq via AccessMonster.com

And what did I give them? From the Report Wizard, what can they change? They
can't change tables, queries or forms. The only thing they can really do is
overwrite an existing report if they give the same name to a new report, and
they get a warning before this occurs.
Thanks Ken and Fred!
Click to expand...
[quoted text clipped - 4 lines]
VBA
code?
Click to expand...

They have the ability to change what you gave them, not just add new
reports.
Click to expand...
 
M

missinglinq via AccessMonster.com

Sorry, being doing this for so long that I forget to add that my end users
*never* have access to any of the native Access menu bars.
And what did I give them? From the Report Wizard, what can they change? They
can't change tables, queries or forms. The only thing they can really do is
overwrite an existing report if they give the same name to a new report, and
they get a warning before this occurs.
[quoted text clipped - 4 lines]
They have the ability to change what you gave them, not just add new
reports.
Click to expand...
Click to expand...
 
Top