Problem with accde file

[Yippiekaiaii]

Hello All

I have created a accde file from a database to restrict users from making changes to it.

However this has had the side effect of preventing any vb code from working.

For example I had a text box that had vb code attached to it, that acted as a filter based on what you typed in. This no longer works.

I have already added the databases location to the trusted locations in the trust centre (i had to do this to stop a warning message every time the db loaded), but I am not sure how to resolve this.

Any ideas?

 

[eirman]

You have do the following from the VBA editor
Debug > Compile and then create the accde file

See the last post here ...
http://www.pcreview.co.uk/forums/vba-code-does-not-work-using-accde-file-t3636317.html

 

[Geertzelf]

Thanks for this post! I had this Problem too. Now it works fine!