Code not working in Access 2007


I am having difficulty with getting code to work when i copy it from a forms control event procedure to another forms control event procedure, where the code doesnt recognise the controls.

e.g. form CameraDataEntry has a save button called cmdSaveRec. This button contain an event procedure on the click command. I copied this code to the cmdSave Rect button event procedure on the form ComputerDataEntry. I then amended the code to reference the controls on that form. For some reason, the code will not reference the controls and just doesnt work or i receive messages such "Method or data member not found", even though it does. Is some instances i am having to rename controls to get this work e.g. a control name Firstname which is on both forms, will not work in form ComputerDataEntry (the form i copied the code to), and thus i have had to change it to Firstname1.

Any ideas why this is happening? Is there a problem with access and bugs?

Kind regards
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
1. Always compile your code and run the compact/repair utility on a regular basis.
2. Sometimes even though the code on an event is there, you still must go through the control to get it to work.

You copy and paste this code to the form's module:
Private sub YourButton_Click()
msgbox "Button Clicked"
end sub

You sometimes still have to select the control in design view, open the property sheet, select the event (You may notice that the event is not there), then click the build button.

3. Sometimes copying and pasting code to disparate locations will corrupt the form.
Then you may have to delete, then re-insert the control, ...or in the worse case, you may have to rebuild the entire form from scratch.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
Also, make sure the DB is in a "Trusted Location".
...and for code on Reports, make sure the Report is opened in Print Preview explicitly, in order to run any code on any format events
dgi001Author Commented:
Hi Jeff

Thanks for this. You have just confirmed what i experienced on 2 occasions where i had to rebuild the form from scratch. I will have to build the code from scratch to avoid this in the future.
Jeffrey CoachmanMIS LiasonCommented:
Perhaps not, oddly enough, sometimes copying Code, Controls, Forms, Modules, ...etc from database to database works fine, ...sometimes not.

I am sure there is some universal root cause for this, but again, if you compile/Compact regularly, this should not happen often...

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.