Re: Password Login - Auto Populate Fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Richard

You should be using the DefaultValue property of those textboxes to provide
a default value for new records.

For the date/time field, just set the DefaultValue of the textbox to:
=Now()

For the username field, I suggest you use a global variable and a function
to return it. Put the following in a standard module:

Public gsCurrentUser as String

Public Function GetCurrentUser() as String
GetCurrentUser = gsCurrentUser
End Function

Now, change your login form which asks for the username and password so that
it stores the validated username in your public variable:
gsCurrentUser = Me!txtUserName

And, getting back to your data entry form, set the DefaultValue us the
username textbox to:
=GetCurrentUser()

You could also get clever and modify your GetCurrentUser function to check
if gsCurrentUser is an empty string and, if so, open up your login form to
ask for the username and password.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand


"Richard Perry via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
message news:506E534285060@xxxxxxxxxxxxxxxxxxxx
> Hi
>
> I have a table of Users (5 users only) with passwords that I have given
> them
> to log in to Access. This is not high security, just data entry. They
> want
> to keep track of how many entries a user made during a day, week, month.
>
> When the user type their password to the data entry form, their name, date
> and time to auto populate the fields, which are protected and cannot be
> changed.
>
> My problem is that it works for the first record only. When they click on
> "add a new record", the next data entry record does not have their name
> and
> date stamp.
>
> --
> Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: Send Email Using VB 2008 Express
    ... Create a To TextBox, and name it 'txtTo' ... Private _Username As String ... Public Property UserName() As String ... Private Sub btnSend_Click(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.languages.vb)
  • Session Not Maintaing State
    ... A ASPX Form has a TextBox & a Button. ... Users enter their username in ... The DataGrid also provides pagination. ... Dim strUserName As String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Default Values for Control Properties
    ... then that's telling you the DefaultValue attribute has been appliied to the Width proeprty and the default value is "". ... When I drop a TextBox on a web form it has some default ... objectattrs = ...
    (microsoft.public.dotnet.framework.aspnet.buildingcontrols)
  • Re: Session Not Maintaing State
    ... The DataGrid also provides pagination. ... Dim strUserName As String ... Assume that I enter the username Ronnie in the TextBox & submit the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: change password in active directory by webapplication (vb.net)
    ... I have a form which has three textbox, to get user information. ... textbox is username, second one is user_old_password and third one is ...
    (microsoft.public.dotnet.framework.aspnet.security)