Search results

hi all, i have a small task here that ,when i select an item in the first combo box, that selection limits the choices in the second combo box. tblItems ID AUTONUMBER item_name TEXT tblProducts ID AUTONUMBER pro_name TEXT...

hi frnds, the following is my db schema service_no:AUTONUMBER name:Text day:Date/Time My Autonumber field is of the format SExxx (ie SE000,SE001,SE002...) the following query doesn't work select * from table_name where service_no=SE002 but this works .. select * from table_name where...

hi frnds,i am a newbie to access i have one field (AUTONUMBER) in my table i want it's format as "YYMMXXX" where, YY=last two digits of year ,MM=two digits of month XXX=SEQUENCE TO be INCREMENTED. values must be like this...suppose if date is 05-jun-09 0905000 0905001 0905002 ...