CurrentDb.Execute for updating record

[megatronixs]

Hi all,

I have the below code where I want to use it to update instead of insert.
I wanted to update the record with a cancelation date where the event_id and participant_peoplesoft_id is equal in the table. How to change it so it will update? I tried to use the UPDATE instead INSERT INTO, but no luck.

CurrentDb.Execute "INSERT INTO tbl_enrolment (event_id, participant_peoplesoft_id, training_canceled_date) Values( '" & EventID & "','" & PeopleSoft & "','" & InboxItem.ReceivedTime & "')"

Greetings.

 

[stopher]

Did you try googling this? The first search returned was this one:

https://msdn.microsoft.com/en-us/library/office/ff845036.aspx

hth

 

[megatronixs]

Hi,

I did, but could not open that one becouse of my internet explorere showing me a blank page with nothing.
Will try firefox to see if I can get it visible.

Greetings.

 

[stopher]

Here's another link

http://www.w3schools.com/sql/sql_update.asp

You can also use the query builder in Access to create the SQL for you. Then copy the syntax.

 

[megatronixs]

Hi,

I made it work

Greetings.