Different userlevel,different background

[haroldunlimited]

HI guyz,

Im making a ms access database and I would like to use different background for the different user level,once they log in.how is this possible?
thanks guyz.....

[balame2004]

HI guyz,

Im making a ms access database and I would like to use different background for the different user level,once they log in.how is this possible?
thanks guyz.....

Hi,

Yes it is possible. All you have to do is, maintain a table for user levels(or user type). Define a template(or styles - background color, font style,etc) for each user level and use it during runtime based on the user who is logging into your application.


Cheers,
Balaji U

[haroldunlimited]

Thanks,


Dou you have the code for this?

[balame2004]

Thanks,


Dou you have the code for this?

Hi,

Here is some idea how to do it.

1.Style - Save background color and font for each type of user in database.

Create tables
1. UserLevel (UserTypeId,UserTypeName,BackgroundColor,FontName)
2. Users(UserId,UserTypeId,UserName,LoginId,Password)

Here UserTypeId refers UserTypeId of UserLevel table.

Add UserLevels and define styles.

2.Show Style - Retrieve style from UserLevels table based upon the type of user logging in and set the style to your web page.

- Balaji U