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
SAMSUNG 34" Odyssey G85SD Series QD-OLED Ultra WQHD Curved Gaming Monitor, 175Hz, 0.03ms, DisplayHDR True Black 400, AMD FreeSync Premium Pro, Advanced Game Streaming, LS34DG856SNXZA, 2024
33% OffOLED & NEO QUANTUM PROCESSOR: With the advanced Neo Quantum Processor, every frame on the OLED panel is instantly analyzed and optimized for maximum quality; Colors, shades and contrast unify to deliver a bright and brilliant picture at all times Dis... read more
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
23% Offă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
SAMSUNG 34" Odyssey G85SD Series QD-OLED Ultra WQHD Curved Gaming Monitor, 175Hz, 0.03ms, DisplayHDR True Black 400, AMD FreeSync Premium Pro, Advanced Game Streaming, LS34DG856SNXZA, 2024
33% OffOLED & NEO QUANTUM PROCESSOR: With the advanced Neo Quantum Processor, every frame on the OLED panel is instantly analyzed and optimized for maximum quality; Colors, shades and contrast unify to deliver a bright and brilliant picture at all times Dis... read more
Artciety Foldable Bluetooth Keyboard, Wireless Portable Keyboard with Larger Touchpad, Pocket-Sized Folding Travel Keyboard for MacOS Android Windows iOS, Sync Up to 3 Devices (BT5.1 x 3)
$40.99 (as of December 21, 2024 02:47 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.)â¤â¤ăSync up to 3 Devices & Seamless SwitchăWith super-fast Bluetooth 5.1 Technology, Artciety Folding Wireless Keyboard supports up to 3 devices simultaneously. No signal delay or lag up to 33 feet. Ensures a stable and reliable connection. Our small ... 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
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)
8% OffUltimate 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
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
29% OffMaximum 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
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
$59.99 (as of December 21, 2024 06:48 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
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)
5% OffTravel 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
Hard Case Compatible with NETGEAR Nighthawk M6 Pro MR6500/ M6/ M5 / M1 MR1100 5G LTE WiFi Mobile Hotspot, Travel Router Storage Bag with Mesh Pocket for Charger and Other Accessories(Box Only)-Black
$12.99 (as of December 21, 2024 06:48 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.)Perfect for Netgear Nighthawk Storage Case: Hotspot wifi devices portable 5g holder is exclusively designed for NETGEAR Nighthawk M5 M1 M6 Mobile Hotspot Router (MR5200, MR1100, MR6500). Compact hotspot device box with enough space can hold for NETGE... read more