Search results for query: *

fneily, This is where I may need a little more help. My degree of skill with Access building is limited although yes most of what is here I currently handled. Could you please give me some layman logic on how I should build this. Or tell me if what I am saying here is correct. Basically take the...

hahahhaa, Yah I was pondering this last night, and I believe the same thing. I need to create the script that hits both Lenders and Loans together at the same time. Does a search and then matches them against each other. I believe the copy function is a relentless nightmare to no where. However...

fneily, speaking on the script as it is isnt there a way to take the RND number in and have it check for the same SSN and then spit out the same pin when the SSN is the same?

No we have an agreement regarding the structure, we had to have them create the table although we wanted to. The reason being is they do random updates to their SW and they hold no responsibility to our DB becoming unstable if we change anything. WEhave been given VERY limited editable areas...

We tried to get approval for non random values, our Corp HQ denied that one all together. We were given certain standards for the codes that must be met. So I am only working with what was thrown at me.

Yah Im kinda stumped, it should generate the same PINs for the same SSN, however it seems not to be doing that. Im looking for other issues that may be creating this. I just noticed that yes it creates the copies correctly dup the PINs to the same SSNs. However on the Create Buttons it is not...

it still seems to not generate identicle PINs in that initial generation for the first set of tables. Really makes no sense however it theoretically should generate the same PIN if the SSN is the same.

So then would this script be correct or not? Im a little confused LOL. Would these as shown create PIN that would be the same for the same SSN and yet dif for dif SSNs. Lender PIN Gen UPDATE [TDS Lenders] SET [TDS Lenders].WPC_PIN = Int(Rnd(Now())+Rnd(Right([TDS...

The initial creation seems to be one of the biggest buggers. It makes no sense why in some duplicate SSN accounts it will assign the same PIN however in other duplicate SSN accounts it will not assign duplicate PINs.

Here is the problem I seem to be having. Also the issue is we cannot create other tables due to the fact we are using 3rd party. And this is an edit on the fly. My problem is yes it creates my PINs as I want however it is sporadic on the duplicational factor for a lender with many accounts. It...

It works fine for my application. However what is happening is it is taking data that already exists in a tabled format from another program. This data is scanned and creates random PINs for the accounts. Now remembering also these PINs must be the same for the user no matter whether he is the...

Ok, The users in both loans and lenders have have SSNs, some may be both lender and or loan. Others may be just a lender or the loan account. Although many are loaned accounts many are also serviced house lender accounts as well. So you may have a lender that is both lender and loan. I know its...

Ok, I got an OK to post since you are all tech and programmers anyway, ======================================================================================= Copy Lenders to Loans UPDATE [TDS Loans] INNER JOIN [TDS Lenders] ON [TDS Loans].SSN = [TDS Lenders].SSN SET...

fneily, i can post the script however not the tables. Although I truly prefer not to post the script because of the sensitive nature of the script. If you would like to see the script I will gladly email you the basic codeline. Thank you,

Ok, here is the situation, it is supposed to create a 6 digit pin, then in the next macro it is supposed to take that 6 digit pin and match it to SSNs that are duplicates in the second table. If they are dupliacte SSNs in both table then they should have duplicate PINs. If not they should have...

Hello, I am writing an access script that takes account information from one DB and uses a portion to create PIN numbers. There are 2 seperate sides to this DB as well. I am also attempting to have it verify the users from one and when duplicates are there use the same PINs for both. Although I...