Richard - Thanks for all your work. We really appreciate it out here. Im working in ACCCESS 2007. This is the first "glitch" I have been unable to figure out. I placed the command button for closing the database on MainMenuF (at the end of Access 103 Lesson 4). When I clicked the button I got the error "You have entered an expression that has an invalid reference to the property Dirty." I found the following 2 lines of code in the click() Subroutine for the button: If Me.Dirty Then Me.Dirty = False DoCmd.Quit
When I deleted the first line, the button worked properly and closed the DB. I went through the procedure 2 more times with the same results. Am I doing somethging wrong or is this a glitch in 2007 or what? Thanks.
Reply from Richard Rost:
William, I've never encountered that problem before. The wizard should not have placed that code in your button. Try deleting the button and create it again. Let me know how it works.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.