Results 1 to 3 of 3
  1. #1
    dhas is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2018
    Posts
    1

    Toggle Button Help

    I have created 2 toggle buttons and linked them together so when one is active the other cant be. They are to track who is in and out of the office at any given time. we are updating our systems to use id card to scan in and out of our office. i want to set up a code or macro so when a person gets their ID card scanned the toggle buttons will switch. So as it stands now when some one come in to the building we click their name and activate the toggle button saying they are In the building and when they leave we find their name again and activate the button saying their are out. I have tried to search the internet and i came up with nothing i can understand. i normal just deal with macros not a lot of event procedures or anything like that. i was trying to find an event procedure that would basically make its so when the id card is scanned if the "in" toggle button is already active it will then activate the out button. Any help would be appreciated. Please if there is an easier way to do this or if i am just missing something please let me know.

    Here is some information

    the toggle buttons are:

    Toggle59 = IN
    Tggle60 = out


    when toggle 59 is active it places a 1 in the Field (field name is in/out)
    When toggle 60 is active it places a 2 in the field (field name is in/out)

    If i need to provide more information please let me know.


    Thank you,

    Dan

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You don't need two buttons.
    Just set the button so it is 'down' when the person is in and 'up when they are out. You can alter the colour/caption for each state.

    Alternatively, don't use buttons at all. Just have an unbound textbox or label whose value is updated for in/out.
    BTW it isn't a good idea to use special characters like / in field names. Either InOut or Status would be better
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Or use a simple checkbox.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Button to Toggle Image On/Off
    By Tycho4511 in forum Access
    Replies: 2
    Last Post: 07-06-2018, 09:20 AM
  2. Toggle Button
    By gheyman in forum Access
    Replies: 2
    Last Post: 07-11-2017, 07:43 AM
  3. Toggle Button Help
    By dbalilti in forum Access
    Replies: 1
    Last Post: 07-05-2012, 04:23 AM
  4. Toggle Button Criteria
    By tylerg11 in forum Forms
    Replies: 2
    Last Post: 03-02-2012, 09:28 AM
  5. Toggle Button Options
    By Matthieu in forum Forms
    Replies: 2
    Last Post: 11-23-2009, 04:05 PM

Tags for this Thread

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