troubleshooting Question

Code not working in Access 2007

Avatar of dgi001
dgi001Flag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
4 Comments1 Solution262 ViewsLast Modified:
Hi

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
DGI
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros