Results 1 to 4 of 4

Thread: Ms Access Entry/Exit Database or Database by any other maker.

  1. #1
    Member
    Join Date
    Aug 2004
    Posts
    172
    Thanks
    0
    Thanked
    0 times in 0 posts

    Ms Access Entry/Exit Database or Database by any other maker.

    Think this is the right area for this.

    I need a database program (Ms Access based preffered) that will allow me to log in visitors to my place of work and also allow me to add a photo of the person.
    Heres what i need.

    I need it to have fields for name, dob and id number.
    I also need to it auto log time in and out when the id number is inserted.
    also would like it to bring up persons details when either id number, name, dob is entered.
    And if possible when a person is added it will generate an id number for them.

    For instance if i type in an id number it will bring the person up and log them in. When the person leaves i again type in the id number and the person gets logged out.

    Hope you get the guist of it because i cant find anything that will suit.
    Thanks for any help in advance guys or girls.

  2. #2
    Member
    Join Date
    Sep 2003
    Posts
    95
    Thanks
    0
    Thanked
    1 time in 1 post
    Access will do this simply and easily, what bits of the problem statement can't you do?

    What course is the work being set for or is it part of your job?

    HT

  3. #3
    Treasure Hunter extraordinaire herulach's Avatar
    Join Date
    Apr 2005
    Location
    Bolton
    Posts
    5,618
    Thanks
    18
    Thanked
    172 times in 159 posts
    • herulach's system
      • Motherboard:
      • MSI Z97 MPower
      • CPU:
      • i7 4790K
      • Memory:
      • 8GB Vengeance LP
      • Storage:
      • 1TB WD Blue + 250GB 840 EVo
      • Graphics card(s):
      • 2* Palit GTX 970 Jetstream
      • PSU:
      • EVGA Supernova G2 850W
      • Case:
      • CM HAF Stacker 935, 2*360 Rad WC Loop w/EK blocks.
      • Operating System:
      • Windows 8.1
      • Monitor(s):
      • Crossover 290HD & LG L1980Q
      • Internet:
      • 120mb Virgin Media
    Yep, that would indeed take you about 30 minutes to set up in access. only trouble might be integration with webcam software, but i dare say you bodge it. It would probably be easier to do in some kind of standalone program as then you could get direct accessto the webcam.

  4. #4
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts
    if you wanted to be able to grab images as well , you'd probably have to use more than access as a front end ( unless you used seperate software to grab the images and save the file as <userid>.jpg - the front end would knwo to pick that up from an images folder.
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ms Access Database Proggy
    By GBDarkAngel in forum Software
    Replies: 0
    Last Post: 10-10-2005, 10:22 PM
  2. abnormal access database traffic?
    By Stoo in forum Networking and Broadband
    Replies: 8
    Last Post: 06-10-2004, 04:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •