Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newby, ..Membercode
Hallo,
i'm very new in Access.. ik ben een nieuweling in Access. I would like to create a unique code by using the last name and a no. Making this by using the fisst 4 letters of the Lastname and a following number. f.i. Lastname Janssen will then be JANS1 Lastname Jansen - JANS2 and so on.. if the lastname is shorter then 4. then only us the name and a following no. f.i. ES1 any help will be great. gr. Swingleft |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newby, ..Membercode
hi Swingleft,
oName = "Jans" no = 5 If Len(oName) <= 4 Then oName2 = oName & no -- isabelle Le 2011-12-08 11:56, Swingleft a écrit : Hallo, i'm very new in Access.. ik ben een nieuweling in Access. I would like to create a unique code by using the last name and a no. Making this by using the fisst 4 letters of the Lastname and a following number. f.i. Lastname Janssen will then be JANS1 Lastname Jansen - JANS2 and so on.. if the lastname is shorter then 4. then only us the name and a following no. f.i. ES1 any help will be great. gr. Swingleft |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
membercode check | Excel Programming | |||
Break Apart a Cell, please help a newby | Excel Discussion (Misc queries) | |||
Newby help | Excel Worksheet Functions | |||
Help a Newby Please!! | Excel Programming | |||
Yet another Newby question about selecting | Excel Programming |