Jim, You could try out my sample db named Report_CustomGroupSort (in its original state, without any modification at this stage) and ascertain whether the...
I am building a new database to be included in my current one. This involves detours on highways and roads. I have images of the maps with the detour drawn...
At last, by accident, I used Windows Explorer, and found that one of the options on right click when a file was selected was 'unlock'. That did 'unlock' the...
I need to generate many random passwords for an existing member database. Once I have the existing records complete I then need to generate a random password...
Just thinking out loud: Have you used the random number generator in VBA? If you seed it with the current time, it's pretty reliably random. You could use...
It's function either RND or Random I don't remember... Okay But why. Who can remember random passwords? I don't understand why you'd do that? let them...
Has anyone ever encountered the problem where sometimes Access will let you copy/cut and paste and sometimes it won't?? I'm trying to cut some data out of a...
... This is an existing large member list. I need to fill hundreds of password fields. When launched each member will get an email with his existing password...
Robin Check the VBA help files for Rnd() function. Be sure to read about Randomize as well. It helps prevent getting the same "random" number when using Rnd()...
It has been a while since I used RND(), but I think I used it with the Now() function to get a pseudo random seed. Won't using the person's initials get the...
Bill- Thank you so very much for you detailed explaination! Last week I have added extra ram into my computer. and it solves the problem temperarily. Kevin ......
Hi Bernie, Before you do any more work on images, have a look at Message #36490. You could also download John Viescas' sample file. Regards, Clive. ... This ...
You're welcome Kevin. Even though today's computers come loaded with RAM of enormous size, it isn't always enough. Operating systems, scanning software and ...
Jim You're right. The initials don't do anything for the random seed. I said the OP should use Randomize AND concatenate the initials, just as a further step...
Thanks Clive, I was looking around in the help section of the program yesterday and found the answer. My .jpg's are stored in another folder and linked to the...
Hello all, Maybe a simple one, but I can't quite figure it out. I have an unbound form (for displaying only, not for storing data). I have a unbound combo box...
Daniel Easy-squeezy! I assume you have a table with the states and their region. Use the AfterUpdate event of the combo box to set the RowSource of the list...
A.D. Our fellow MVP, Alex Dybenko came up with a solution. I have uploaded the code as a .bas file titled basPrintPDF. It worked as required. A couple of times...
In the combo box's after update event put... Me.MyListBox.Rowsource = "SELECT MyField FROM MyTable Where Region = '" & Me.MyComboBox & "'" You did not provide...
Thanks Bill! So nice of you to have pursued the matter and brought it to a logical conclusion. Our collective thanks also go to Alex for providing a solution...
... database. ... are ... This should fit the bill: Public Function GenPW(PWLen As Long) As String Dim x As Long Dim sPW As String For x = 1 To PWLen Randomize...
You are welcome, A.D. I hope it proves useful to the OP as well as all our other members. I was unaware of the FindExecutable API function. That looks to be...
Very nice example of a randomly generated password. Thank you for posting it. Regards, Bill Mosca, Microsoft Access MVP Founder, MS_Access_Professionals ...
So far what I have done is this: Original/POA: Right([TASK_NAME],InStr([TASK_NAME],"06-0207 - ")+11) However, what I am getting out of it, is not what I want....
Mandy Jo Can you post a sample or two or both Original and POA strings so we know what we have to start with? Regards, Bill Mosca, Microsoft Access MVP ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
