+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Access - Simple way of registering a date an item was audited in Technical; I need a simple way of registering the date an item was scanned with the bar-code reader for audit. It ...
  1. #1

    CHR1S's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    4,573
    Thank Post
    1,652
    Thanked 506 Times in 309 Posts
    Rep Power
    221

    Access - Simple way of registering a date an item was audited

    I need a simple way of registering the date an item was scanned with the bar-code reader for audit.

    It needs to store multiple dates for each item to track its lifetime in school.

    I then need to create a statement that flags a tickbox for the record on each asset registered.

    Code:
    If "date = anydate in 2012"
    
    then "2012flag = true"
    I will create a simple form that has a bar-code entry field and a button that commits the record and date to a table, allowing me to audit as fast as possible.


    How would you create the table to store multiple incremented dates that you can query for a single record?

    Thanks

  2. #2
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    26
    It is simpler to have two tables - one that has all the asset information and one that has each instance of it being scanned.

    Then you write into the main asset information the latest date an item was scanned (either as it happens or via a query afterwards).

    And rather than trying to track whether something was done in 2012 or not, it is easier if you then just produce a list of all the assets sorted by the date in ascending order and work your way down the list. Doing it this way will let you pick it up whenever you have downtime and work your way down the list until you can see that the dates are in or around 12 months.

  3. Thanks to limbo from:

    CHR1S (6th August 2012)

  4. #3

    CHR1S's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    4,573
    Thank Post
    1,652
    Thanked 506 Times in 309 Posts
    Rep Power
    221
    This is solely for a quick method of displaying and creating the master audit flag for each year.

    I have systems in place to audit room changes and faults.

    Ive gone down the route of creating a seach page with tick boxes and a save button so I can quickly scan and flag multiple items in succession. Its crude but it works very well and its quick.

  5. #4

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,086
    Thank Post
    123
    Thanked 534 Times in 357 Posts
    Blog Entries
    2
    Rep Power
    336
    @limbo is right.

    It's far better to have an associative table for better data normalisation.

    e.g.

    Scan Table
    -----------
    Object ID | Scan date
    Object 14 | 06/08/2012
    Object 13 | 05/08/2012
    Object 14 | 03/09/2011
    Object 12 | 03/09/2011

    As for your query, you could use a "SELECT DISTINCT" from the scan table, with an "ORDER BY scan_date DESC" to get the latest scan date for an object.
    Last edited by jinnantonnixx; 6th August 2012 at 04:23 PM.

  6. Thanks to jinnantonnixx from:

    CHR1S (6th August 2012)



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 4th February 2011, 03:15 PM
  2. Any simple way of doing this? (OS partition re-size related)
    By Ambient in forum Windows Server 2000/2003
    Replies: 7
    Last Post: 28th June 2010, 10:04 PM
  3. Simple way of creating photo-slideshow-with-music
    By dhicks in forum How do you do....it?
    Replies: 21
    Last Post: 11th May 2009, 01:15 PM
  4. Thats an.... interesting way of fixing it
    By _Bat_ in forum General Chat
    Replies: 9
    Last Post: 31st March 2007, 06:22 PM
  5. What is the best way of tackling an MCP
    By Cyber-Dude in forum Courses and Training
    Replies: 15
    Last Post: 7th July 2006, 08:47 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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