accde form load - code won't run!

  • Thread starter Nikos Yannacopoulos
  • Start date
N

Nikos Yannacopoulos

I have a A2K3 .mde front-end (converted from a previous A2K), which has
been in use for years. Now that the organization has upgraded to Office
2K7, I converted the .mdb to accde and it runs fine. I make an .accde
from it, and ran into problems! The original version used an autoxec
macro to run some code at start-up, which is OK with the .accdb, but
creates a 2950 error in the .accde.
I've searched and found proposed solutions, which did not work (trust
did not resolve it, 3rd party .exe utilities which supposedly fix it in
the registry are not accepted by the company policy, and I don't trust
them anyway).
So, I thought I'd give up on the autoexec macro, and use a form's Load
event... I created a dummy form just for the purpose, which does the job
just fine in the .accdb. I created the .accde, and the code in the Load
event (or the Open event for that matter) won't fire! The very first
line of code is a simple msgbox, so I know the event has kicked in, it
works in the .accdb, it does not in the .accde.
Anyone seen this? Any suggestion how to go about it?
TIA,
Nikos
 
N

Nikos Yannacopoulos

Access will always be Access! I created a new, blank A2K7 .accdb,
imported all objects from the A2K3 .mdb, created the .accde, and the
form Load event fires and executes just fine!
I should have resorted to the oldest trick in the book right off...
 
H

'Hollywood' Ben Basri

Hey It's the new guy 'Hollywood' Ben Basri and I would like to say to you
ladies to talk to me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top