Updating records in an Access DB
 

Hi,

Please help me with code that updates an existing record in database

Thanks

Luis

Updating records in an Access DB
 

http://www.erlandsendata.no/english/...php?t=envbadac


"Lucho" wrote:

Hi,

Please help me with code that updates an existing record in database

Thanks

Luis

Updating records in an Access DB
 

Thank you for your suggestion. In that website I found code to add new
records. How can I modify to update existing records?

Regards,

Luis


"Vacation's Over" escribió en el
mensaje ...
http://www.erlandsendata.no/english/...php?t=envbadac


"Lucho" wrote:

Hi,

Please help me with code that updates an existing record in database

Thanks

Luis

Updating records in an Access DB
 

don't remember where I cut this but it comes in handy:

' Interesting update with replace code
'UPDATE Master RIGHT JOIN [Transaction] ON Master.[Trans ID] =
'Transaction.[Trans ID] SET Master.[Trans ID] = [Transaction].[Trans ID],
'Master.Name = [Transaction].[Name], Master.DOB = [Transaction].[DOB];

"Lucho" wrote:

Hi,

Please help me with code that updates an existing record in database

Thanks

Luis