By "screen flash" you mean the popup print notification? That is a Windows message and preventing may not be simple.
https://stackoverflow.com/questions/...ges-or-prompts
Last edited by June7; 01-11-2024 at 02:45 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
One suggestion in the references you gave:
DoCmd.SetWarnings false
DoCmd.SetWarnings true
Application.DisplayAlerts = false
Application.DisplayAlerts = true
Won't compile, as the compiler tells me the "DisplayAlerts" imethod not found.
Yet, that's what I could find. Guess you will have to keep searching - if you really think it's worth the effort. I don't because surely users are already fully accustomed to seeing this message when printing from anywhere.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Application.DisplayAlerts = false is Excel I believe?, at least they work there.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I think for the time being I'd consider it "not worth the effort". I'll leave the thread open in case someone comes up with a solution. Moving along.................
I saw another recent thread about suppressing a Windows popup message (different one, can't remember which). Responses pointing to API code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The Access equivalent for DisplayAlerts is Echo, is it not?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
These don't work? What am I missing.
DoCmd.SetWarnings false
Docmd.OutputTo.....
DoCmd.SetWarnings true
SetWarnings has nothing to do with Windows System messages, only Access generated warnings and alerts, usually used to suppress messages associated with DoCmd.RunSQL.
This thread talks about API coding https://stackoverflow.com/questions/...od/69726#69726
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.