Splash screen

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
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)
 
Back
Top