Stores Library

[martyparty2006]

Gday Guys



I am creating a database for our tool library that we have nicknames the 'store'

i would like to be able to sign in and out tools from this database using a form

the easy part is signing it out, the part i am having trouble with, is the form recognising the tool being signed out, so that i can sign it back in. i have set up a seperate form, with a subform showing a table that has all of the tools use on it.

the sign out form is able to save the tool number, name of person and time/date to the 'tool use' table.
the sign in form will save a new record to the 'tool use' table instead of finding the one that was signed out and signing it back in

the other thing i would like to know, is if the form is able to save the time and date to the record automatically when i click save. this would be alot easier than typing it in each time we use it


thank you for your help


MARTY

[RuralGuy]

If there is no historical reason to maintain who has used the tools then you do not need a "Tool Use" table. It can all be done in one table. Just add PersonID, DateOut, DateIn fields to the "Tools" table. Any record with DateOut > DateIn is out on loan. The DateTime can be automated in any Click event.

[martyparty2006]

we do need a history of tool use, so that we can keep track of how often they are used, where they are used and who used them.

this is usefull for tracking who uses what, the maintenance of them, and also the fact of if we need to purchase more of the tool

ultimately i would like one form where workers can select their name, job they are working on and then put in the number of the tool and press save, this will then automatically insert it into the tool use table, and insert the time and date.

i would then like a page, if not the same one, where they can put in the number of the tool and press the save button, and it will automatically return the tool, inputting the time and date


cheers guys

[RuralGuy]

Are your tools serialized or uniquely coded in some way?

[martyparty2006]

yes each one has it's own unique number

i have created an additional table with the tool list on it and then put a relationship between the two table according to the item number and this is a primary key.

i can manually insert the data into the tool use table, but i want it user friendly for the workers that are not good with computers, this is the hard part.

i can create queries off the two tables to check up on the tool's use. there is also another table with the worker's names on it, to check up on them. with a relationship back to the tool use table

[RuralGuy]

I would think you would have a form that has a query of the Workers table as the RecordSource and this MainForm has a SubForm that has "ToolsInUse" as the RecordSource with the WorkerID as the LinkChild/MasterFields properties. Then as you scroll through the Worker records you will see all of the tools they have borrowed. You can then modify the query for the SubForm to only show outstanding tools by looking for maybe incomplete CheckInDates.