• Announcements

    • iacas

      Introducing TST "Clubs!"   08/28/2017

      No, we're not getting into the equipment business, but we do have "clubs" here on TST now. Groups. Check them out here:
Sign in to follow this  
Abu3baid

Mistakes that make you do your work over again!

Recommended Posts

Abu3baid    100

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?

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Sign up (or log in) today! It's free (and you won't see this ad anymore)!

Sign up (or log in) today! It's free (and you won't see this ad anymore)!

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.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Abu3baid   

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!

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

iacas   

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Abu3baid   
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!

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Abu3baid   
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:

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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

Sign in to follow this  



  • Want to join this community?

    We'd love to have you!

    Sign Up
  • 2017 TST Partners

    Talamore Golf Resort
    PING Golf
    FlightScope Mevo
    Mission Belt
    Snell Golf
    Frogger Golf
    PitchFix USA
  • Posts

    • Hit the range, and only got to hit like 15 balls, with about 4 times as many practice swings. Took like an hour to hit 15 balls?!? My driver would have been usable on the course, and I was drawing my irons a bit too much, but it was somewhat controllable with the face angle. Distances on driver were short while the shorter irons were carrying further than usual? My 6i carries exactly the same on goo shots as in warm weather. I was having fun with my irons this morning. It was about 45F early on in the Arroyo before the sun came out even though the official city temperature was around 58F. The lower temperatures might have been the cause for the funny ball behavior? The tempo training seemed to help my swing a lot. Now, I need to remember everything before my swing and kind of ingrain this behavior a bit.
    • New course yesterday and only 30 putts with no 3 putts.  I know the golf gods will get me for that though!
    • You got that right! If your not competing for something, why are you out there? We'll compete for as little if, I beat you, you owe me a beer! There's gotta be something on the line!
    • Took them out to the range and suffered for it, since it got about 90 degrees here! Is this Fall? Actually had to go sit in the shade and drink some water about half way through. Actually got both clubs pretty well straightened out, and hit them for decent distance and direction. Both shafts are labeled R, but felt completely different, the TM shaft feeling much softer. Thus the ongoing shaft nonsense! The Callaway produced a nice, high pitched "crack" when I hit the ball as opposed to the low "thunk" of the TM. The sound of the ball leaving the face didn't seem to have any impact on how the ball flew. I also brought along my current Driver, a Cobra King F6m adjusted to 12 degrees loft. The TM was the "standard" 9.5*, and the Callaway was 11*. I could get more air under my drives, and more carry, with the Cobra than the other two. It was not a huge difference, but there was a difference!  
    • http://www.gamegolf.com/player/Shindig/round/1858113   86 at my home course.  40 first nine, including a chip-in birdie on #9.  46 second nine, including three doubles (#s 13, 14, and 17).   Lost 3.12 off tee, 4.94 on approach, 0.7 on short game (!!!), and 4.94 on putting. Thoughts:  two really bad tee shots, plus a weakling.  Hole #1, pulled into a tree, hole #14, a hook into some trees.  Glad to have not lost a ball on either.  Hole 2, just hit a weak drive.  Other than that, I think my drives were pretty good.  Only other meh one was a slice that came out of nowhere on #18, and then I followed it up with a stupid shot that could have gone into the driving range.   First round with new irons, hit 5 GIR and 5 near-GIR.  Had three holes where my birdie attempt came with a full swing shot (but within 100;  two were full flight gap wedges) that hit the green, so that had to have helped my short game stat.  Putting was unimpressive and I missed enough short ones that my two really good 2-putts (#2, #3) don't really make up for it.  Still, a round where I didn't really feel in control at any point and I played to my handicap.  That's pretty good!
  • TST Blog Entries

  • Blog Entries

  • Today's Birthdays

    1. StevenR84
      StevenR84
      (33 years old)
  • Get Great Gear with Amazon