p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   user log details... (http://p2p.wrox.com/showthread.php?t=50802)

mmcdonal November 28th, 2006 01:51 PM

That depends. What kind of database, and how are you accessing it?

Basically, open a connection on the SQL database, then open a recordset on the transaction table, declare enough variables to hold all the information you want to pass, then get the info, mostly like this:

Dim sOldFName, sNewFName As String

sOldFName = Me.FName.OldValue
sNewFName = Me.FName.Value

etc.

Then pass the values to the recordset using AddNew and Update.

Exact code depends on ADO v. DAO, and how you are referencing the database, either ODBC or Provider.

HTH



mmcdonal


All times are GMT -4. The time now is 08:25 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.