Hello all,
One of the databases that I support, caused quite a stir yesterday. there is a report that is sent out from Access that shows the budgets for departments. This report is sent to the department heads. Apparently the user did not validate the data before emailing to the executive director. The budget numbers balance differences were way off. Of course it was the database's fault and ultimately my fault. Most were understanding, but there were some that were very unhappy and I was called into my boss' office.
There is a macro that must be run before the reports are sent out. The user says that she clicked the button to run the macro. But as I went through the macro and found the query that updates the balance difference, I ran the macro on its own and the report was fine. So she either did not run the macro or the query in the macro did not run.
Which leads me to two scenarios.
- she did not run the macro
- the macro ran but the query was skipped.
if she did not run the macro ---- end of issue
if she did run the macro and the query was skipped. Does that happen?
we have network issues here. it is intermittent in my opinion. could the intermittent network cause the query to skip in a macro?
What should I do?
Thank you
Jim Wagner
Posted by: luvmymelody@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar