January 19, 200323 yr I was able to create an "ADD RECORD" button that verifies if a user has hit the max allowed record limit. What i can't figure out is how to have the button actually create the record when i have disabled most menu options. It seems like if the menu choice for "new record" is not available then even my scripted button will not create the record. Is there a way around this? Thanks --Dan
January 19, 200323 yr Sounds like you might be disabling your users' ability to create records through the password. The restrictions you put in place through passwords are strict, so scripts cannot override them. Through passwords, you can also disable menu commands. Unfortunately it's pretty much all or nothing. The better way would be to use the plugin mentioned in the last post.
January 19, 200323 yr >> i have disabled most menu options. >> It seems like if the menu choice for "new record" is not available then even my scripted button will not create the record. hi, dan ! if you want the user to create record but not able to create the record through menu , then you can set this in a access previlige. 1. go to password / make a master password / then make a user password with limitation. 2. for the user previlige : in a box ---> select browse,edit,delete,create,print, override data and select menu command as "editing only".then hit done. 3. now close the file and re open it with user password to see if that is what you want. HTH... kyle
Create an account or sign in to comment