Search results

thank u Rain for the attachment.. but the program wasnt what im looking for my program works in a way that the sub form is a table that allows user to key in multiple entries at the same time.. example user wanna find info on customername AMD and 3M... the program will output all information of...

i have this logical error in my program. i will like the program to work like this--> if user only keys in CUS (customer name), the program will search all the entries under customer name which matches with what user have key in... if user keys in CUS and PROJ(projectname), program will find...

Thanks tehNellie and vbaInet.. that was a great idea for the If statement, the idea never came across my mind.. now i have no prob with the that part.. alright prob solved..but now im facing a logical error... previously i was tehNellie help me to assign NULL input as na.. i will like the...

i have this current program modify from another program, both program function quite similar.. when compiling, there are 2 error when i run the access, 1 is it point that there was syntax error on insert statement, but i couldnt any mistake - DoCmd.RunSQL strinsert (program point it mistake...

Thank you tehNellie, now my program can display some data, but the data was wrong.. it seems to copy every single data in the database and output it.. but i counldnt figure out what went wrong.. im thinking was the INSERT statement im using it wrongly. below is the part of program which i...

Hi, i need some help. below is my prog.. im actually new to MS access, never learn in school, self picked up i bold the part which i think the program went wrong, example i keyed in "3M" for Manufacturer, even if the prog found "3M" in the tblClient , it cant proceed to the other if statement...