Closed Records - Archive or Label as closed?

[Darkwater]

Evening All! (Old enough to remember Dixon of Dock Green (stupid enough to mention it!))

I'm working on a small database for a small team of support workers with a
client base of 60 clients at anyone time, although the turnover is quite
substantial.

I have done some searches on archiving records but am concerned that once
archived a record would be difficult to re-integrate in to the live database,
particularly if there have been changes to it?

I have considered that I may be just as well slapping a big label over every
record that has a date in the [CloseDate] field and if a closed case is
re-opened, the closed date is removed and the label disappears.

I'm still open to being convinced that the archiving is the way to go, but
in the mean time I hope someone will be able to help with the expression
needed in the form on_current procedure to make the label visible. If it was
just a tick box I'd be flying by now, but I can't get my head around getting
a populated [CloseDate] field to initiate the CloseRecordLabel.

Thanks in advance
Doug

 

[RuralGuy]

How about:
Me.YourLabel.Visible = IsDate([YourField])
...in the Current event of the form?

 

[pbaldy]

I won't be the one to try and convince you to archive. I wouldn't do it unless there was a huge number of records. Rather than making labels visible, I would consider restricting records in the query feeding reports, like:

WHERE CloseDate Is Not Null

 

[Darkwater]

Thanks Very Much

How about:
Me.YourLabel.Visible = IsDate([YourField])
...in the Current event of the form?

RuralGuy,

Thank you again for your help. This works brilliantly and saved me yet more days of trying to figure it out.

As an aside; I have asked a question or two in the Microsoft Community and have had responses, and a great deal of help from someone with your name, is it you? Also, if it is you is it considered bad form to post the same question in two different forums. If so, I'll just stick with this place.

Thanks again.

Doug

 

[Darkwater]

I won't be the one to try and convince you to archive. I wouldn't do it unless there was a huge number of records. Rather than making labels visible, I would consider restricting records in the query feeding reports, like:

WHERE CloseDate Is Not Null

Paul,

Thanks for this advice; it isn't something I had even considered. I'd still like to stick with the labels to give a clear indication that the record is well and truely closed but I'd like to take your advice also! I take it there shouldn't be any conflicts with the two being done?

You guys are brilliant!

Doug

 

[pbaldy]

Well, there won't be any conflict, but if you eliminate them in the query there won't be anything left for the code to hide, so basically you'd do one or the other. You could certainly use one technique on some forms/reports and the other on others, depending on how you wanted to present it to the users.

 

[Darkwater]

Well, there won't be any conflict, but if you eliminate them in the query there won't be anything left for the code to hide, so basically you'd do one or the other. You could certainly use one technique on some forms/reports and the other on others, depending on how you wanted to present it to the users.

Noted Paul, and thanks.

Doug

 

[RuralGuy]

As an aside; I have asked a question or two in the Microsoft Community and have had responses, and a great deal of help from someone with your name, is it you? Also, if it is you is it considered bad form to post the same question in two different forums.

Hi Doug,
I belong to several forums and I'm certain I've helped you in some of the others. As far as I know I'm the only RuralGuy posting and the handle was available in all of the forums I joined so that is *all* I use.
As for posting the same issue in different forums, there is nothing wrong with that as long as it is a completely different forum. Posting an issue on this forum in the tables area and the same issue in the query area is discouraged.

 

[Darkwater]

Hi Doug,
I belong to several forums and I'm certain I've helped you in some of the others. As far as I know I'm the only RuralGuy posting and the handle was available in all of the forums I joined so that is *all* I use.
As for posting the same issue in different forums, there is nothing wrong with that as long as it is a completely different forum. Posting an issue on this forum in the tables area and the same issue in the query area is discouraged.

Thanks for clearing that up for me RuralGuy, and again thanks for all your help.

Regards
Doug

 

[rborob]

i put table fields in all my tables to keep track of things,,these include

UserCreated
DateCreated
UserUpdated
DateUpdated
UserArchived
Date Archived

If i want to archive somehting i just put a date in the Date Archived field. then in list boxes, subforms etc i just do as pbaldy says and use Is Null as the criteria for the DateArchived field. that way only items which havent been archived are shown.. If you wish to unarchive somehting then simply remove the date.