Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can macro perform if-else logic

Status
Not open for further replies.
dkape

dkape

MIS
Mar 22, 2001
17
0
0
US
I currently have an access db in which the autoexec macro runs an exception report and then e-mails the report to two users. I have this db run automatically each night, so each morning the report is in the user e-mail inbox. Sometimes the query that the report is based on returns no data, which is fine, the report just has no data.

What I would like to do is have the macro evaluate the results of the report/query and if no data is found, not e-mail the report. That way the report would only be sent if there is data in the report.

I would be open to any other thoughts on how this might be done as well.

Thanks, Doug
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
164
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
150
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
182
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
53
Andrzejek
Andrzejek
meagain
  • Locked
  • Question
If Conditional Expression based on day of week
Replies
2
Views
68
meagain
meagain

Part and Inventory Search

Sponsor

Back
Top