How do I get a report to start automatically upon user opening ac.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I want to open once a week on each individual sales
persons screen when they open access.....say I have an individual sales
report that i want them to see each friday. How Do I go about doing this?
 
Tammy,

Make a macro called Autoexec; it will fire every time the database is
opened. In it, use an OpenReport action to open the report; to make the
action dependent on weekday being Friday, add a condition next to it, in
the Conditions column (View > Conditions, if the column is not visible
on the left). The condition should be:

Weekday(Date())=6

HTH,
Nikos
 
Back
Top