We want to create a database that once a year will have the contents of specific fields deleted. This is for our tax department. They want to retain the informational fields but on a yearly basis clear the numeric fields. Any thoughts on how we can accomplish this in an Approach Database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting specific field content 1
- Thread starter misslil
- Start date
-
1
- #2
Thomasdelta
Programmer
Not sure if I completely underestimated the problem here, but have you tried creating a macro that finds all records between the specified dates and then runs another macro which starts at the first record, and then sets all the required fields to '' (blank).
(you will have to use the Set command once for each field required).
Sorry if this post is too late!!
I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.
(you will have to use the Set command once for each field required).
Sorry if this post is too late!!
I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.
- Thread starter
- #3
- Status
Similar threads