Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 675
  • Last Modified:

disable "save file" prompt in macro

Hi,  I want my macro to automatically dispaly the data from a report on my monitor.  the only problem is that i get prompted to save the file to my documents and overdide the preexisting file (please see screenshot for example).   please advise how I disable this prompt.  I do not know VBA.
thank you very much
screenshot.bmp
purchasing-automated-Reports.mdb
0
Osvel_SQL
Asked:
Osvel_SQL
  • 2
1 Solution
 
Chris BottomleyCommented:
Hello Osvel_SQL,

Try bracketing the save with:
application.DoCmd.SetWarnings(false)
'Save
application.DoCmd.SetWarnings(true)

Regards,

chris_bottomley
0
 
Osvel_SQLAuthor Commented:
thank you for your reply.  Would u bebable to sen dme a send me a screen shot  or a link of how to do it?
0
 
Chris BottomleyCommented:
I had been thinking in terms of a classical macro rather than an access one so I apologise for my input ... I would have expected that the setwarnings option has that effect but since you show it selected I am obviouslty lacking in necessary skills so can't help further.

Chris
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now