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.

[June7]

The Time() function returns time value in AM/PM structure. Your code is set up for 24-hr clock. Try:

varTime = Format(Time(), "Short Time")

Login form is a common topic in forum. Here is one https://www.accessforums.net/forms/m...orm-24841.html

[annliang]

Thank you so much for your reply, June 7!

Basically, I have gone through lots of info in regards to Login Form creation. And I have checked the links that you gave me. The fact is that those info are too advanced for me. I can hardly comprehend. I tried to follow but somehow doesn't work at my end. Some error messages popped up and I didn't even understand what that meant.

I have done a login form which can pop up once the database is opened. And after login, the form is closed and Welcome note is opened instead. That's done. But it is somehow different from what I want. QuotationDatabase2.zipQuotationDatabase2.zip

I would be much appreciated if anyone can help me out by amending my database directly. Thanks in advance!

[June7]

Is the error you see: "The expression On Load you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control."?

The only way I could eliminate that error was to rebuild the WelcomeNote form. Sometimes Access gets corruption and rebuild is the only recourse.

So now you have a login form. What purpose does it serve? There is no password and therefore no access control. The user ID is not saved anywhere for subsequent use by other procedures.

Not going to build for you. You need to learn relational database principles, programming concepts, Access functionality, code language (macro or VBA). That won't happen over a long weekend. If you have no background in programming, recommend you take a class.