User Profile

Collapse

Profile Sidebar

Collapse
Gerald Taylor
Gerald Taylor
Last Activity: Apr 21 '12, 06:30 PM
Joined: Apr 4 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Gerald Taylor
    replied to Close Form and update record in Table on field change
    in Access
    Excuse my Error in the Paragraph under 'How it Works'
    The correct method is A staff Member gets to the 'sign out form' then passes their ID Badge under Barcode Scanner, Field 1 (unbound)(attac hed is a Macro in 'before Update property' of field to Search for Record based on Badge ID No which is showing after scan) displays their Staff ID number and the Next Field FullName (bound to FullName control Source)and (Macro to requery) shows Staff Member...
    See more | Go to post

      Leave a comment:

    • Gerald Taylor
      started a topic Close Form and update record in Table on field change
      in Access

      Close Form and update record in Table on field change

      Please excuse any idiotic questions as Access/VBA is a new area to me.
      I have inherited an Access Database/Application that is used to sign in and out visitors and Staff to our community Centre.
      The system works fine and with the addition of extra screens(forms) we have managed to get it to work using touchscreen monitor and an OSK.
      I was looking at using a Barcode Font (Free 3 of 9 Extended)to simplify signing in and out for...
      See more | Go to post
      No activity results to display
      Show More
      Working...