Create Login Form Access

👉 Check out my grocery database, https://grocerydynamite.com/

We need a table that relates users to the level of access they have in the database. The 3 columns needed are Username, Password, and Security Level.

We need a form that lets us enter our password and check the database for validity and deny entry to invalid credentials. A VBA Macro is also needed to make this work.

The forms we need are
Admin
Login
Welcome

-Code-

Dim Userlevel As Integer

If IsNull(Me.username) Then
MsgBox “Please enter the correct username.”, vbInformation, “Username required”
Me.username.SetFocus

ElseIf IsNull(Me.password) Then
MsgBox “Please enter the correct Password.”, vbInformation, “Password required”
Me.password.SetFocus

Else
    If (IsNull(DLookup("username", "UserAccount", "Username='" & Me.username.Value & "'"))) Or _
    IsNull(DLookup("Password", "UserAccount", "Password='" & Me.password.Value & "'")) Then
    MsgBox "Username or Password is Incorrect!", vbCritical, "Login Denied"
    Me.username = ""
    Me.password = ""
    Me.username.SetFocus

Else
Userlevel = DLookup("[Security Level]", "UserAccount", "Username='" & Me.username.Value & "'")


        If Userlevel = 1 Then
        MsgBox "Access Granted... you may proceed!", vbInformation, "Authentication Succeeded"
        DoCmd.RunCommand acCmdSaveRecord
        DoCmd.Close
        DoCmd.OpenForm "Welcome"

End If

        If Userlevel = 2 Then
        MsgBox "Access Granted... you may proceed!", vbInformation, "Authentication Succeeded"
        DoCmd.RunCommand acCmdSaveRecord
        DoCmd.Close
        DoCmd.OpenForm "Admin"

End If
End If
End If

End Sub

Amazon Business American Express Card

Now retrieving the rating.

$23.00 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
【4K Quality】The NexiGo N950P webcam comes with an 8.5 Megapixel Sony sensor that features up to 3840 x 2160 QHD resolution at 30 frames per second for crisper images and clearer videos. 【Remote with 5X Digital Zoom】Control your video calls with a rem...
Zoom Certified, NexiGo N950P 4K Zoomable Webcam with Remote Control, Sony_Starvis Sensor, 5X Digital Zoom, Pro Web Camera with Dual Stereo Mics, for Zoom Skype Teams Twitch

Now retrieving the rating.

