Login page and Welcome note

[annliang]

Here're something I want to achieve in my database (Access 2010):-

1. To create a login page

· The table “tblUsers” has been created.
· The login page will be popped up once the database is opened.
· The user1 will be set to be an administrator who has the right to edit the info and the structure of the database. (User1’s password: 1234)
· The user2 will be set to be an end user who will be responsible to create a quotation request through the form “frmQuotationAllinOne”. (User2’s password: 5678)
· The user3 will be set to be a supervisor who will be responsible to approve/reject/give comments to the quotation request. (User3’s password: 2468)

2. Welcome note

· Once the login procedure is done, the Welcome note will be popped up.
· Under On Load event, I have keyed in the event procedure. It worked sometimes and sometimes not. It seems that the Access database is not performing consistently and stably. Do you know why?

I have been searching the info and working around for more than a month, but still couldn't accomplish it. It may be due to the fact that I'm a newbie to the Access and have no knowledge about VBA code or Macro. Anyone who can amend the database directly for me would be highly appreciated.

 

[sensetech]

I get the same error if I added even the simplest of code to the Load event of any of your forms but I have no idea why!

If however I created a new form and gave it a Load event all was fine. I copy/pasted all the controls from WelcomeNote onto my new form and it was still OK, coming up with correct time-of-day message.

So, I don't know what's strange with your forms but I suggest you create new versions of each one then copy/paste the properties & controls over. Do each form in stages, testing a Load event after stage just in case on of the Form's property settings is causing the problem.

Not an elegant fix, I know, but if no-one comes up with anything better ...

 

[annliang]

Thank you so much for your reply, sensetech! It does help me knowing that my Access has some problems.

Regarding #1 Login page - I have done a login form which can pop up once the database is opened. After login, the form is closed and Welcome note is opened instead. That's done.

But it is somehow different from what I want. Anyone who can give me some input would be REALLY appreciated. Many thanks!