Question Question about forms

[Jay-Ree]

Hey guys in school we are making a database/ui for a hotel company.

On the user interface (forms) we have a members login. But the after the members login it takes you to a splash member page. Here comes my problem. Lets say they want to check their details. They click 'Members Details' but again they have to login to see their details.

Is there any way to get it so they only have to log-in once rather then about 5 different times?

Yours help appreciated.

Jay.

 

[DanWall]

After login, you could set a 'TempVar' property, using the member's ID.
Then use that to filter any forms that load thereafter.

 

[Jay-Ree]

Hey thanks for the fast reply. As I'm not really good with access, could you possibly give me an example of how I would do this. I know some VB as well so I kinda get it just not fully.
Thanks Jay

 

[DanWall]

Sure.

When your user logs in, he/she must click 'something' to login.
In that control's events macro 'On Click', add a SetTempVar action to the macro,
AFTER the login stuff you already have executes.

Call the SetTempVar something like "UserID" and set the expression to refer to the Member's ID key that just logged in.

I don't really know the specifics without getting in and playing around (which unfortunately I have no time for at the moment )

Hope it gets sorted for you.

 

[Jay-Ree]

Thanks again I'll give that ago Thanks mate.

Jay