Recent content by pathfinder225

MY Problem Solved Guys anyway Many thanks for taking ur time in helping me.

Thanks SOS, but this doesn't make any help, the _ is used to go for next line(continuation) it's same error again.

Many Thanks Dcrake for taking your valuable time to reply...anyway i managed to solve the problem ,just an overlook. well i'm having another trouble the same query doen't work when i put like this.. "SELECT pro_name FROM" & _ " tblProducts WHERE item_name = '" & _...

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...

Thanks for replying, well service number must be generated automatically ,which is possible if i use it as autonumber. If i use it as text type i have to insert the service no eachtime. So, what should i do now, any solution?

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...

Thank you mate for taking time to answering my question. well i don't know abt append query but managed and googled it and learned a bit about it that, it is used to select records from one or more data sources and copies the selected records to an existing table. Can u tell how this will...

Many Thanks for Replying...I'm 100% sure there won't be more than 400 records in a month.... Well this Autonumber is Unique Id (SERVICE NO)Given to Each Customer who Requests a Service ....there won't be more than 400 requests in a month....and generalizing it to atleast 5 years....can u...

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 ...