Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2005

Tip: Looking for answers? Try searching our database.

update of field or control

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Squibbly - 04 Jan 2005 21:54 GMT
i have a macro that when you update any of the fields/control it then puts
the date and time when last updated. does anyone know how to tell which
field/control has been updated?
rolaaus - 05 Jan 2005 07:53 GMT
I wouldn't know how to do this in a macro - short of creating a macro for
each control in the form - I don't deal with macro's too much since
everything a macro can do, can be done using VBA and it's performed much
quicker in VBA.  

If I were wanting to track each and every field that were changed - and only
those fields, then I would set up global variables in the form's VBA module,
and declare them as boolean (or integar, since true = 1 and false = 0
anyways), and in each form controls 'on change' event, set the variable to
true.  Then when the record is saved (before update or after, I don't think
it matters in this case) you can run through the variables you declared and
append all the true ones to your tracking table.

> i have a macro that when you update any of the fields/control it then puts
> the date and time when last updated. does anyone know how to tell which
> field/control has been updated?
Squibbly - 12 Jan 2005 19:53 GMT
thank you for your advice i will try and do this using vba

>I wouldn't know how to do this in a macro - short of creating a macro for
> each control in the form - I don't deal with macro's too much since
[quoted text clipped - 17 lines]
>> the date and time when last updated. does anyone know how to tell which
>> field/control has been updated?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.