Please Help - Having problems with an MS Access Macro deleting steps/tables
Posted on 2013-01-10
So here's the story. Where I work we have crop information for planting & planning of the coming years that is entered into different Excel files.
Once the data is entered, then I am told to run an Access macro that then updates our database to reflect the changes made. After this has been completed, a Crystal report runs that shows those changes, and what our forecast is projected to be.
Now the problem: When I went to update the macro to add in the "DeleteObject" - 2015 table data, then added the "OpenQuery" - new 2015 query input, everything seems okay. But when I run the macro it gives me an error that, (the existing table "***2014" will be deleted. do you wish to continue?) . Now all I did was do a 'copy/paste' with the 2014 'deleteObject' and copy/paste of the 2014 'openQuery'. I did create an initial 2015 table, and modify the 2015 query to reflect the year change.
What am I doing wrong? Let me know if you need screen shots of anything. I'll see what I can do to help explain any other issues.
Note: I did not build this initially. I inherited this, and the previous guy took a couple of years to put this all together. I'm impressed with what he did.