or Connect
TheSandTrap.com › Golf Forum › The 19th Hole › The Grill Room › Mistakes that make you do your work over again!
New Posts  All Forums:Forum Nav:

Mistakes that make you do your work over again!

post #1 of 12
Thread Starter 

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?  

post #2 of 12

Measure twice, cut once.....

 

But yeah, it happens.  More so when I was young and stupid.  Now that I'm older and just as stupid, but a bit more experienced, not quite so much.

post #3 of 12

I'm guessing you couldn't just "undo" the results?

post #4 of 12
Quote:
Originally Posted by iacas View Post
 

I'm guessing you couldn't just "undo" the results?

 

I know you were asking the OP, but I had a buddy who, like me, does a little woodworking on the side.  He used to moan, "I cut the board 3 times now, and it's still too short!"

 

Sadly, there were a lot of people who didn't get it.....

post #5 of 12
Quote:
Originally Posted by David in FL View Post
 

 

I know you were asking the OP, but I had a buddy who, like me, does a little woodworking on the side.  He used to moan, "I cut the board 3 times now, and it's still too short!"

 

Sadly, there were a lot of people who didn't get it.....

Need to get yerself one of them board stretchers. :-P 

post #6 of 12
Sometimes I'll write something out only to re-read it at the end and realize I can't even read my own handwriting.
post #7 of 12
Thread Starter 
Quote:
Originally Posted by iacas View Post
 

I'm guessing you couldn't just "undo" the results?

 

Ya.. no such thing as "undo" in MS Access (especially when running codes like "DELETE * FROM") LOL

 

MS Access is much better than Excel in my opinion.. But a lot less forgiving!

post #8 of 12
Quote:
Originally Posted by Abu3baid View Post

 

Ya.. no such thing as "undo" in MS Access (especially when running codes like "DELETE * FROM") LOL

 

MS Access is much better than Excel in my opinion.. But a lot less forgiving!

 

Well, I guess that's what you get for using Access. Most good databases let you roll back transactions. :D

post #9 of 12
Quote:
Originally Posted by Abu3baid View Post
 

 

Ya.. no such thing as "undo" in MS Access (especially when running codes like "DELETE * FROM") LOL

 

MS Access is much better than Excel in my opinion.. But a lot less forgiving!

So, kind like the Titleist MB of spread sheets? Sounds like you hit one off the toe and REALLY could have used a little perimeter weighting. ;-)

post #10 of 12
Thread Starter 
Quote:
Originally Posted by Ernest Jones View Post
 

So, kind like the Titleist MB of spread sheets? Sounds like you hit one off the toe and REALLY could have used a little perimeter weighting. ;-)

 

:)  yes!

 

Quote:
Originally Posted by iacas View Post
 

 

Well, I guess that's what you get for using Access. Most good databases let you roll back transactions. :D

All I can say is that Access did exactly what it was supposed to.. it usually does..

 

Almost like when you click on the Discard Draft below and then you click confirm.. no turning back!

post #11 of 12
Quote:
Originally Posted by Abu3baid View Post
 

 

 

Almost like when you click on the Discard Draft below and then you click confirm.. no turning back!

Actually my drafts seem to live forever on my iPhone...very hard to kill zombie drafts.

post #12 of 12
Thread Starter 
Quote:
Originally Posted by Ernest Jones View Post
 

Actually my drafts seem to live forever on my iPhone...very hard to kill zombie drafts.

 

haha!! I suggest you reset your i-phone back to factory settings :w00t: 

New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: The Grill Room
TheSandTrap.com › Golf Forum › The 19th Hole › The Grill Room › Mistakes that make you do your work over again!