Jump to content
Check out the Spin Axis Podcast! ×
Check out the Spin Axis Podcast!
IGNORED

Mistakes that make you do your work over again!

Abu3baid

By Abu3baid
in The Grill Room

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

Posted
Posted

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

Posted
Posted

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

Posted
  • Administrator
Posted

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

Posted
Posted

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

Posted
Posted

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

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

Posted
  • Author
Posted

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

Posted
  • Administrator
Posted

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

Posted
Posted

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

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

Posted
Posted

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

Posted
  • Author
Posted
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 4519 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

    Carl's Place
    PlayBetter
    Golfer's Journal
    ShotScope
    The Stack System
    FitForGolf
    FlightScope Mevo

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

  • Posts

    • Shindig
      ShotScope LM1 ($200 Launch Monitor/Speed Radar)

      By Shindig · Posted

      I have been debating getting a launch monitor of some sort, if only so I can re-figure my shot zones (I haven't actually mapped them in years) and also to practice distance wedges at home.  I have to see if this works with either my current setup, or what my setup would be if I move it to the garage.  
    • Shindig
      "5 Minutes Daily" Practice Challenge

      By Shindig · Posted

      Day 48, June 23.  After work today, I took 25 minutes in my practice room;  6-iron, same everything as yesterday except the time and count. 
    • Shindig
      PGA Tour Makes Sweeping Changes Starting in 2028

      By Shindig · Posted

      Well, this is interesting.  I think we discovered a few months ago that I haven't been following professional golf in a while (my confusion about Scotty's footwork confirmed that), so at least as I aim to follow a bit more I'll get something new to learn with all of you.  My very quick read of Erik's summary makes me think this new Challenger series fits somewhere between Korn Ferry and the Championship (not Champions, but I know I'm going to make that mistake a few times if I'm not careful!).   My recollection is that there were already second-tier events among the PGA Tour;  the Bob Hope didn't have the same quality of field as the event at Riviera (whose current name I forget, although now that I say that, I realize the Palm Springs event hasn't been called the Bob Hope in a few years either).   With the absence of the FedEx (if I'm reading that correctly), does that mean no more FedEx Cup at all? Hopefully I'll have time later in 2026 to sit down and see what we're in for in 2027, where one of my goals already is to follow more professional golf.
    • iacas
      PGA Tour Makes Sweeping Changes Starting in 2028

      By iacas · Posted

      The highlights as I see them: Championship and Challenger Series The creation of the PGA Tour and the PGB Tour, in the words of Joel Dahmen a few years ago. They're calling them the Championship Series (23-24 events) and the Challenger Series (20+ events). Both run February to August. They feel this will achieve three things: increasing the consistency and quality of fields across the season creating a clear system for players to earn and retain status and delivering a more structured and competitive experience for fans and partners—all in an effort to strengthen meritocracy. Championship Series Structure and Eligibility The 23-24 events includes the Players, majors, season-ending events, and the Presidents Cup and Ryder Cup. These will be 72-hole events with a 36-hole cut to the top 65 and ties and purses of $20M+. 120 players without an alternate list. 90 players (roughly) from the previous year and 20 players promoted from the Challenger Series. Full eligibility will be finalized later this year. Sites (cities) to be finalized soon, but 10 of the 15 courses have already been determined. Postseason: includes retention and relegation and concludes with match play. The Tour Championship will also be played across a rotation of prestigious courses. Challenger Series Structure and Eligibility 20+ events. Running concurrently. Will feature players fighting their way back to the Championship Series or players graduating and on the upswing from the Korn Ferry Tour. Many of these events will be current PGA Tour courses. About 7 of the Challenger Series events will be during off weeks for the Championship Series with elevated purses and visibility. Purses of at least $4M, with cuts similar to the Champ series. 144 player fields. Competitive Fields for Both Series Players will be eligible for only one series at a time: Championship Series Players are not eligible for Challenger Series events. Championship Series members will have a known schedule with all events having the same eligibility. Players and Majors will have their own eligibility criteria. Championship Series players don't have to play all events. This begs the question about, say, the Canadian Open, and other "home-town" events that players might want to play, even if they're Challenger Series events. Will releases be granted? Promotion and Relegation At least 90 players will be retained in the Championship Series, and 20 players will be promoted from the Challenger Series each year. Battlefield promotion for two-time winners from the Challenger Series. Players relegated from the Championship Series will have a "last chance" opportunity to retain status, or will go to the Challenger Series. Criteria will be finalized before the start of the 2027 season. Points System New points system (not FedExCup points). Separate points systems for the Championship and Challenger Series. Elevated points in the Challenger Series for off-weeks on the Championship Series. More details tk. Elevated International Events in the Fall The fall schedule will include a limited series of elevated international events with top players from the Championship Series, with the intent to deliver in partnership with the DP World Tour as part of the Strategic Alliance. Last Chance Series The Tour will develop a “last chance” series of 4-6 events in the fall, with a limited number of spots on the Championship Series available for top finishers. Eligibility will include players relegated from the Championship Series, Challenger Series players, and other categories to be determined. Q-School continues, as do the Korn Ferry Tour and PGA Tour Latinoamerica. Also, Brian Rolapp is the new commissioner as of January 1, 2027.
    • iacas
      PGA Tour Makes Sweeping Changes Starting in 2028

      By iacas · Posted

      You can download the PDF at this link or see the first page of it above.
×
×
  • 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