"Query run at login?"
If you mean you want to run a query when the application starts up, on the
menu, Tools | Startup and specify a Form with code that runs in its Open or
Load event (the Form's Visible property can be set to No if you don't want
it to be seen), or, even simpler, create a macro, name it AutoExec, and in
that macro, run your Query.
If I haven't propertly understood, perhaps you could clarify "(And Flash or
something urgent looking)". If I understand what you want to be to draw
attentionto the data returned by the Query, I'd suggest using the Query as
the RecordSource for a Form, in continuous forms view, and just opening the
Form. You can use color selection to make it just as flashy as you want.
That way, you could specify it as the Startup Form, and you wouldn't need to
"run" anything, or even do an AutoExec macro.
Larry Linson
Microsoft Access MVP
