?
Solved

Environ("Username")

Posted on 2006-04-10
6
Medium Priority
?
579 Views
Last Modified: 2012-06-27
Ok I have my form to get the username of someone logged into the computer and on a network but I am having a problem now setting that form to store a record on to a table.  For example, the control source of the text box on the form is =Environ("Username") and has no way to store the value onto the table.  All other fields on my form which have a control source linked to a column on my table are able to store information...please help
0
Comment
Question by:michaeljusino1017
  • 4
  • 2
6 Comments
 
LVL 19

Expert Comment

by:dmitryz6
ID: 16418958
change from control source of the text box on the form is =Environ("Username")

to default velue for textbox
=Environ("Username")
0
 
LVL 19

Expert Comment

by:dmitryz6
ID: 16418967
typo
to default value for textbox
=Environ("Username")

countrol source will be boundet to field in your table
0
 
LVL 19

Accepted Solution

by:
dmitryz6 earned 2000 total points
ID: 16418978
One more time

default value for textbox
=Environ("Username")

countrol source will be bound to field in your table
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 

Author Comment

by:michaeljusino1017
ID: 16418988
ok doesnt work, text box is still blank, should I put quotes around =Environ("Username")???
0
 

Author Comment

by:michaeljusino1017
ID: 16419014
it works now,  I needed to put a new record in the database...thanks for your help
0
 
LVL 19

Expert Comment

by:dmitryz6
ID: 16419183
You welcome
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question