Search results

Pat (and anyone else reading through this), I found the major part of my issue. Others may have similar issues, so posting it here. The Access database will be used primarily by users with Access 2007. My PC with access to the SharePoint has Access 2010. I have 2007 on another PC. I brought...

Side note: I noticed the "On Click" events were stored in MS Access Class Objects, not VBA modules. Could that be my problem?

Thanks Pat, but still having issues. Here are scenarios. Scenario 1: Close button has "On Click" code you suggested: Private Sub CloseForm_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.Close End Sub When click, no action takes place. Form does not close. Therefore, I concluded...

Pat, I did something wrong. In form design, with selection type "form", I selected the "Before Update" on the Event tab. In the build box, I selected code and entered the following: (Actually, there are 9 questions total. Just giving the "flavor".) When it didn't work, I entered the same code...

I am very familiar with VBA for Excel, so was not adverse to using it in Access. Just didn't know where to put it. I'm SO glad Pat was clear - BeforeUpdate! I can't tell you how much this saves me. BTW - Thanks to Adyas for asking the right question. That's always important. Gin

Didn't get around to posting my question today. Other things came up. Probably won't be able to post until next week. Friday is my busy day.

Thanks for explaining where Belleview is. I've never been to Florida, but sounds like that would be a great place because inland enough not to have to worry about hurricanes. And close to tourist Orlando, but far enough away as to not be bothered by the crowds. Interesting story about trip back...

Rochester, NY area. (Between Buffalo and Syracuse) I see you're from Belleview, FL. What part are Florida is that?

Dick S. I appreciate the tip on a reliable contact. Looking forward to solving an issue I'm having. Gin

I'm joining because I work from home and need MS Access help. I used to be able to go to my favorite "guru's" desk and ask. Hope this works the same way. I am considered by most to be an Excel SME. In addition, I am fluent in VBA for Excel. My last position I worked with MS Access 2003...