Access Lost and Found Template

[seedyburner]

Does anyone have any idea where I can get a Lost and Found Template? I work in a hotel and we have a large volume of lost and found items and I want to make it easy to log and search these items. Thank you.

[nico5038]

Haven't seen such an application yet, but it's very easy to create as it will hold just two rather similar tables.

Just define the reports / forms you need to have for performing your task. Like:
Lost Items Report with the fields:
- Owner
- InformWhenFound
- ObjectLost
- DateLost
- LocationLost
- Further details
- AcceptedBy
- DateFound
Found Items Report with the fields:
- FoundBy
- ObjectFound
- DateFound
- LocationFind
- Further details
- AcceptedBy
- OwnerFoundOn
- OwnerFoundAddress

Just some things I can imagine, but probably you already have some recording you can use as input for the needed fields.

Having the tables you can use them "straight away" and this description op the right-click popup can help to search the items of interest:
http://www.geocities.com/nico5038/xR...nstruction.zip

Getting the idea ?

Nic;o)

[Scott Price]

A good place to start: http://office.microsoft.com/en-us/te...172481033.aspx

Choose your version of Access and browse through their free templates.

Good luck, and welcome to the Scripts!

Regards,
Scott

[seedyburner]

Unfortunately, I have looked on the Office website and haven't found anything that would work. The other thing is I could definately build a database that I could use that would suit me just fine, however, there are going to be several users and I need to make it as easy as possible. I was thinking of the possibly using Access along with Info Path. I have also considered making the interface web based.

[nico5038]

When you consider a web-based solution, then it's better to "drop" Access and to switch to e.g. PHP and the free MySQL database. These are widely supported by ISP's.
The tabledesign will however still be necessary :-)

Nic;o)