Y
Yodaboy
On opening a database I have created, I have an auto exec macro which runs a
report to tell me when I have expired records in my database. This then runs
another macro which if the expired records total more than 1 pings a pop up
message to tell me i have expired records. Howver if there are no expired
records the macro runs and errors with a type mismatch error. Please help the
macro code is
[Reports]![Expiring Records]![Total Expired]>0
i have tried zero's, "", Null and sums that = zero and it still doesnt work.
HELP ME OBI WINDOWS KENOBI YOU ARE MY ONLY HOPE!
Thanks
report to tell me when I have expired records in my database. This then runs
another macro which if the expired records total more than 1 pings a pop up
message to tell me i have expired records. Howver if there are no expired
records the macro runs and errors with a type mismatch error. Please help the
macro code is
[Reports]![Expiring Records]![Total Expired]>0
i have tried zero's, "", Null and sums that = zero and it still doesnt work.
HELP ME OBI WINDOWS KENOBI YOU ARE MY ONLY HOPE!
Thanks