Hello
I have a Time Management database which the users keep closing without running a specific query by mistake. In an effort to work around this I added a the query to the 'On-close' event of the main form, however this cannot be used as some times they need to close the db without running this query.
I have therefore instead opted to disabling the close button. I followed this guide (support.microsoft.com/kb/300688) using a test database however when I try to run the code I am presented with the following error...
Now I'm not an expert with VBA, but I know you all are so though I'd request your assistance .
Cheers!
I have a Time Management database which the users keep closing without running a specific query by mistake. In an effort to work around this I added a the query to the 'On-close' event of the main form, however this cannot be used as some times they need to close the db without running this query.
I have therefore instead opted to disabling the close button. I followed this guide (support.microsoft.com/kb/300688) using a test database however when I try to run the code I am presented with the following error...
Compile error:
The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute.
Now I'm not an expert with VBA, but I know you all are so though I'd request your assistance .
Cheers!