Checkin/Checkout System in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a database to be used to record checkout and checkin of
various items by a group of members. I would also like to be able to keep a
checkout history of items. Does anyone have any ideas or samples I could use?
 
I solved this with a new table with this fields
Id/User/Pwd/Date/Time/Control (with true for checkin and false to
choeckout).
There are many functions to control each user when connect, so the best
solution is introduce in the main application a control to write the checkin
and checkout

--
Saludos desde Oviedo (Asturias)

Juan Menéndez
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)

Si la información recibido te ha servido indicalo con otro post.
En caso de resolverlo por otros medios, indica la solución usada
ayudaras a otros y aprenderemos todos.
 
Thanks for your response. I've looked through those templates, but none seem
to do exactly what I'm looking for. Do you know of any other resources
 
Dear Kiddjt:

Are you talking about something like a circulation system for books (as in a
library?). You could create a transaction table to manage the circulation of
materials. You might, for example, have three tables set up as illustrated
below. To track circulation, you create a new record in tblCirculation. It
would list the book taken out, the patron taking the book out, and the
date/time the book was taken out. When the book is returned, you record the
date/time in the TimeIn field for that particular book. This provides you
with a complete record of all circulation, and will allow you to create
reports on patron circulation, book circulation, overdues, etc.

You might be interested in a free small library application which I have
created and which you can download from www3.sympatico.ca/lornarourke. There
are many shareware/low cost/free library programs available that you could
find with a quick Google search...

HTH
Fred Boer

tblLibrary

BookID
Book title
Book format
Dewey Decimal number
Etc.

tblPatrons

PatronID
PatronFirstName
PatronLastName
PatronPhoneNumber
Etc.

tblCirculation
BookPatronID
PatronID
BookID
TimeOut
TimeIn


kiddjt said:
I'm trying to create a database to be used to record checkout and checkin of
various items by a group of members. I would also like to be able to keep a
checkout history of items. Does anyone have any ideas or samples I could
Click to expand...
use?
 
Create a new table with this fields:
Id - Autonumber
User - String 20 (normally any name simple to registry)
Pssw - String 20 (normally between 4 and 10, but 20 it's ok too)
DatIn - Date (dd/mm/YYYY)
DatInTime - Date (HH:MM:SS)
DatOut - Date (dd/mm/YYYY)
DatOutTime - Date (HH:MM:SS)

On your form for StartUp application put in On Open event a procedure to
write a new registry on this table and retrieve the ID
On your form for StartUp (if maintain the same during all application, else
use the button click to close application) write editing the ID registry the
DatOut and TimeOut.

You only could be problems if any machine have time or date out of sync over
the rest, but use some procedure on the startup to adjust time and date of
the pc.

--
Saludos desde Oviedo (Asturias)

Juan Menéndez
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)

Si la información recibido te ha servido indicalo con otro post.
En caso de resolverlo por otros medios, indica la solución usada
ayudaras a otros y aprenderemos todos.
 
Back
Top