rupes_mahal
Registered User.
- Local time
- Today, 10:54
- Joined
- Aug 12, 2001
- Messages
- 60
Hi
I have setup a table and a form which consists of details of users. Each record has a date assigned to it. Each record is updated after 3 years and a new date is assigned to it.
I want to setup a command button, which will by a click bring back the records that need to be reviewed.
For example:
todays date is 28.08.01
So if i clicked on the command button today, it will bring back all the records dated 3 years old from today (records dated 28.08.98 should be retrieved).
i need to know how to do this please.
The user will have 2 choices on retrieving back the data, such as:
DataSheet View or Form View
How do i setup up the 2 command buttons(datasheet view & Form view buttons) to retrieve back data 3years old from todays date or tommrrows date and so on. it basically retrieves back records 3 years old from the present date.
Thank you in advance
Ruby
I have setup a table and a form which consists of details of users. Each record has a date assigned to it. Each record is updated after 3 years and a new date is assigned to it.
I want to setup a command button, which will by a click bring back the records that need to be reviewed.
For example:
todays date is 28.08.01
So if i clicked on the command button today, it will bring back all the records dated 3 years old from today (records dated 28.08.98 should be retrieved).
i need to know how to do this please.
The user will have 2 choices on retrieving back the data, such as:
DataSheet View or Form View
How do i setup up the 2 command buttons(datasheet view & Form view buttons) to retrieve back data 3years old from todays date or tommrrows date and so on. it basically retrieves back records 3 years old from the present date.
Thank you in advance
Ruby
