Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Checkin/Checkout System in Access

Discussion in 'Information Technology' started by kiddjt, Jul 28, 2006.

  1. kiddjt

    kiddjt
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    Hard Talk The Caste System: Here's Why It's So Repugnant To Sikhi Hard Talk Aug 15, 2016
    Shabad Numbering System New to Sikhism Dec 1, 2015
    Canada India banned the caste system 60 years ago, but it lives on for many in Metro Vancouver Breaking News Oct 11, 2013
    Devanagari as a Writing System for Punjabi: Plus or Minus for Punjabi? Punjab, Punjabi, Punjabiyat Jul 30, 2013
    India India sets up elaborate system to tap phone calls, e-mail Breaking News Jun 20, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    There are quite a few on the main MS site. Take a look as most of them can
    be altered to make to suitable for specific tasks

    http://office.microsoft.com/en-us/templates/CT011366681033.aspx

    --
    Wayne
    Manchester - England



    "kiddjt" wrote:

    > 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?
     
  4. Mastercafe - Juan

    Mastercafe - Juan
    Expand Collapse
    Guest

    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
    juan@mastercafe.com

    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.

    "kiddjt" <kiddjt@discussions.microsoft.com> escribió en el mensaje
    news:3B2B2B7C-9FCF-4FBD-AB58-4C60BDDCCC64@microsoft.com...
    > 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?
     
  5. kiddjt

    kiddjt
    Expand Collapse
    Guest

    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

    "Wayne-I-M" wrote:

    > There are quite a few on the main MS site. Take a look as most of them can
    > be altered to make to suitable for specific tasks
    >
    > http://office.microsoft.com/en-us/templates/CT011366681033.aspx
    >
    > --
    > Wayne
    > Manchester - England
    >
    >
    >
    > "kiddjt" wrote:
    >
    > > 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?
     
  6. kiddjt

    kiddjt
    Expand Collapse
    Guest

    I'm not quite sure I understand your answer. I'm pretty new at access.

    "Mastercafe - Juan" wrote:

    > 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
    > juan@mastercafe.com
    >
    > 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.
    >
    > "kiddjt" <kiddjt@discussions.microsoft.com> escribió en el mensaje
    > news:3B2B2B7C-9FCF-4FBD-AB58-4C60BDDCCC64@microsoft.com...
    > > 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?

    >
    >
    >
     
  7. Fred Boer

    Fred Boer
    Expand Collapse
    Guest

    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" <kiddjt@discussions.microsoft.com> wrote in message
    news:3B2B2B7C-9FCF-4FBD-AB58-4C60BDDCCC64@microsoft.com...
    > 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?
     
  8. Mastercafe - Juan

    Mastercafe - Juan
    Expand Collapse
    Guest

    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
    juan@mastercafe.com

    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.

    "kiddjt" <kiddjt@discussions.microsoft.com> escribió en el mensaje
    news:1245364D-15E9-4264-A505-EAF33AE82D83@microsoft.com...
    > I'm not quite sure I understand your answer. I'm pretty new at access.
    >
    > "Mastercafe - Juan" wrote:
    >
    >> 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
    >> juan@mastercafe.com
    >>
    >> 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.
    >>
    >> "kiddjt" <kiddjt@discussions.microsoft.com> escribió en el mensaje
    >> news:3B2B2B7C-9FCF-4FBD-AB58-4C60BDDCCC64@microsoft.com...
    >> > 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?

    >>
    >>
    >>
     

Share This Page