CODEWITHSUNDEEP
vbams-accesstime
Prush
Prush

Reputation: 517

Put time in Date/Time fireld

I am trying to update logout date of particular user but it shows error like.

Error:

No Value Given For One Or More Required Parameters.

I am using below code.

Source = "UPDATE timetbl Set logouttime = tmp where empname = 'Prashant'"
.Open Source:=Source, ActiveConnection:=Connection
MsgBox "success"

explaination: tmp (variable) has a current IST Time i.e 10:5:19 PM (without single quote), it update in logouttime field (date/time) when empname is Prashant.

Note: It works when I manually put tmp value i.e '10:5:19 PM' but it doesn't work without quote.

Please suggest on this.

Upvotes: 0

Views: 23

Answers (1)

Doug Coats
Doug Coats

Reputation: 7107

      Source = "UPDATE timetbl Set logouttime =#" & tmp & "# where empname = 'Prashant'"
     .Open Source:=Source, ActiveConnection:=Connection
      MsgBox "success"

You have to use variables like this. And dates need # on both sides for access sql

Upvotes: 1

Related Questions