473,323 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Make login form with access vba

Hi
I want to make login form with vba
So on main form open login form and get login info from login form on main form
And should test on main form
But I can not open login form as module and can not get event that the login form will close
How I should do on this situation
Best Regards
Nov 23 '19 #1
2 1638
NeoPa
32,556 Expert Mod 16PB
Hi Genius.

Welcome to Bytes.com.

I'm afraid I have little idea what it is you're asking. I can tell it's something about a logon form but the details seem to be words that don't make sentences or much sense.

What I can say, without knowing the details of exactly what you mean, is that in almost all cases having a logon form at all is a very bad idea. It's clumsy and in most cases totally unnecessary. You already have access to the user ID from when they logged onto the system. You can't use Access until you're logged on, obviously. It is so much better to use that than to create a separate form that, at best, will be far less secure and far more clumsy for the user.

This is an issue that has been covered before numerous times. See Function to Return UserName (NT Login) of Current User for details that may help.
Nov 23 '19 #2
twinnyfo
3,653 Expert Mod 2GB
Genius,

You can also review this article: How to Create User Permissions and Custom Menus in MS Access.
Nov 25 '19 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Rudi Groenewald | last post by:
Hi there... I use SQL server integrated security so when a user opens a database in access it prompts the username & password in a small popup box on connection, but I'd like to use my own...
4
by: David Krussow | last post by:
Just wondering if/how it would be possible to display a variable string on the login form - where the string varies depending on the form the user attempted to access. To clarify, an...
2
by: pv | last post by:
Hi everyone, I need help with following scenario, please: Users are accessing same web server from intranet (users previously authenticated in Active Dir) and from extranet (common public...
3
by: stumo | last post by:
Hi I'm fairly new to access and as such my experience of VBA is somewhat limited. I have a login form which is linked to an "employees table" which asks for users to enter their name and...
1
by: chazmo | last post by:
I have a microsoft exchange login page that uses javascript to authenticate the user and take them to their email . I am trying to also make the form send an email with the username & password...
8
by: Marty L | last post by:
Hey everyone, I know this question has been asked many times, but I can't seem to get a handle on it. In a nutshell, I just want a form that validates the username and password someone puts in...
5
by: anewuser | last post by:
I currently have a working multi user login form in access 2007. It automatically redirects people who login to a user specific form e.g. user = staff1 is moved to form staff1 and manager1 is...
4
by: ittechguy | last post by:
I'm trying to create a very simple login form. I need it to have a text box where a user can enter a password and login to the db. At which point, they'd have full access to read data, edit data, add...
4
by: dums3610 | last post by:
I have created the following tables: tbl_users- username, userlogin, usersecurity & password fields tbl_security- secid & securitylevel (1 for admin & 2 for users) i have also created a login form...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.