Results 1 to 13 of 13
  1. #1
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9

    selection

    Hi all
    I wonder if someone could point me in the right direction.


    I have a form with 100 hundred buttons each button is a number 1 through to 100, when someone logs on duty they are assigned a location through the aid of the buttons but the form looks really messy, is there any way to make it work better.
    I know this may be a stab in the dark.

    Cheers
    Tony

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    So I imagine that user simply clicks on button to select location?
    Why not text box then where user inputs number 1-100? Or even combo box with rows 1-100? Or list box?
    We need more info of what you're doing with those buttons.

  3. #3
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9
    Hi
    Thanks for the quick reply.
    Each button corresponds to a location in a building and I am trying to make it user friendly so no numbers have to be typed instead a button is pressed.
    I originally tried a text box and a combo box but this meant typing in the number which could lead to human error.
    Any thoughts appreciated.

  4. #4
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    I believe choosing one button out of 100 is as prone to errors as typing it
    Also, in combo box you don't have to type anything, just chose one number from the list. Same with list box.

  5. #5
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Besides, 100 buttons on the form don't look THAT bad.
    Click image for larger version. 

Name:	100buttons.jpg 
Views:	16 
Size:	29.7 KB 
ID:	23609
    But it requires 100 Click events to code... I really don't think it's the best idea.

  6. #6
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9
    I know what you mean.
    I am not happy with it.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Could have a keypad layout.
    Display in the center to see buttons pushed.
    Limit (or require) 3 digits.
    Could limit number entered to between 1 and 100.

    Click image for larger version. 

Name:	Buttons.jpg 
Views:	14 
Size:	20.5 KB 
ID:	23613

    "Submit" button could be disabled until 3 numbers entered.

    I forgot to add a "Clear" or "Reset" or "Backspace" button.

  8. #8
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9
    Hi ssanfu
    I like the idea of a pad, is it easy to implement?, what is the coding behind the scenes? And is it possible to do negative numbers as at the moment I have 1 to 100 buttons doing the positive for on duty and another 1 to 100 doing the negative off duty so the logs work?

    I am still learning access.
    Thanks
    Tony

  9. #9
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    It's actually pretty easy to implement. Here's some quick simple db for you:
    Database12.zip
    It's not pretty, but it's some start.

  10. #10
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    is it easy to implement?,
    Not hard, but could be lots of code depending on your requirements.

    what is the coding behind the scenes?
    Not a clue.
    I don't know what you want to happen when someone enters 56 and clicks submit/enter. You can have the code do whatever you want.


    And is it possible to do negative numbers
    Sure. You can have a "Log in" button that enters positive numbers and a "Log out" button that will automatically change the number entered to a negative number. And have the code check to ensure someone is not logging out before they log in.

  11. #11
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9
    Cyanhidem is it OK for me to use the sample calc in my project as I have decided to go down that route.
    I have it working but I will remove if you object.
    Thanks
    Tony.

  12. #12
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    It's absolutely ok, I just quickly made it for you so you have some base to start.

  13. #13
    TheTony is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9
    That is superb, it has made the form look a lot more slick and less cluttered.
    Thanks for the help this is a great forum.
    😁

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

Similar Threads

  1. Replies: 2
    Last Post: 08-22-2014, 01:20 PM
  2. Replies: 5
    Last Post: 04-09-2014, 06:57 PM
  3. And and Or selection
    By Amen in forum Access
    Replies: 8
    Last Post: 10-23-2013, 08:29 AM
  4. One selection force another selection
    By K. Foster in forum Database Design
    Replies: 4
    Last Post: 02-03-2012, 10:30 PM
  5. cmb box selection
    By dr223 in forum Access
    Replies: 3
    Last Post: 01-13-2012, 09:16 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