+ Reply to Thread
Results 1 to 2 of 2

Help with "Generate Password" Button to generate random alphanumeric code and insert

  1. #1
    Registered User
    Join Date
    04-07-2016
    Location
    Lincoln
    MS-Off Ver
    2010
    Posts
    27

    Help with "Generate Password" Button to generate random alphanumeric code and insert

    Hello all,

    I would greatly appreciate any help on this... I have an access database in which I have a split form that searches and shows three fields.
    I have a button next to each field that I would like to click and generate a random 8 digit alpha/numeric/special character code and write this to the field. Additionally, I need the current contents of the field (before the generation) to move to another field...

    In simple terms The form shows a current password in the field. I want to click the button and perform the action of cutting the current password and placing it in another field in the table "Previous Password", then the newly generated string should be inserted into the original password field.

    I'm looking for help in writing the VBA for this, not sure if it is do-able!

    Many thanks.

    Ali

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with "Generate Password" Button to generate random alphanumeric code and insert

    This recent post might be of some help.

    https://www.excelforum.com/excel-pro...ml#post4836012
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 09-24-2017, 11:53 AM
  2. Replies: 2
    Last Post: 07-03-2017, 12:31 PM
  3. Generate random Alphanumeric with two letters and three numbers
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 09:19 PM
  4. How to generate unique random alphanumeric 32 character codes?
    By JussiR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 06:30 AM
  5. Replies: 9
    Last Post: 11-19-2013, 06:17 AM
  6. button to generate data selected "above" into a new workbook
    By sameerk0286 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2010, 09:40 PM
  7. Trying to generate the letter "X" in random blocks
    By awaters76 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-08-2009, 03:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1