Web Development



How to, automatically, create a new record in Access with correct dates

By Michel Zimacon ·
I have a lot of experience with access but not with coding since I don't like coding. Coding often means losing flexibility and increasing maintenance.

However there is one issue that keeps nagging me since it probably cannot be done without coding. And I do not know how to code this.

In my databases I always use tables with four datestamp fields, (physical) create date, active date (which maybe earlier or later than create date), date inactive (logical inactive date), delete date (physical inactive date).

This enables me to ask queries on a logical time horizon and a physical time horizon.

Let's assume that I have a table with GL accounts and a table with GL accountnumbers. The GL accountnumbers may vary in time since their dates vary.

I'm looking for a way to change a specific record in the GL accountnumbers table, by changing the accountnumber.
The procedure/form or other code should take the new accountnumber and put it in a new record, set the delete date of the changed record to today, the create date of the new record to today, set the logical inactive date of the old record to the same date as the new accountnumber logical active date.

I would appreciate anyone's comments.

Best regards,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

your request is not clear to me

by john.a.wills In reply to How to, automatically, cr ...

Do you want to change the GL account numbers table or only the GL accounts table? What is to happen, if you do not want to change the GL accounts table, to the records in it with the to be altered account number?

Otherwise, what you want is a button and two account-number controls. Or do you really want a display of the account-number row and just one account-number control, to show the new one? When you have decided on your button and what it is to do we can talk about what VBA should lie behind the button.

Related Discussions

Related Forums