Is it possible to Delete a Report using code?

  • Thread starter Thread starter missinglinq via AccessMonster.com
  • Start date 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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
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.
 
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"
 
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?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
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.
 
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...
 
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...
 
Back
Top