Do You Ever Just Struggle - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Do You Ever Just Struggle

Joe Holland

14 months ago

My database was built 30 years ago, and I work on it regularly. I watch Richard's videos every day and they give me ideas of things to add, update, or modify completely. That is the fun part. Today I spent 4 hours trying to figure out why a form I built a year ago stopped working as designed. I did not change the code so why would it only open to a blank form? I tried everything I knew and even made up some stuff. I then ran down the troubleshooter and even decompiled for the first time in my life. Nothing worked. My command line is correct: DoCmd.OpenForm "EmailMessages", , , "EmailID=" & EmailID. So, what the *&$%! I was frustrated and wasting a lot of time. Boy did I feel stupid after I realized the problem. Somehow (probably an errant click on my part) changed the forms Data Entry property from No to Yes. I changed it back and the form opened to the correct records once again. I guess we are destined to struggle sometimes over the smallest of details.

Jeffrey Kraft @Reply

14 months ago

Been there messed with that.  I have a projected I did before I had a clue what I was doing.  It worked OK for 5 years or more. I sadly didn't back it up enough.  It broke a ton of Richard's rules - and I tried to fix those I could.  Anyways I'm completely redoing things (correctly).

Last week I modified a sub or a function worked fine if called from a button, but the same set of code would fire I would get a Runtime error 2585. Spent what felt like forever.  Saved my form.  Built whole new version of it. Button worked.  If I proceessed off of the Msgbox, which was something like, Would you like to process the transaction.  Yes or No. I select Yes, Access laughs and me. I pull all my hair out, head to a bar and swear I will never code again.

Yes I evenutally found the flaw.  It was clear back at the Yes No question area.  Bad news I lost several hours thanks to the goof. Good news is I actually ended up with a better form.  Go figure.  Note to self. Instead of more cowbell... add more 'Remard statements so I have an idea what I was trying to do.

	Joe Holland OP @Reply 14 months ago
I bet there are hundreds of stories like ours.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View