Connecting Tech Pros Worldwide Forums | Help | Site Map

Converting accdb to accde VBA code is not working

Familiar Sight
 
Join Date: Apr 2007
Location: Lebanon
Posts: 211
#1: 3 Weeks Ago
Dear friends

I am working on access 2007 sp2.

I do have a database(accdb) i converted it to accde.

While I am opening the converted database the VBA code is not working.

For example
Expand|Select|Wrap|Line Numbers
  1. docmd.maximize
on each form is not working and forms won't maximize

Is it a bug on my office or I am doing something wrong...


Could you please point me to the write direction


Thank you all

missinglinq's Avatar
Moderator
 
Join Date: Nov 2006
Location: Richmond, Virginia USA
Posts: 3,002
#2: 3 Weeks Ago

re: Converting accdb to accde VBA code is not working


Are you running the accde file from the same folder as the original accdb was run from, or from somewhere else? Does other code run?

Remember that in order for code to run in Access 2007, the file has to be in a folder that has been set as "Trusted."

Linq ;0)>
Familiar Sight
 
Join Date: Apr 2007
Location: Lebanon
Posts: 211
#3: 3 Weeks Ago

re: Converting accdb to accde VBA code is not working


Yeah I am running my accde file in the same folder root.

also I added a trusted location and I enabled all macros.

Nothing on the code is working (VBA) Macros are working well.

P.S all code is working well before the accde conversion
Reply