var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sendobject Question
I e-mail a weekly error report from Access to my colleagues at work. The report comes from a query in a Macro using the sendobject command, and is e-mailed in Excel format.
My question is: Is there anyway to prevent the file being sent when the query is blank? I have attached a screenshot from the macro.
This would be simple in a module. Just a quick dcount and an if statement or a recordset.movelast and an if statement. I saw a message on this board this afternoon about this...