How to hide status screen during export.

[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,

 

[TC]

This search:
http://groups.google.com/groups/sea...s+message+OR+warning+OR+status+group:*access*

shows a number of knowledgeable folks, saying that it can't be done. So
you may have to put up with it.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[john.muscat]

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.

 

[TC]

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

 

[Stephen Lebans]

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.

 

[TC]

Yes, good point.

I'm also wondering whether hooks, addressof etc. will work in the next
version, I had not thought to check that yet.

Cheers,
TC (MVP Access)
http://tc2.atspace.com