zombiefasad.blogg.se

• #Other words for save the date update

That way, you can capture the date and time regardless of which form you use to edit the record. If you use other forms to edit records in the table, you can add the macro to each of them as well.

#Other words for save the date update

Step 3: Add the macro to a data-entry form You add the macro to the Before Update form property of the form that you use to edit records in the table. That way, you can easily reuse the macro with other tables and forms. When you write the macro, specify only the fields that will store the date and time, not the table that contains those fields. Step 2: Create a macro that records the date and time Depending on whether you want to record the date, the time, or both, the macro will have one or two actions.

If you only want to capture one or the other, you can create just the field that you require. To capture the date and the time, create one field for the date and one field for the time. The first step is to create fields in the table that has the records that you want to track. Step 1: Add fields to a table You need a place to store the date and time before you can record it. To record the date and time that the records in a table are modified, you must complete the following steps: Step 3: Add the fields and the macro to a data-entry form

Step 2: Create a macro that records the date and time Note: The procedures in this article are for use in desktop Access databases.