Forms :: Change Value In Textbox - Capture User Login

Apr 12, 2014

I would like to put a text box (user) and checkbox (check100) on a form, that when the checkbox is not checked the value in Gender switches. In an AfterUpdate I would use a code to capture the user login.

Code:
Private Sub Check100_AfterUpdate()
Me.User = Environ("UserName")
If Me.check100 = 0 AND Me.Gender.Value = "Male" THEN
Me.Gender.Value = "Female"
ElseIf Me.check100 = 0 AND Me.Gender.Value = "Female" Then
Me.Gender.Value = "male"
End If
End Sub

View Replies


ADVERTISEMENT

Forms :: Change Textbox Color On Form In Access 2013 For Dyslexic User

Apr 29, 2014

I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.

Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).

View 4 Replies View Related

Modules & VBA :: Create A Login Form That Allows User To Change Temporary Password

Feb 25, 2014

I have been trying to create a login form that allows the user to change his/her temporary password logging it to the proper table along with timestamp and who done it info.But, after spending the morning trying to find the proper syntax I am flummoxed.

I can get everything to work accept the update of the fields. I can get the command to work (writes to the location) but it does the pop-up what is the parameter thing when it works. I have all the information just need to get it in so the command recognizes it.

DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE lut_TeamList SET Pass = txt_Password.value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedBy = Me.cbo_UserName.Value WHERE TeamListID = Me.cbo_UserName.Value"
DoCmd.RunSQL "UPDATE lut_TeamList SET UpdatedWhen = Now() WHERE TeamListID = Me.cbo_UserName.Value
DoCmd.SetWarnings True

View 5 Replies View Related

Forms :: How To Capture Windows Log On Information Of A User Using Database

Apr 8, 2014

I have several data entry forms in my DB. What I would like to do is capture the windows user name of the people adding records and changing records. How do I go about doing that? I was think of an on change event to a given field that would then pull the username and insert it in another field/object.

Lets say the an on change of me.cmbModel update txtUserName.

View 5 Replies View Related

Forms :: Login Form - How To Set Value For Textbox

Mar 18, 2014

i have a login form in access , i want to set the value for the textbox , for example i want to set "Username" appear in the textbox when in click in the textbox clear the textbox like the title in the web it is possible !!

View 4 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Login Forms, With User Name And Password

Oct 18, 2005

I have created a login form, with a user name and password. It works great. However I need to use the login form for three different command buttons, on my main access form. The same login form will be used but It will need to open three different forms depending on what command button was selected on the main page.

Main page- PID
3 command buttons- building, documents, assessments
login form- login
3 documents- build, docs,assess

I open main page, PID- click on buildings the login form pops up and I enter the correct username and password the building doc opens. Got it?? The same process for each, I would like to know how is this possible? How do I change the differnt documet that opends according to the command button that has been pushed? :confused: Thanks in advance

View 10 Replies View Related

Forms :: Last Login Time Stamp For Each User Logged In

Mar 19, 2014

Was trying to set the value of text to current date and time when a submit button is clicked. I've managed to set

Control Name:- txtLastLogin
Property:- Value
Value:- now()

The above expression works but the last logged data in tblEmployee gets replaced as another user logs in.

How can i add a time stamp to each user loged in.

View 2 Replies View Related

Forms :: Multi-User Login Form With Macro

Nov 4, 2013

I've managed to create a multi-user login form with macro.

user1 is able to login with his password and user2 is able to login with his password. latter I noticed that user1 is able to login with any password in the table and use his previous password to login even after changing it.

View 14 Replies View Related

Forms :: User Login Form On Opening Of Database

Feb 17, 2015

I need to know the procedure or event code for user login form at opening.

I am working on database which is almost done and i defined tables for users with passwords.

I need to know how i can assign Login Form to be appear on opening of database no other person than listed users should be able to enter or open database without password, to enforce this i made a login form.

View 5 Replies View Related

Forms :: How To Use Form To Manage Multi-user Login

May 8, 2013

I am working on a db for a restaurant expense account. I am trying to design a multi-user login form to allow administrator and other users to log in the data entry form. I am a newbie to MS Access.

View 3 Replies View Related

Forms :: Create A Counter To Log How Many Times A User Login To Database

May 22, 2013

I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.

Is there a way I can add a counter to see how many times a particular user has logged onto the database?

Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.

View 2 Replies View Related

Forms :: Network User Login With Privileges And Audit Trail

Dec 19, 2013

I am in the process of creating a database with multiple tables. Multiple users access through network with access data back end on server and Different Forms with user and group access of MS Access. The file is in mdb format and current version of MS Access used by all my users is Access 2007.

Requirements :

1. User Login (Access user login preferred as, one can set permission for read only, write permission for specific field etc.) But whether if any user who has readonly rights create his own db, wont be able to edit their own because of the rights that i have set rights in their pc??

2. need to fetch this user id with time stamp in each table to find who has altered the data, though audit trail table with ip address will be ideal.

3. Hide the navigation pane and ribbon for anyone other than administrator, including office button.

4. User level security is it required to set in every pc where the front end sits or one pc where the data is located.

View 5 Replies View Related

Forms :: Coding User Login Form In ACCESS 2010

Apr 14, 2013

I have used Combo box. security_level field is the one that describes their levels and there are only two levels 1 and 2.. I have a table called User (user_ ID, User_Name, Password, Security_Level) On form there is a combo box for user name and text box for password. Two command button where one is for EXIT (Closing the application) and the second button is to run the code.

if the password in table User matches value chosen in combo box or user name and password are correct Then it should check if Security_Level of the user is equal to 1 to displays a form called Admin and when the Security_Level of the user is equal to 2 to display a form called user1.All that I want is to have a login that has two user and each user when login opens his/her own form which is different from the other user.

