problem running command button

[semoho]

My database with all forms, reports, macros and modules work properly in Access 2003. Now I have installed Access 2007. After that none of my command buttons work. I tried to create a new database and form in access 2007 with some command buttons. I’ve inserted some visual basic codes in On Click Event for the command button as my previous project. But again it does not work. Do I have mistake in Access 2007 or I’ve forgotten something in my project?

For examples:

Private Sub EditCom_Click()
Me.AllowAdditions = True
Me.AllowDeletions = True
Me.AllowEdits = True

End Sub

 

[boblarson]

When you open your database there should be a button that appears just under the main ribbon to enable code. If you haven't clicked it when you open it up, code won't run.

 

[eepok]

Old Thread Bump -- Clarification

Hello again, all.

Ok, as I am still picking up on the vocab, I need some clarification on the above posts as I believe I have a similar problem.

I completed a great DB for my Dept. thanks to this forums (beers all around!) and have had to work on it back and forth on versions 2003 and 2007 depending on which laptops are available in the department (don't ask). The last bit to my database (buttons, print functions) were all done on 2003 and when I went to beta-test it on an Access 2007 computer (all the desktops are 2007), none of my buttons worked.

Ok, so the above-referenced problem refers to "command buttons" -- are these the same as "any" button? (such as mine that simply open reports).

If so, cool. I'll try what's said in the original response... once I get to work on a computer with 2007 again. =\

 

[boblarson]

Ok, so the above-referenced problem refers to "command buttons" -- are these the same as "any" button? (such as mine that simply open reports).

If so, cool. I'll try what's said in the original response... once I get to work on a computer with 2007 again. =\

Yes, those are the same buttons. Here's a quick visual of what I had in my previous post:

http://www.btabdevelopment.com/main/LinkClick.aspx?link=57&tabid=55&mid=385

 

[eepok]

Rockin'. Will do.