Results 1 to 8 of 8
  1. #1
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    Capturing real time Data from Bio-metric Scanner DB!

    Hi every one



    I would like to ask for the help, if possible.

    I have bio-metric scanners which are feeding employees daily check in/out data to the DB "Att2000" into the "tblCheckInOut" which contained the following fields:

    UserID - (Number)
    CheckTime - (Date/Time) Format; 01/09/2009 13:15:31
    CheckType - (Short Text)
    VerifyCode - (Number)
    SensorID - (Short Text)

    I want to extract this check in/out time information to my EmDB where we have the TblEmployees including the fields EmpID, Name, Department, etc.

    Note: The UserID and EmpID is the same as BatchNumber.

    Kindly advise the procedure to extract this information to another intermediate table where to get check in and out information along all detailed information of the employee.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can you link to the table with times from your db? That would let you join them in a query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Hi, Yes. Its within the network and we will extract the data by linking tables.

    Can you advise for the query and how to store the data in Main DB.

    Regards

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I would probably just link to it. If you really need to copy it, you'd use an append query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Thanks.

    But any sample code or help?

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    With no details? Create a query that pulls the desired fields from the linked table. Change it to an append query, specify your table and the destination fields. Your code:

    CurrentDb.Execute "YourQueryName"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Hi

    Its working fantastic with linked table method. Thanks.

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update Form / Query data in real time
    By Pete-RM in forum Forms
    Replies: 6
    Last Post: 08-21-2015, 05:10 AM
  2. real-time data integration of csv file into access
    By nlsoe in forum Import/Export Data
    Replies: 4
    Last Post: 10-17-2012, 06:57 AM
  3. Blueprint for SQL data to excel in real time.
    By greggue in forum Programming
    Replies: 1
    Last Post: 12-21-2010, 12:39 PM
  4. real time clock
    By krai in forum Access
    Replies: 1
    Last Post: 05-13-2010, 05:11 AM
  5. Data management and real time data
    By fsmikwen in forum Import/Export Data
    Replies: 1
    Last Post: 03-11-2010, 10:44 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
  •  
Other Forums: Microsoft Office Forums