Available for Amazon Prime $129.99 (as of November 20, 2024 21:38 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
【4K Quality】The NexiGo N950P webcam comes with an 8.5 Megapixel Sony sensor that features up to 3840 x 2160 QHD resolution at 30 frames per second for crisper images and clearer videos. 【Remote with 5X Digital Zoom】Control your video calls with a rem... read more
【4K Quality】The NexiGo N950P webcam comes with an 8.5 Megapixel Sony sensor that features up to 3840 x 2160 QHD resolution at 30 frames per second for crisper images and clearer videos. 【Remote with 5X Digital Zoom】Control your video calls with a rem...
Zoom Certified, NexiGo N950P 4K Zoomable Webcam with Remote Control, Sony_Starvis Sensor, 5X Digital Zoom, Pro Web Camera with Dual Stereo Mics, for Zoom Skype Teams Twitch

Now retrieving the rating.

Available for Amazon Prime $129.99 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
【4K Quality】The NexiGo N950P webcam comes with an 8.5 Megapixel Sony sensor that features up to 3840 x 2160 QHD resolution at 30 frames per second for crisper images and clearer videos. 【Remote with 5X Digital Zoom】Control your video calls with a rem... read more
KEYBOARD: The keyboard has hot keys that enable easy access to Media, My Computer, Mute, Volume up/down, and Calculator EASY SETUP: Experience simple installation with the USB wired connection VERSATILE COMPATIBILITY: This keyboard is designed to wor...
Amazon Basics Wired Keyboard, Full-Sized, QWERTY Layout, Black

Now retrieving the rating.

Available for Amazon Prime $20.89 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
KEYBOARD: The keyboard has hot keys that enable easy access to Media, My Computer, Mute, Volume up/down, and Calculator EASY SETUP: Experience simple installation with the USB wired connection VERSATILE COMPATIBILITY: This keyboard is designed to wor... read more

Introducing the NETGEAR Nighthawk M6 5G WiFi 6 Mobile Hotspot Router (MR6150), the ultimate 5G mobile internet experience.

 

With its powerful Qualcomm Snapdragon X55 modem and advanced Wi-Fi 6 technology, you can now enjoy fast speeds, reliable connections, and increased coverage for your mobile hotspot needs.

 

The Nighthawk M6 is compatible with both 4G and 5G networks, so you can take advantage of the fastest speeds available on the market.

 

It also features a built-in battery that provides up to 10 hours of continuous use, so you can stay connected while on the go.

 

Additionally, it has an intuitive touchscreen

Patented Crusher Sensory Bass Technology - Skullcandy Crusher is the original, immersive, adjustable sensory bass. Your music and movies will come alive with a sound experience you can actually feel. Crusher Bass is unlike anything you’ve ever heard ...
Skullcandy Crusher ANC 2 Over-Ear Active Noise Cancelling Wireless Bluetooth Headphones with Sensory Bass, Skull-iQ Voice Control, 50 Hr Battery, Microphone – Asphalt

Now retrieving the rating.

Available for Amazon Prime $229.99 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Patented Crusher Sensory Bass Technology - Skullcandy Crusher is the original, immersive, adjustable sensory bass. Your music and movies will come alive with a sound experience you can actually feel. Crusher Bass is unlike anything you’ve ever heard ... read more
Ultimate versatility with high-performance, secure, 5G with WiFI 6 technology at home or on the go Unlocked and certified with AT&T, T-Mobile and Verizon. Swap SIM cards and data plans in seconds Take M6 on the go as a more powerful, secure alternati...
NETGEAR Nighthawk M6 5G Mobile Hotspot, 5G Router with Sim Card Slot, 5G Modem, Portable WiFi Device for Travel, Unlocked with Verizon, AT&T, and T-Mobile, WiFi 6, 2.5Gbps (MR6150)

Now retrieving the rating.

Available for Amazon Prime 21% Off $699.99 $549.99 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Ultimate versatility with high-performance, secure, 5G with WiFI 6 technology at home or on the go Unlocked and certified with AT&T, T-Mobile and Verizon. Swap SIM cards and data plans in seconds Take M6 on the go as a more powerful, secure alternati... read more
Maximum Range : 1200 Sq Ft Fast WIFI Performance: Get up to 1200 square feet wireless coverage with AC1200 speed (Dual band up to 300 plus 900 Mbps) Recommended for Up to 20 Devices; Reliably stream videos, play games, surf the internet, and connect ...
NETGEAR WiFi Router (R6230) - AC1200 Dual Band Wireless Speed (up to 1200 Mbps) | Up to 1200 sq ft Coverage & 20 Devices | 4 x 1G Ethernet and 1 x 2.0 USB ports

Now retrieving the rating.

$99.95 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Maximum Range : 1200 Sq Ft Fast WIFI Performance: Get up to 1200 square feet wireless coverage with AC1200 speed (Dual band up to 300 plus 900 Mbps) Recommended for Up to 20 Devices; Reliably stream videos, play games, surf the internet, and connect ... read more
Compatible with NETGEAR Mobile Hotspot Routers M5 (MR5200) and M6 (MR6150) Improve performance in areas with low 4G/5G signal strength Simply plug in to improve performance of your mobile broadband device when in buildings, vehicles, or remote sites ...
NETGEAR Omnidirectional MIMO Antenna (6000451) - Boosts Performance of Internal Antennas, Compatible with M5 (MR5200) & M6 (MR6150) Hotspot Routers, Includes 2 TS-9 and 2 SMA Connectors

Now retrieving the rating.

Available for Amazon Prime $59.99 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Compatible with NETGEAR Mobile Hotspot Routers M5 (MR5200) and M6 (MR6150) Improve performance in areas with low 4G/5G signal strength Simply plug in to improve performance of your mobile broadband device when in buildings, vehicles, or remote sites ... read more
Travel Router Case Fits for: Mobile hotspot storage case greatly fits for NETGEAR nighthawk M5 / M6 5G mobile hotspot with WiFi 6 (MR5200) ultrafast 5G wireless hotspot router, it also desiged for NETGEAR Nighthawk M1/ M2 Mobile Router MR5100/ MR1100...
Hard Travel Router Case for NETGEAR Nighthawk M5 M6 Pro 5G Mobile Hotspot with WiFi 6 (MR5200, MR5100)/ M1 Mobile Hotspot 4G LTE Router MR1100 (Box Only)

Now retrieving the rating.

Available for Amazon Prime 5% Off $15.80 $14.99 (as of November 20, 2024 09:18 GMT -05:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Travel Router Case Fits for: Mobile hotspot storage case greatly fits for NETGEAR nighthawk M5 / M6 5G mobile hotspot with WiFi 6 (MR5200) ultrafast 5G wireless hotspot router, it also desiged for NETGEAR Nighthawk M1/ M2 Mobile Router MR5100/ MR1100... read more