bonekrusher
Registered User.
- Local time
- Today, 07:27
- Joined
- Nov 19, 2005
- Messages
- 266
Hi All
In reference to my last post: http://www.access-programmers.co.uk/forums/showthread.php?t=102106
In my code below I get the users info from "username = Environ$("username")". My question is, can I use that value in my sql statement? I keep getting an error "No Value Given for one or more required parameters."
If I replace username with 'jdoe' it works fine. What am I missing?
In reference to my last post: http://www.access-programmers.co.uk/forums/showthread.php?t=102106
In my code below I get the users info from "username = Environ$("username")". My question is, can I use that value in my sql statement? I keep getting an error "No Value Given for one or more required parameters."
If I replace username with 'jdoe' it works fine. What am I missing?
Code:
Dim myconnection As ADODB.Connection
Dim myrecordset As New ADODB.Recordset
Set myconnection = CurrentProject.Connection
Dim username As String
Dim answer As String
username = Environ$("username")
myrecordset.ActiveConnection = myconnection
myrecordset.Open "SELECT Table1.Name, Table1.eMAIL FROM Table1 WHERE (([Table1]![Name]=username))"
answer = myrecordset("email")
Me.Text1 = answer
Last edited: