How to hide status screen during export.

  • Thread starter Thread starter john.muscat
  • Start date Start date
J

john.muscat

Hi all,

This has been asked before(ages ago) and not really answered. I have
searched everywhere for an answer without any luck.

When I use the following command I briefly get a printing status window
appearing, How to I stop this from happening?

DoCmd.OutputTo acReport, ReportName, "SnapshotFormat(*.snp)",
"c:\aaaa.snp", False

One previous suggestion was to use do a "Docmd.SetWarning False" but
this does not stop it from appearing.

If I can't get this stop this from coming up can I redirect its output
to somewhere else? (just thinking out aloud).

Thanks in advance,
 
Thanks TC.

Looks like I shall give snapshot's a miss, A pity as it was a good
solution for me.

Back to the drawing board.
 
Gosh, it would be sad to throw out the whole idea, based only on that
:-(

When I suggested that it couldn't be done, I was really saying, there
does not seem to be any easy/standard way to do it. But if you
absolutely had to, you could probably do it by establishing a "CBT
Hook", looking for the creation of that particular window, then
changing the "window style" to make that window invisible. For this,
you'd need to have a good understanding of CBT Hooks, and how to use
the win32 API from VBA.

Perhaps start here:
http://groups.google.com/groups/search?q="CBT+hook"++"declare+function"

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Hey TC,
it would be a bit more complex as the Dialog is probably reused for various
Access prompts. You'd have to check and sure you were hiding/closing the
correct one.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top