Accde file won't run code, but form changes are there

[Repent]

I have a DB that I needed to modify. I went to the original, unsplit accdb file, made changes to forms, and created another accde file and published it. all files were kept in the original location. When I then open a form none of the VBS scripts run. I have event procedures setup for "on load, on dirty, on click, etc. The form changes are there but the code doesn't run. The location of the files is set in the Trust Center. When I run the original DB in the accdb format, everything works great.

To TS, I created a new DB and imported in the tables, forms, queries, etc but still would'nt run. I setup a lab computer with no group policies and tested, didn't run. Logged into the local workstation and not the domain, still no good.

I've upped the permissions on the folder where the files are, no good.

Tried everything I can think of. Any thoughts anyone?

chris

 

[pbaldy]

I don't have the reference handy, but try making another accde, but compile the code right before creating it. There is/was a weird quirk where that was necessary.

 

[Repent]

I don't have the reference handy, but try making another accde, but compile the code right before creating it. There is/was a weird quirk where that was necessary.

I don't believe I saw anywhere where to compile the code before making the accde. How/where do I do that?

chris

 

[SOS]

I don't believe I saw anywhere where to compile the code before making the accde. How/where do I do that?

chris

Go to the VBA window and then click DEBUG > COMPILE from the menu.

 

[Repent]

Go to the VBA window and then click DEBUG > COMPILE from the menu.

compiled code, then split DB, then created accde. Ran accde file, same problem, no event procedures working.....

 

[pbaldy]

Well, what I mentioned was to compile the code right before creating the accde. I recall having this issue when I first started using 2007. It is now my habit to compile immediately before creating the accde.

 

[Repent]

Well, what I mentioned was to compile the code right before creating the accde. I recall having this issue when I first started using 2007. It is now my habit to compile immediately before creating the accde.

ok my issue is fixed!! What I had to do was to make a change to the form, in any fashion, compile the code, then create the accde file. Found an article online from 2005 explaining this and it also works with 2007 version.

I had also tried to resolve by opening the original DB, compile the code, then create the accde file. Didn't work. Seems the trick was to make a change to the form, then compile and create the accde file.

thanks all for the insights;
chris

 

[jennizona]

That has got to be the absolute stupidest solution ever.. so naturally it worked. Thank you figuring it out and posting it!