ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating records in an Access DB (https://www.excelbanter.com/excel-programming/340491-updating-records-access-db.html)

Lucho

Updating records in an Access DB
 
Hi,

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

Thanks

Luis

Vacation's Over

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


L. A. M.

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




Vacation's Over

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



All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com