You already have code. You posted it.
searchstring = "SELECT Name, username,password,information FROM tblMsrTotals WHERE [Name] = '" & TextBox0.Value & "'"
rs.Open searchstring, cn1, adOpenStatic
Need help to save record from excel vba userform to Access database
VIP
Windows 7 64bit 
Access 2010 32bit
You already have code. You posted it.
searchstring = "SELECT Name, username,password,information FROM tblMsrTotals WHERE [Name] = '" & TextBox0.Value & "'"
rs.Open searchstring, cn1, adOpenStatic
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 8 Access 2010 32bit
this code is not working
always gives first record from access table
VIP
Windows 7 64bit Access 2010 32bit
Then I suppose the value of TextBox0 is always the same name. Why is that?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote