Ya.. I was importing data from multiple excel files and multiple tabs within them using an access application that I designed.. I have a button designed to delete specific data if I find any mistakes (so that I don't have to worry about if I deleted it or not.. you know, set it and forget it kind of thing).. The problem is that I designed the application last year and I am using it this year.. So, I had finished most of the data set up that I needed, but I had an updated sheet so I needed to delete some information.
I type in the key field in which to delete all the data from all the different tables in which it was entered, and I get an error (must of been the control I set up a while back).. I go into the code and quickly fix the dash or something that I had, and instead of looking at the actual code I will be executing I just save and go into my main form.
I click "DELETE" and I go into my summary table to make sure that everything is looking good.... ya... no data shows up.. I go into 3 or 4 tables and they are all blank.. I go into the code that I executed and it has this code DOCMD.RUNSQL ("DELETE * FROM [TABLE NAME]") for each of my tables.. so, instead of the code running the delete queries I have, I just screwed my self..
I deleted all data entered over the past 3 days into those tables...
I will have to go back and work double time and upload the data again into my tables... Less time to work on my posture!!
ok.. good I got that off my chest..
take away from all of this: Don't run "DELETE" button before double checking the code it will be running :)
Any of you ever do something that has made you start your work from scratch again?