form password gone after saving accdb as accde

[collins_jd]

About to disperse front end to users. clicking through to make sure everything worked and noticed all the passwords that were added in the form property / events are gone. pic of code attached. I cant add them back in accde file. how do I require pw for those forms? sorry, new to access... i googled a bunch before asking but couldnt find an answer.

 

[pbaldy]

The code is compiled and no longer visible in an accde, but it should still work as before. Are you saying it doesn't?

 

[collins_jd]

The code is compiled and no longer visible in an accde, but it should still work as before. Are you saying it doesn't?

@pbaldy correct. the code is visible and functions in accdb. when i save the accdb as accde, the forms no longer ask for passwords. Idk if the code is still in the properties of the form because after it is saved as an accde i am no longer able to open the form in design view to see the property sheet. the accdb i saved it from however is in tact and forms still ask for passwords.

 

[arnelgp]

you need to Enable the macro warning.

 

[collins_jd]

you need to Enable the macro warning.

@arnelgp ok, can you give me a hint how to go about that. new to access. i will search how to do that but would greatly appreciate a hint lol

 

[arnelgp]

i save the accdb as accde, the forms no longer ask for passwords.

exit you access and run the .accde again.

 

[collins_jd]

exit you access and run the .accde again.

i have done that. the forms ask for criteria in the query but do not ask for password. currently reading whatever i can find to try and fix. Thanks for trying to help.

 

[arnelgp]

are you sure you are running the same db (only converted to accde)?
coz sometimes i Save files to MyDocument only to find out that I have saved it MyDocument in Onedrive?
so better create again the .accde and take note where the file is being saved.

 

[collins_jd]

i have done that. the forms ask for criteria in the query but do not ask for password. currently reading whatever i can find to try and fix. Thanks for trying to help.

i wish lol everything is saved on a trusted folder on desktop. the only thing i put in onedrive was the back ups i made each day before i split the database and i had to pull those out of the trusted folder to move to onedrive. ive found several posts in other blogs with people having same issue. i found this and will try since its the simplest of the things ive read

"Before converting it into an accde format you should test ALL your code by "compiling" it. Everything may appear to work in the accdb version but when converted won't work if there are some problems.

To "compile" it you open your accdb version and go into any of the code. Then select the DEBUG menu option and select COMPILE (1st option). If you get any errors then fix them and the compile again just to double check. Then try creating your accde again."

crossing fingers and toes

 

[Gasman]

the forms ask for criteria in the query

Is that by design, or missing parameters?

 

[collins_jd]

Is that by design, or missing parameters?

by design so the accounting dept can pull data by office etc

 

[gemma-the-husky]

Well, I don't see why your form doesn't ask for the password.
Do you get the input box or nothing at all?

I do note that you don't have option explicit, at the top of the code module, and you should have that in every module. Maybe adding that that will indicate the issue.

Incidentally, I had seen this question, and then couldn't find it again. It seems strange that it's in "Reports". Forms would make more sense.