Trevor
04-11-2008, 09:57 PM
ahhh. queries can be so frustrating, I have a query that should update the date in the table to the current date
where the username in the table = the ID of the account loged in , and when I run it I don't even get warning "updating x records":
DoCmd.RunSQL "UPDATE IndividualSettingsTbl SET IndividualSettingsTbl.Date = '" & stDate & "' " & _
"Where IndividualSettingsTbl.UserName = '" & AccountName & "';"
stDate is declared as a date that is = Date , I tried useing Date(), Date instead of a variable
I have also tried Date = #" & Date & " #; ' with out luck think access just wanted to be picking but didn't work
where the username in the table = the ID of the account loged in , and when I run it I don't even get warning "updating x records":
DoCmd.RunSQL "UPDATE IndividualSettingsTbl SET IndividualSettingsTbl.Date = '" & stDate & "' " & _
"Where IndividualSettingsTbl.UserName = '" & AccountName & "';"
stDate is declared as a date that is = Date , I tried useing Date(), Date instead of a variable
I have also tried Date = #" & Date & " #; ' with out luck think access just wanted to be picking but didn't work