View 14 Replies View Related

User Login And Have Their INITIALS Auto-Filled When Filling Out Forms

Apr 17, 2013

I have a database where multiple users log in and work in 1 of 2 different forms. The 1st form in for initial data entry where users enter data then senter there initials and save each record. the other form is for QC'ing data that has been entered and they will add additional data to the form, then enter their initials and save the record.

How can I make it so that I can have a user once they log in to the database, it will autofill their initials? I have used a dropdown box before but it is not useful for people who have the same first name initial or worst, the same first and second initial because they end up selecting the wrong initials.

I do not currently have it set up where I have a login screen, I just have only forms visible to users when they enter data. Any easiest way to go about making this happen (I am just trying to shorten the amount of data entry that gets done).

View 9 Replies View Related

Reports :: Capture Value Via Textbox Or Any Source For New Blank Report

Jul 7, 2013

I have a report in access 2007, now i need to ask that i am creating new blank report and just like to to capture value from other report via textbox or any source (you may reccommend), for e.g in Report A i have months and their total amounts now i want to add both these fields in new Report B where i will do the same with other previous reports to create summary of accounts.

View 1 Replies View Related

How Do I Capture User Info In A Form

Jan 22, 2006

:) Hi Guys,
I have a small problem, hope you can help me out. I have created a a form in Access for data entry. But I would like the form to capture the data and time and the user who's entering the data into the form.
How do I do that. Been trying to figure it out:rolleyes: . Hope you can help. Attached is the screenshot of the form I created. Thanks a bunch

http://img21.imageshack.us/img21/5612/screenshot4ic.th.jpg (http://img21.imageshack.us/my.php?image=screenshot4ic.jpg)

http://img21.imageshack.us/my.php?image=screenshot4ic.jpg

View 3 Replies View Related

Forms :: Populate Textbox Based On User Log In

Mar 3, 2014

Code:
Private Sub Check253_AfterUpdate()
If Me.Check253 = -1 Then
Me.Text254 = DLookup("[Lot]", "[tblAutoGen]", "[Inuse] = -1")
Me.Text256 = DLookup("[Exp]", "[tblAutoGen]", "[Inuse] = -1")
Me.Text258 = DLookup("[Lot]", "[tblEthanol]", "[Inuse] = -1")

[Code] ....

I am using the code above on my form and it seems to be working. My question is there a way to populate a textbox (Text255) based off a login?

For example, lets say JSmith is loged in to the computer. Is there a way that JS could populate Text255? If then say JCarter is logged on, the JC populates Text255.

View 1 Replies View Related

Forms :: Textbox That Get Value Both From Calculations And User Input?

Nov 7, 2014

I have a form bound to a table, with a subform in there, and I have a textbox with a source one of the table's fields. I would like the value of this textbox to be calculated based on the values of some boxes in the subform, but I also wont to be able to edit the value on the textbox myself.

Is it possible to have a textbox that get its value both from calucaltions and user input?

View 1 Replies View Related

Forms :: Textbox For Order ID Input By User

Jun 21, 2013

My table have orderid along with other columns, i want to create a form where i am having a textbox for order id input by user. Firstly when user sees the form its only with the textbox and table fields, when i put the order id in the textbox the listing should be made.

View 1 Replies View Related

Forms :: Using Textbox To Change Position And Length In Mid Function

Aug 6, 2015

I have a .csv file where I need to parse out the information.

I have imported the .csv file into access and all the data is in [Field1]

Instead of using query design, I want to create a user interface [Form] where anyone can input in the textbox the position and length of a mid function.

Example:

Last name: Position = 1 Length =15
First Name: Position = 15 Length = 30

Is it possible for users to input the numbers in texboxes to extract the data to another table?

View 6 Replies View Related

Forms :: Change Event - Cannot Access New Contents Of Textbox

Oct 2, 2013

I am developing a form whereby the user types a single character or a sequence of characters into textbox and a query WHERE clause is compiled upon each character being entered.

The query is the Row Source of a listbox which I requery upon each change in the text box contents.

In the Change event I cannot access the new contents of the textbox until focus moves to another control and then back to the textbox. This is not how I expect this event to work.

View 3 Replies View Related

Forms :: Textbox Background Color Change Dependent On Value

Oct 3, 2013

I have a question related to a textbox on a form.

In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10.

On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating).

What I would like to know how to do is:

If the value in the textbox is 0-5 leave the background colour of the textbox white with black font.
If the value in the textbox is 6-7 turn the background colour pale yellow with black font.
If the value in the textbox is greater than 7.1 turn the background colour Red with white font.

View 3 Replies View Related

Forms :: Default In Textbox - User Should Only Enter Numbers

Nov 13, 2013

I have a text box in Form which i need user should only enter the numbers:

E.g.: When new form appears SI [space]#### should be there and even user needs he or she can change SI to PI and enter the required data.

And the data should go as SI #### or PI #### in Table Backend. The Textbox is Unbound.

View 2 Replies View Related

Forms :: Textbox Refresh - Getting Default Value To Reappear When Change Criteria

Jun 4, 2014

I am using a DLookup to default a value in my TextBox. This text box has an event attached to it that updates a table when a different value is entered.

I am having difficulty in getting the default value to reappear when I change my criteria.

For instance Manufacturer is Ford

Colour is default Black

I Change the colour to red

now I change Manufacturer to Audi

I need Default colour to go back to Black

The Lookup Table says Black its just that the default value only seems to run once, first time in and never again unless i exit the database and reopen it.

I have tried adding

Form.Repaint
form.Refresh
Form.Requery
to my afterupdate query

View 3 Replies View Related

Forms :: Login Form On Opening Access Asking For Password And Login Name

Jun 17, 2013

I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.

Is this even possible to accomplish?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved