Access 2010 Shortcuts: Create a Time Stamp With a Macro


show more Using a Before Change macro to create a time stamp provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using a Before Change macro to create a time stamp

A Before Change Data Macro allows you to perform an action upon adding, updating, or deleting a record. For example, it's a good idea to have date and time modified fields in your database, so that you know when changes were made to your significant data. For example, open up the Products table. Here is a list of all the products we sell along with their prices and costs. If we update either our retail Price or our wholesale Cost, it would be very useful to have a historic record of the last time any change was made to each product.

To do that, let's go into the Design View, and add the fields we need. I'll right-click on the Products tab, and choose Design View off the shortcut menu. We'll start by adding our date modified field. I'll type in DateModified. Tab to the Data Type, type in a D, which will auto fill Date and Time. Then I'm going to come down to the Format row down in the Field Properties, and change that to Short Date. The next field that I'll creat...

Using a Before Change macro to create a time stamp
Video duration: 6m 51s 3h 43m Intermediate

Viewers:

Using a Before Change macro to create a time stamp provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...