Splash screen

[Ben]

Hi all,

I have a long running query that usually takes about 10-15 mins over the
network. I would like to provide a simple splash screen. Can you share
some thoughts on this?

Thanks,

Ben

 

[Jack Leach]

Make a form to your desired splash screen (you can hide the border/buttons
etc in the format properies), and open it before the query is run.

DoCmd.OpenForm "mysplashform"
CurrentDb.Execute "queryname"
DoCmd.Close acForm, "mysplashform"


You can also use DoCmd.RunSQL if you need the expression service (reading
access form controls for values)


hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Ben]

Cool! Thanks so much Jack.