Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10

    mix of letters and numbers on the form


    I want to mix letters and numbers on the form.
    Attached Files Attached Files

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Sorry, but you're going to have to give a much better explanation of what you're trying to do, here, if you expect us to help you! By itself,
    "I want to mix letters and numbers on the form"
    means absolutely nothing.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    Quote Originally Posted by Missinglinq View Post
    Sorry, but you're going to have to give a much better explanation of what you're trying to do, here, if you expect us to help you! By itself, means absolutely nothing.

    Linq ;0)>
    I'm sorry.
    Very little knowledge of English
    So actually saying
    I hope that helps pictures


    Click the Mix button : Group 1 and Group 2 buttons captions mix,

    Click the sort button : Sort Group1 and Group 2 buttons captions,

    Click the LARGE button : Group1 button to get capital letters capitons,


    Click image for larger version. 

Name:	VirtualKeyboard.png 
Views:	15 
Size:	73.7 KB 
ID:	13443

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Those pictures don't help me understand issue you are trying to describe. However, your form may be corrupted. The buttons code would not execute, just errors. I created a new form and copy/pasted all the controls and code to the new form. Buttons on the new form execute without error.
    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. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe.....
    Image 1 kind of looks like the keypad (well, the after part) when I login to my bank.
    The key pad characters are in random order - and the order of the keys change each time I login.

    If the OP wants a random keyboard, this would take a lot of code.......

  6. #6
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    Quote Originally Posted by ssanfu View Post
    Maybe.....
    Image 1 kind of looks like the keypad (well, the after part) when I login to my bank.
    The key pad characters are in random order - and the order of the keys change each time I login.

    If the OP wants a random keyboard, this would take a lot of code.......
    yes it is
    do not understand the logic of the code


    Public Function mix()


    For Each Me.Controls
    ????
    ???

    End Function

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Would take a HUGE amount of code, and make no logical sense at all! Why in the world would you change the order of keys in a keyboard? I mean, outside of ticking off your users?

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  8. #8
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    I need to shuffle and sort the function code

  9. #9
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    You keep posting, but you don't give us a plain language explanation of your needs! "I need to shuffle and sort the function code" means just about as much as "I want to mix letters and numbers on the form!"
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  10. #10
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    I do not speak your language. If I knew that I could have more clearly what I want.

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Why do you want/ need shuffled code? Perhaps there are options.
    What is your language? Google has a language translation feature.

    You seem to speak "our" language well enough to mask your intent and avoid specifics.

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    As Linq says, looks like would require a lot of code or at least complicated. Randomization is not easy to apply.

    One approach might be to somehow use Rnd function to generate a set of values, assuring that the values match ASCII code for printing characters and are not duplicated and set the caption property of button. I think the hard part would be preventing duplication in the set.

    Another maybe to randomly select records from a table.
    Search Bing: VBA select random records
    Review http://www.vb-helper.com/howto_net_random_records.html Code is for VB.net but might be able to adapt.
    Another http://www.fontstuff.com/vba/vbatut02.htm
    Table would have a PK field and a field with the keyboard characters. Pull the records from the table randomly and assign value to button caption.
    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.

  13. #13
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    Quote Originally Posted by June7 View Post
    Pull the records from the table randomly and assign value to button caption.
    I think this would be the most logical. Table created, but how to fill the button captions


    updated an example of VirtualKeyboard Update.zip

  14. #14
    iscinar is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2013
    Posts
    10
    Quote Originally Posted by orange View Post
    Why do you want/ need shuffled code? Perhaps there are options.
    What is your language? Google has a language translation feature.

    You seem to speak "our" language well enough to mask your intent and avoid specifics.
    google.translate using already.
    But sometimes it is translated incorrectly, It's hard to understand.

  15. #15
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I get the same error with the buttons on the form "The expression On Click you entered as the event property setting produced the follow error: ..."

    Not even going to try building this for you. Have given references for you to work with and attempt application. When you encounter specific issue in development, 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 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sorting by Letters and then numbers with dashes
    By Analogkid in forum Queries
    Replies: 8
    Last Post: 04-29-2013, 05:05 PM
  2. IIF with numbers and letters
    By hzrdc2 in forum Queries
    Replies: 2
    Last Post: 03-28-2013, 07:29 AM
  3. Import Errors - Fields with Numbers and Letters
    By Eekers in forum Import/Export Data
    Replies: 5
    Last Post: 01-10-2012, 02:52 PM
  4. Removing all letters or all numbers from string
    By Hayley_sql in forum Programming
    Replies: 2
    Last Post: 09-16-2009, 02:01 AM

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