Asset Template in Access

[MBA]

I set everything up in the Asset Template database and at first loved it.
However, I noticed that there was a Show Retired check box and started trying
to figure out how to register an asset as retired. I could find no tutorial
or topic in Help. Since playing around with it I now get a Enter Retired Date
everytime I open the file. I finally put in an arbitrary number and when I
uncheck the Show Retired box in the Asset List Form view all my assets
disappear as though I've retired everything. However, when i go to Assets
Retired view under Queries it only show one item. How do I undo what I've
done and where is a good how to on retiring an asset in this tmeplate.

 

[Arvin Meyer [MVP]]

I set everything up in the Asset Template database and at first loved it.
However, I noticed that there was a Show Retired check box and started
trying
to figure out how to register an asset as retired. I could find no
tutorial
or topic in Help. Since playing around with it I now get a Enter Retired
Date
everytime I open the file. I finally put in an arbitrary number and when
I
uncheck the Show Retired box in the Asset List Form view all my assets
disappear as though I've retired everything. However, when i go to Assets
Retired view under Queries it only show one item. How do I undo what I've
done and where is a good how to on retiring an asset in this tmeplate.

You can undo everything by re-running a new Asset template database, then
delete all the tables and import them (along with their relation ships) from
your existing database.

 

[Rob Parker]

Which template are you referring to? I have both the Access 2003 and Access
2007 versions, from the Microsoft site, and neither of them has a Show
Retired checkbox on the Asset List form.

Rob

 

[De Jager]

I set everything up in the Asset Template database and at first loved it.
However, I noticed that there was a Show Retired check box and started
trying
to figure out how to register an asset as retired. I could find no
tutorial
or topic in Help. Since playing around with it I now get a Enter Retired
Date
everytime I open the file. I finally put in an arbitrary number and when
I
uncheck the Show Retired box in the Asset List Form view all my assets
disappear as though I've retired everything. However, when i go to Assets
Retired view under Queries it only show one item. How do I undo what I've
done and where is a good how to on retiring an asset in this tmeplate.