Jump to content
IGNORED

Mistakes that make you do your work over again!

Abu3baid

By Abu3baid,
in The Grill Room

 Share
Note: This thread is 3944 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Recommended Posts

Abu3baid Great Member

Abu3baid

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?

:adams: / :tmade: / :edel: / :aimpoint: / :ecco: / :bushnell: / :gamegolf: / 

Eyad

Awards, Achievements, and Accolades
1
1
1

David in FL Incredible Member

David in FL

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.

In David's bag....

Driver: Titleist 910 D-3;  9.5* Diamana Kai'li
3-Wood: Titleist 910F;  15* Diamana Kai'li
Hybrids: Titleist 910H 19* and 21* Diamana Kai'li
Irons: Titleist 695cb 5-Pw
Wedges: Scratch 51-11 TNC grind, Vokey SM-5's;  56-14 F grind and 60-11 K grind
Putter: Scotty Cameron Kombi S
Ball: ProV1

Awards, Achievements, and Accolades
1
1
1
1
1

  • Administrator
iacas Hall of Fame Member

iacas

  • Administrator

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

Erik J. Barzeski — ⛳ I knock a ball. It goes in a gopher hole. 🏌🏼‍♂️
Director of Instruction Golf Evolution • Owner, The Sand Trap .com • Author, Lowest Score Wins
Golf Digest "Best Young Teachers in America" 2016-17 & "Best in State" 2017-20 • WNY Section PGA Teacher of the Year 2019 :edel: :true_linkswear:

Check Out: New Topics | TST Blog | Golf Terms | Instructional Content | Analyzr | LSW | Instructional Droplets

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

David in FL Incredible Member

David in FL

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.....

  • Upvote 1

In David's bag....

Driver: Titleist 910 D-3;  9.5* Diamana Kai'li
3-Wood: Titleist 910F;  15* Diamana Kai'li
Hybrids: Titleist 910H 19* and 21* Diamana Kai'li
Irons: Titleist 695cb 5-Pw
Wedges: Scratch 51-11 TNC grind, Vokey SM-5's;  56-14 F grind and 60-11 K grind
Putter: Scotty Cameron Kombi S
Ball: ProV1

Awards, Achievements, and Accolades
1
1
1
1
1

Ernest Jones Incredible Member

Ernest Jones

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

Yours in earnest, Jason.
Call me Ernest, or EJ or Ernie.

PSA - "If you find yourself in a hole, STOP DIGGING!"

My Whackin' Sticks: :cleveland: 330cc 2003 Launcher 10.5*  :tmade: RBZ HL 3w  :nickent: 3DX DC 3H, 3DX RC 4H  :callaway: X-22 5-AW  :nike:SV tour 56* SW :mizuno: MP-T11 60* LW :bridgestone: customized TD-03 putter :tmade:Penta TP3   :aimpoint:

Awards, Achievements, and Accolades
1
1

jamo Incredible Member

jamo

Sometimes I'll write something out only to re-read it at the end and realize I can't even read my own handwriting.

In my bag:

Driver: Titleist TSi3 | 15º 3-Wood: Ping G410 | 17º 2-Hybrid: Ping G410 | 19º 3-Iron: TaylorMade GAPR Lo |4-PW Irons: Nike VR Pro Combo | 54º SW, 60º LW: Titleist Vokey SM8 | Putter: Odyssey Toulon Las Vegas H7

Awards, Achievements, and Accolades
1
1
1

Abu3baid Great Member

Abu3baid

  • Author

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!

:adams: / :tmade: / :edel: / :aimpoint: / :ecco: / :bushnell: / :gamegolf: / 

Eyad

Awards, Achievements, and Accolades
1
1
1

  • Administrator
iacas Hall of Fame Member

iacas

  • Administrator

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

Erik J. Barzeski — ⛳ I knock a ball. It goes in a gopher hole. 🏌🏼‍♂️
Director of Instruction Golf Evolution • Owner, The Sand Trap .com • Author, Lowest Score Wins
Golf Digest "Best Young Teachers in America" 2016-17 & "Best in State" 2017-20 • WNY Section PGA Teacher of the Year 2019 :edel: :true_linkswear:

Check Out: New Topics | TST Blog | Golf Terms | Instructional Content | Analyzr | LSW | Instructional Droplets

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

Ernest Jones Incredible Member

Ernest Jones

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. ;-)

Yours in earnest, Jason.
Call me Ernest, or EJ or Ernie.

PSA - "If you find yourself in a hole, STOP DIGGING!"

My Whackin' Sticks: :cleveland: 330cc 2003 Launcher 10.5*  :tmade: RBZ HL 3w  :nickent: 3DX DC 3H, 3DX RC 4H  :callaway: X-22 5-AW  :nike:SV tour 56* SW :mizuno: MP-T11 60* LW :bridgestone: customized TD-03 putter :tmade:Penta TP3   :aimpoint:

Awards, Achievements, and Accolades
1
1

Abu3baid Great Member

Abu3baid

  • Author
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!

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!

:adams: / :tmade: / :edel: / :aimpoint: / :ecco: / :bushnell: / :gamegolf: / 

Eyad

Awards, Achievements, and Accolades
1
1
1

Ernest Jones Incredible Member

Ernest Jones

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.

Yours in earnest, Jason.
Call me Ernest, or EJ or Ernie.

PSA - "If you find yourself in a hole, STOP DIGGING!"

My Whackin' Sticks: :cleveland: 330cc 2003 Launcher 10.5*  :tmade: RBZ HL 3w  :nickent: 3DX DC 3H, 3DX RC 4H  :callaway: X-22 5-AW  :nike:SV tour 56* SW :mizuno: MP-T11 60* LW :bridgestone: customized TD-03 putter :tmade:Penta TP3   :aimpoint:

Awards, Achievements, and Accolades
1
1

Abu3baid Great Member

Abu3baid

  • Author
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:

:adams: / :tmade: / :edel: / :aimpoint: / :ecco: / :bushnell: / :gamegolf: / 

Eyad

Awards, Achievements, and Accolades
1
1
1

Note: This thread is 3944 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

  I accept
The popup will be closed in 10 seconds...