mamradzelvy
Member
- Local time
- Today, 05:45
- Joined
- Apr 14, 2020
- Messages
- 145
Hello,
I Pretty much need to do exactly what's in the title.
I've got a "BElogon" table where i save all my User Information, there's one row for a full name which i would like to save now into a record from an unbound form where i use a simple query like this to populate the records columns:
Now as you can see, i use TempVars to store the currently logged in user's name, so my question is:
A) Would i be able to to save a TempVars which i would pull out of the logon table on the login screen and save 2 TempVars values?
B) Is the query approach easier and or even possible?
This is the code i use to save my TempVars on Login.
I Pretty much need to do exactly what's in the title.
I've got a "BElogon" table where i save all my User Information, there's one row for a full name which i would like to save now into a record from an unbound form where i use a simple query like this to populate the records columns:
SQL:
INSERT INTO dbCash (CashKlient, CashInfo , CashDate1, CashHours, CashPrice, CashUser) VALUES ('" & Me!txtKlient.Value & "','" & Me!txtInfo.Value & "','" & Me!txtDate1.Value & "','" & Me!txtHours.Value & "', '" & Me!txtPrice.Value & "', '" & TempVars("UserName").Value & "');
Now as you can see, i use TempVars to store the currently logged in user's name, so my question is:
A) Would i be able to to save a TempVars which i would pull out of the logon table on the login screen and save 2 TempVars values?
B) Is the query approach easier and or even possible?
C#:
TempVars("UserName").Value = Me.txtboxname.Value