Audit Trail
2193 Downloads
By Candace Trip (utter:angel) - Access 2000 format
This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.
| Category: | Example Forms |
| File Size: | 32.22 KB |
| File Type: | application/zip |
| Hits: | 34728 Hits |
| Download: | 2193 times |
| Created Date: | 03-12-2016 |
| Last Updated Date: | 03-12-2016 |
Related documents
This example shows how to use tables to store the all the parts of a document. An exmaple web be for creating contracts.
This example also shows how to use cascading sub forms. This is where two sub forms on hte parent for are linked. The first sub form shows records related to the Parent form's current record.. The second sub fom (on the parent form) shows related records to the current record in the other sub form.
This is a basic example of how to store the path to a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink method.
This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.
This demonstration database shows various methods of using the Flex Grid
ActiveX control in an Access 2000 (or later) database. Flex Grid controls can be
used to show data from a table or query on a form in a format which is not possible
using standard Access controls.
Here is an example of how to make a combo box display text like "Find a Customer" and then when you click the drop down arrow, the text goes away. This is similar to what you see on web pages.
The attached is in 2000 format.