Converting VBA Code

[Guest]

I've recently converted to Access 2007 from Access 2000. Some of the
simplest procedures no longer work in my updated databases. For example
DoCmd.Maximize as an event procedure in the OnOpen event or DoCmd.GoToRecord
acDataForm, "HouseholdItems", acNewRec in the OnLoad event. When I open the
form in question it opens to the first record and in minimized format. I've
tried re-entering the code and still get the same result. Is there a simple
change that the conversion failed to accomplish? Is there a simple fix?
Thanks for the help. Dave from Victoria

 

[Allen Browne]

Dave, you may need to tell A2007 that the folder where your database reside
is trusted. Otherwise none of the code will run.

Go to:
Office Button | Access Options | Trust Center | Trust Center Settings
and add your directory there.

Post back if that doesn't solve the problem.

Here's further info on the issues when converting to A2007:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

Dave, you may need to tell A2007 that the folder where your database reside
is trusted. Otherwise none of the code will run.

Go to:
Office Button | Access Options | Trust Center | Trust Center Settings
and add your directory there.

Post back if that doesn't solve the problem.

Here's further info on the issues when converting to A2007:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message


Thanks Allen, I will definitely try that and will post again if problems persist. Dave