Change Button Password from Another Button on Another Form

[christobal]

Re: Change Button Password from Another Button on Another Form

Have just whipped up an example of this functions use

[Rudy16]

Re: Change Button Password from Another Button on Another Form

Tom,
I received your data base and I'm confiused. So what's now.
I thought you aere going to show me the syntax on how to code the "is_one_of() and "User_Groups() which would be placed on the Main Menu Button called "Administrative Menu" so when the user pushed it, the security test would occur.

I set up the users and groups and database login password which worked fine however after I selected my user name and password, instead of opening the Main Menu, it opened the control panel. When I selected the Main Menu form and pressed the Administration Menu Button, I received an "empty expression" error message.

[Rudy16]

Re: Change Button Password from Another Button on Another Form

Very nice Charlie.

Once a user logs in with his name and password and procedes to the Main Menu and presses the "Maintain Users" button
- if the person logged in does not have adinistrative rights per security table,
- want to display a message "No Administrative Rights - see Administrator " and
exit the script and remain in the Main Menu so he can either Exit the application
or proceed to another Menu via another Button.
- if the person logged in "does" have administrative rights,
- want to Open the Administrative Form.

I changed my entry to a level 2 and still was able to proceed to "Maintain Users" on a Push. Is this an easy fix or am I way off base on this?

Thanks in advance for your patience with me.

Rudy

[Tom Cone Jr]

Re: Change Button Password from Another Button on Another Form

Rudy, oops. I uploaded your old zip, instead of the modified one. Will fix and upload with a new filename. Standby.

Later...
Ok, here you go. Unzip this to an empty folder. Do not unzip it to your existing database folder. Open the database with vers 9. Log in as Rudy or Tim. Push the button on the Main Menu. Rudy cannot get to the second form, Tim, can. The work is done in the onPush event script for the Administrator Form button. Notice the conditional expressions attached to the two Actions.

This can be improved further, but I'd need the Administrator's password for the database, which you have not yet supplied.

-- tom

[Rudy16]

Re: Change Button Password from Another Button on Another Form

This is nice! I'm really excited. The administrators password is dobie.

When the user is a member of the user_group, it opens the form. When the user is not, it drops into the Control Panel. It would be nice if a message box appeared that stated "Not Authorized" and allowed the user to stay on the Main Menu and go somewhere else where he/she is allowed.

Can you modify the Conditionsl statement with an if, else, then statement?

I also created a security Menu using the A5_Security_Option's and it's great. This way the clubhouse president who is the administrator can add or delete users and change passwords.

Thanks again,
Rudy

[Tom Cone Jr]

Re: Change Button Password from Another Button on Another Form

When the user is not, it drops into the Control Panel.

That will only happen if you close the Main Menu form. In my example this never happens because I removed the close form ACTION from your previous script. Are you seeing this in my example? If so tell me the exact sequence of steps that drops Rudy down to the control panel after he logs in.

In my example the Main Menu form is opening immediately after log in. I made it the startup form for the database. My "Administrator Form" button does NOT close the form. The second form is opened on top of it.

--tom

ps dobie is NOT the administrator password for the database you posted here. I still can't log in as Administrator

[Rudy16]

Re: Change Button Password from Another Button on Another Form

I see it. Your help is so much appreciated. I've spent hours researching the How To's in Alpha's Help System (there is sooo much to learn). I found that some of the examples leave of lot to be desired (Syntax not clearly defined), however, I have to say that Alpha5 blows away the competition.

I'm working on an application for our Clubhouse. I live in a Senior Citizen community. They currently have an Access system that is "sooo bad". What I have now blows away their application and I'm just starting out. I can't wait to become proficient in Alpha like all of you. I too will help newbie's like you and others on this board once I master Alpha.

The clubhouse does not have a network server setup. I beleive that the computers are attached via cable? I have to check their configuration one day.

Again, my thanks to all that spent their valuable time to provide me with some code examples. Once this is cleaned up, I would share it with anyone that was interested.

[crimmelcp]

Re: Change Button Password from Another Button on Another Form

Rudy
I changed the code on the maintain users button
to give message

"User has No Administrative Rights"

see attached zip

[Rudy16]

Re: Change Button Password from Another Button on Another Form

I unzipped ot to the same directory however when I ran the app, enyered my name and password, a windows popped up stating tha "It could not load the specified form "Main Menu", using a Default form" appeared and when I clicked OK, it took me to the Maintain Users Form??

[Tom Cone Jr]

Re: Change Button Password from Another Button on Another Form

I can't help you without a current copy of your database. Your posts will be easier to understand if you don't use the word "it". That's a word that means something to you, but could mean a variety of things to your readers. All I can tell is that you unzipped something to some directory and have a problem. Not much for me to go on, is there?

The error message suggest the database you were opening does not contain a form named "Main Menu". I have no clue why that should be unless you've renamed or deleted the form I used in my example.