Search results

Exactly what I was looking for. Had to make some minor additions. Thanks a ton trumpet, your a life saver.

I should have explained more in my original post. The data is being pulled from 1 table. Basically, if i goto the customer lookup form and key in a last name and find my customer, when i hit the button to go further it load up the form that should show me the customer info and list out the...

Hello, I am trying to create a form and I am not sure if it can do what I want it to do. Basically, I have multiple customers. each customer can have more than 1 record. So, if I pull up a customer i want it to show all the records associated with that customer. then from that point i...

Thank a bunch you all for the help. I got it working perfectly now. Function decodevin(pnum) If IsNumeric(pnum) Then decodevin = pnum Exit Function End If Select Case pnum Case "A" decodevin = 1 Case "B" decodevin = 2...

The whole reason for splitting the VIN up all comes down to one thing. I need to run this formula to make sure its valid. ((p1 * 8) + (p2 * 7) + (p3 * 6) + (p4 * 5) + (p5 * 4) + (p6 * 3) + (p7 * 2) + (p8 * 10) + (p10 * 9) + (p11 * 8) + (p12 * 7) + (p13 * 6) + (p14 * 5) + (p15 * 4) + (p16 * 3)...

I am more on the networking side of things and I am diving into a screwed up access database :o . I have fixed many things in it but trying to add this is proving to be complicated for me anyways. If I write a function to Decode the VIN how would I attach another function to the p#'s to...

Thanks Brian. Now it gets a little more complex after this. I need to assign a value based on what character it is if it is not a number. If it is A then it is = to 1 or U = 4, etc. Do I have to write an If statement for Case statement for each p#?

Hello everyone, I am having trouble trying to put in a VIN decoder for my company. Basically the VIN is entered into 1 column in our contract table. I need a way to split that vin into 17 different variables. For example if the VIN is 123456789ABCDEFGH then p1 = 1, p2 = 2, p3 = 3 and so on...