CurrentDb.Execute for updating record (1 Viewer)

M

megatronixs

Registered User.

Local time

Today, 13:45

Joined

Aug 17, 2012

Messages

719

• Jan 4, 2017

• #1

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.

Code:Copy to clipboard

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

Greetings.

 

stopher

AWF VIP

Local time

Today, 12:45

Joined

Feb 1, 2006

Messages

2,395

• Jan 4, 2017

• #2

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

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

hth

 

M

megatronixs

Registered User.

Local time

Today, 13:45

Joined

Aug 17, 2012

Messages

719

• Jan 4, 2017

• #3

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

AWF VIP

Local time

Today, 12:45

Joined

Feb 1, 2006

Messages

2,395

• Jan 4, 2017

• #4

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.

 

M

megatronixs

Registered User.

Local time

Today, 13:45

Joined

Aug 17, 2012

Messages

719

• Feb 9, 2017

• #5

Hi,

I made it work

Greetings.