Good Morning, i was wondering if someone could help me with an issue i am having with Access.
Currently i have a system which is a Access which is running two macros. the first one creates a new record in two different tables. The second exports a query, then opens a word mail merge document and loops through the records and prints each to PDF. Then it loops through the records in the query export and generates new emails and attached the PDF to them.
The problem is that the first macro runs perfectly and everything works. The second macro runs fine until it finishes, when it gets to "end sub" Access appears to crash and when you try to click anyway the access screen then goes white. To me looks like access is waiting for you to click a message box but i cannot see anything.
I have tried stepping through the macro and everything seems to be working it steps through everything and completes fine but access just seesm to not be working.
Does anyone have any ideas of what i can do to find out what is happening with access?
Thank you
Currently i have a system which is a Access which is running two macros. the first one creates a new record in two different tables. The second exports a query, then opens a word mail merge document and loops through the records and prints each to PDF. Then it loops through the records in the query export and generates new emails and attached the PDF to them.
The problem is that the first macro runs perfectly and everything works. The second macro runs fine until it finishes, when it gets to "end sub" Access appears to crash and when you try to click anyway the access screen then goes white. To me looks like access is waiting for you to click a message box but i cannot see anything.
I have tried stepping through the macro and everything seems to be working it steps through everything and completes fine but access just seesm to not be working.
Does anyone have any ideas of what i can do to find out what is happening with access?
Thank you