MS access :grrr
MS access :grrr
Awai |
May 18 2004, 01:01 PM
Post
#1
|
||
Waiting For... Group: Moderator Posts: 382 Joined: 18-March 04 From: ~beyond the sea Member No.: 19 |
hiya all, i have a small problem with ms access querys and visual basic - in short i have a nice new query laid out which seaches through my database and pulls out all the records with "555" in one of the colums. the next part of the query then uses a formula to generate a random letters/numbers which i'm using as the password for something else. as a demo what i'm looking to generate is a list which has the following look to it: code serial randomthingy 555 0101 aaa111 555 0102 bbb121 555 0103 ccc114 555 0104 ddd511 555 0105 eee161 however my code (which will be posted below) only seems to execute once and gives the same random number to all my outputs so the randomthing colum is full of aaa111 rather than the mixed stuff i'm hoping for... heres the code i've written into a module called Randomthing:
i assume i need to either call a loop in the code or in the query which i invoke the code with: "pass: RandomPwd(2,3)" any thought much appreciated. Awai. -------------------- "You look into her eyes
and it’s more than your heart will allow And in August and Everything After you get a little less than you expected somehow." |
||
Awai |
May 20 2004, 10:58 AM
Post
#2
|
Waiting For... Group: Moderator Posts: 382 Joined: 18-March 04 From: ~beyond the sea Member No.: 19 |
no probs now guys have sorted the wee bugger - ahh its midday time for a celebratory beer :banana:
Awai. This post has been edited by Awai: May 20 2004, 10:58 AM -------------------- "You look into her eyes
and it’s more than your heart will allow And in August and Everything After you get a little less than you expected somehow." |
Lo-Fi Version | Time is now: 13th June 2024 - 03:31 AM |