Page 4 of 4 FirstFirst 1234
Results 46 to 53 of 53
  1. #46
    bigot is offline Advanced...ish
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    37

    Quote Originally Posted by bigot View Post
    "KeyUp" is referring to keyboard keys. Are you clicking the button with the mouse?
    I'm not sure when you want to set focus. If the user is clicking the button, then KeyUp won't trigger, so in that case, yes, use ..._Click

  2. #47
    fspata is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    41
    Been delayed by some health issues but hope to get back to it today. I will keep you all posted on the status.

  3. #48
    fspata is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    41
    Quote Originally Posted by fspata View Post
    So just create a combo box with the id's pulled from the initial table?
    Ok, just trying to re-wrap my head around this thing. June7, so they come in to Check Out at the computer, the form is up with the option buttons Check In Check Out. They choose Check Out. Is the Combo Box called( made visible) to choose their name or is this something that would just be a normal part of the form?

  4. #49
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    What process do you want? The form can open with only the combobox to select ID available or a textbox for ID card scan. Then once the ID is input (by combobox or scan) other controls such as the Check In/Out buttons can be made available. Click CheckIn and more controls are available for the additional info input. Click CheckOut and the existing record is located and updated. Associated with each button is code to close form or reset back to original state for next user input.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #50
    fspata is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    41
    Quote Originally Posted by June7 View Post
    What process do you want? The form can open with only the combobox to select ID available or a textbox for ID card scan. Then once the ID is input (by combobox or scan) other controls such as the Check In/Out buttons can be made available. Click CheckIn and more controls are available for the additional info input. Click CheckOut and the existing record is located and updated. Associated with each button is code to close form or reset back to original state for next user input.
    I would think the Scan of the ID would be the better process as the initiator as to Check In or Check Out. This would be providing/updating info that is available, if any, or start a new record correct?

  6. #51
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I think that is essentially what I suggested.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #52
    fspata is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    41
    Quote Originally Posted by June7 View Post
    I think that is essentially what I suggested.
    I apologize if I am acting like an airhead lol! I've been a bit under the weather lately, had to have a biopsy done yesterday. Just trying to get my head back into this thing. I do appreciate your help!! :-)

  8. #53
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Been there. Not fun.

    I meant you seem to understand what I have offered as a suggested process. If that's the approach you want and you encounter specific issue with implementation, don't hesitate to post question.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. New record condition
    By rosscortb in forum Access
    Replies: 3
    Last Post: 07-06-2015, 07:19 AM
  2. Where Condition
    By NISMOJim in forum Programming
    Replies: 4
    Last Post: 04-09-2014, 11:10 PM
  3. Help with using the AND condition
    By ssturges in forum Access
    Replies: 1
    Last Post: 11-25-2012, 12:36 AM
  4. Like condition for 1 column help pls!
    By stodd in forum Queries
    Replies: 1
    Last Post: 03-14-2010, 01:51 AM
  5. How to use IIF condition
    By nshaikh in forum Queries
    Replies: 4
    Last Post: 09-12-2008, 01:23 AM

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