Search results

i want auto generate example : ID 01001 ==> 01 is dept finance code 01002 02001 ==> 02 is dept xxx code when i choose finance the code auto generated to be 01003 and when i choose xxx dept code will be 02002 i need the code can someone give me the example ..:( i tried 2 days for this...

Hi all , i have problem with Access VBA about auto numbering Table name : test field: idNum = text remarks= text idNum = 01.001 01.002 02.001 the problem is ..when i click new id order by combobox/textbox (01) the result is 01.003 and when the...