Hello All,
I am having the worst time trying to figure out something that is so simple - but I just cant seem to get it.
I have a function that grabs the user name; I am trying to use that value as data for some fields. I just cant figure out how to write that data into a record. This is what I have:
Thank you much,
Rick
I am having the worst time trying to figure out something that is so simple - but I just cant seem to get it.
I have a function that grabs the user name; I am trying to use that value as data for some fields. I just cant figure out how to write that data into a record. This is what I have:
Code:
Public Sub WritetblTest()
Dim RecSet As Recordset
Dim strTechName As String
strTechName = ReturnUserName()
Set RecSet = CurrentDb.OpenRecordset("tblTemp")
Do Until RecSet.EOF
RecSet.Edit
RecSet![tmpChangeType] = "Add"
RecSet![tmpChangeDate] = Date
RecSet![tmpImpactTicket] = Forms!frmNewEquip.varImpact.Value
[COLOR="Red"] RecSet![tmpTechnician] = strUsername[/COLOR]
RecSet.Update
RecSet.MoveNext
Loop
RecSet.Close
Set RecSet = Nothing
Call CreateSpreadsheet
End Sub
Thank you much,
Rick