I want to mix letters and numbers on the form.
I want to mix letters and numbers on the form.
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."I want to mix letters and numbers on the form"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
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.
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
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
I need to shuffle and sort the function code
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
I do not speak your language. If I knew that I could have more clearly what I want.
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.
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.
I think this would be the most logical. Table created, but how to fill the button captions
updated an example of VirtualKeyboard Update.zip
google.translate using already.
But sometimes it is translated incorrectly, It's hard to understand.
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.