31 – Log-In Form

Click here to go to the downloads page
Please select DbVideo31

Related Posts

1 Video, 1 Database
01 – What is MS Access
02 – Access As A Relational Database
03 – Normalization
04 – Tables A
05 – Tables B
06 – One To Many Relationships
07 – Many To Many Relationships
08 – Basic Tables
09 – Select Queries (Criteria)
10 – Select Queries (Calculated Fields)
11 – SubReports
12 – Banded Reports
13 – Embedding A Sub-Report
14 – Introduction To Macros
15 – Summary Report
16 – Select Queries (Referencing A Form)
17 – Continuous Forms
18 – Sorting a Continuous Form
19 – Filtering A Continuous Form
20 – Data Entry Forms
21 – Opening A Data Entry Form
22 – Creating Consistent Forms
23 – Creating Consistent Detailed Reports
24 – Creating Consistent Summary Reports
25 – Action Queries (Append And Delete)
26 – List Boxes
27 – Action Queries (Update)
28 – Combo Boxes
29 – Select Queries (Returning Null Values)
30 – Requery Statement
32 – Macro Dlookup Functions
33 – Referencing A Control On A Form
34 – Update Queries, Temporary Variables
35 – Auto-generating a Record (No VBA)
36 – DCount Function
37 – Creating an Invoice A
38 – Creating an Invoice B
39 – Validation Rule
40 – How Access Handles Dates And Times
41 – Pivot Table
42 – Switchboard Form
43 – Styling The Database
44 – Sunken Effect On List, Combo and Text Boxes
45 – Advanced Macros 1 (Preparation)
46 – Advanced Macros 2 (Single Class)
47 – Advanced Macros 3 (Multiple Classes)
48 – Reports (Force New Page)
49 – Logging Attendance
50 – Macro Error Handling
i – Look-Up Fields
ii – Where Condition

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

1 Comment

  • belinda martinez says:

    Hoping for Help!!

    Access 2010-Web Database published to SharePoint. I am using the Issues template to verify user information, and on-load of the Main Form I also want to secure [Tab1] and [Tab2] subforms according to the currentwebuser() credentials. In the User’s table, I added a field [SecurityLevel] which defaults to “User” so when a User is added, the user is automatically assigned “User” level permissions to the site. [Tab1] will only be available to administrators and [Tab2] to TD, so on-load the macro should verify if the currentwebuser has “admin” or “TD” level permissions. If they do not, then [Tab1] [Tab2] are disabled.

    Since this is a web database, vba code is worthless. I don’t know how to set it up.

    I was hoping to add an If statement that checks the security level and then enables the tabs accordingly, at the MainForm but I keep getting the Object Item: SecurityLevel is missing.

    I appreciate the time. Thanks!![