Recent content by 482570

Thanks a lot PHV. Work like charm. Thanks milion's for your sample and direction.

I still can’t understand why is not working. Here’s SQL statement I use and when I use form, error message as “Microsoft database engine does not recognize “[Forms]![frmReporting]![txtDate1] And (tblrun.Date)<=[Forms]![frmReporting]![txtDate2]” as valid field name or expression.” TRANSFORM...

I try to generate chart base on user input such as date range and others. I created query and Date range statement in query as “Between Date()-120 and Date()” or “Between #11/1/2007# and Date()” then working just fine. If I use Parameter prompt, query itself working fine but either report or...

Anyone has worked on chart and graph in Access? I'm looking for sample or artical in detail and I have not located yet. error message "MS jet database engine doesn't reconize "[Name]" as a vaild field name or expression" This only occur when I used date range in the form or direct input. Is...

Hello and I need your help again please!! I used following code to moving file from one location to other and working just fine so far. Problem now is if some how either source or destination has same file, then code is stop running and message show file already existing. I'm thinking just...

I'm novice user and macro program and I needs help to figure out how to move the file from one location to other done by macro. Currently import text file(Data.NC), copy and paste to excel file. after paste to excel, I need to move text file(Data.NC) to differnt location for next repeat process...