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

Link to comment
Share on other sites
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

Link to comment
Share on other sites
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

Link to comment
Share on other sites
Awards, Achievements, and Accolades
1
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

Link to comment
Share on other sites
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:

Link to comment
Share on other sites
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

Link to comment
Share on other sites
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

Link to comment
Share on other sites
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

Link to comment
Share on other sites
Awards, Achievements, and Accolades
1
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:

Link to comment
Share on other sites
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

Link to comment
Share on other sites
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:

Link to comment
Share on other sites
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

Link to comment
Share on other sites
Awards, Achievements, and Accolades
1
1
1

Note: This thread is 3728 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


  • Want to join this community?

    We'd love to have you!

    Sign Up

  • TST Partners

    TourStriker PlaneMate
    Golfer's Journal
    ShotScope
    The Stack System
    FlightScope Mevo
    Direct: Mevo, Mevo+, and Pro Package.

    Coupon Codes (save 10-15%): "IACAS" for Mevo/Stack, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope.

  • Posts

    • pganapathy
      A Novice Journey to Building a Bag. (Help Appreciated)

      By pganapathy ·

      A couple of things.  Some of the clubs in your bag should be dropped immediately.  A 2-iron for example with what obviously seems to be a lower swing speed or possibly not great swing yet is a definite no-no.  To be hitting that 120-140 yards, which I assume includes run, is a sign that you are not getting the ball airborne at the correct angle to maximise distance.  The reason your 3 and 5 hybrid are going the same distance is that your launch angle is better with the 5.  Loft is your friend. Ideally I would suggest going to a golf or sporting store where you can hit golf balls on a simulator without being disturbed to understand your club carry distances and hopefully swing speed.  With that information we can definitely guide you better.
    • pganapathy
      Is This Club Blatantly Sandbagging?

      By pganapathy ·

      Let us be clear, unless you have proof of cheating, you just sound like a case of sour grapes.  In our club we have a guy who won club titles for many years.  Yes, he was a low single digit handicapper, but there have been quite a few others who played at his level.  Yet his mental strength and experience helped him win in many years when he shouldn't have.  Did he sandbag.  DEFINITELY NOT.  Did he just minimize his mistakes and pull out shots as and when needed.  Definitely.
    • DaHolla
      "5 Minutes Daily" Practice Challenge

      By DaHolla ·

      Day 111 - Worked on my grip and higher hands in the backswing. Full swings with the PRGR. 
    • retoid
      A Novice Journey to Building a Bag. (Help Appreciated)

      By retoid ·

      First off please forgive me if this is not a proper post or not in the proper location, still learning the ropes around here. Second, it's important that I mention I am very new to the game with only about 10 rounds of golf under my belt, most being 9 holes. Only this year have I started playing 18. That being said, I am hooked, love the game and am very eager to learn and improve. To give you an idea of my skill, the last 2 18 rounds I played were 110 and 105. Not great at all, however I am slowly improving as I learn. Had been having bad slicing issues with the driver and hybrids but after playing some more and hitting the range, I've been able to improve on that quite a bit and have been hitting more straight on average. Irons have always come easier to me as far as hitting straight for some reason. Wedges have needed a lot of improvement, but I practice chipping about 20-30 mins about 3-5 times a week and that's helped a lot. Today I went to the range and started to note down some distance data, mind you I am averaging the distances based off my best guess compared to the distance markers on the range. I do not currently own a range finder or tracker. From reading some similar posts I do understand that filling gaps is ideal, but I am having a some issues figuring out those gaps and understanding which clubs to keep and remove as some gaps are minimal between clubs. Below is an image of the chart I put together showing the clubs and average distances I've been hitting and power applied. For some reason I am hitting my hybrids around the same distances and I am not sure why. Wondering if one of them should be removed. I didn't notice a huge loft difference either. The irons I have are hand me downs from my grandfather and after playing with them a bit, I feel like they're just not giving me what could potentially be there. The feel is a bit hard/harsh and underwhelming if that makes sense and I can't seem to get decent distances from them. Wondering if I should be looking to invest in some more updated irons and if those should be muscle backs or cavity backs? My knowledge here is minimal. I have never played with modern fairway woods, only the classic clubs that are actually wood and much smaller than modern clubs. I recently removed the 4 and 5 woods from my bag as I was never using them and I don't hit them very well or very far. Wondering if I should look into some more modern fairway wood options? I appreciate any feedback or advice anyone is willing to give, please forgive my lack of knowledge. I am eager to learn! Thank you.  
    • snapfade
      Is This Club Blatantly Sandbagging?

      By snapfade ·

      I would think that 3 in a row with the same players might get some behind the scenes examination from the SCGA if they were suspect.  Are there any clubs questioning the results?
×
×
  • 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...