Recent content by sandrapoh

Dear RX, In my Excel VBA program, sometimes, I need to use "Microsoft DAO 3.6 Object Library". Sometimes I need to use "Microsoft Office 12.0 Access Database Engine Object Library". But both cannot exist at the same time, how to define in Excel VBA. I tried to write "Public Function DAOToACE"...

Dear all Gurus, I have written the attached program. Every time, the 1st time I ran the program, it is ok. But the 2nd time, I run the program, I always hit problem shown in the sheet "Error Hit" in the attached. The statement that hit the problem is below in the [Public Function...

Dear Namlian, Thanks again. I here by attached my excel vba and accdb for your further guidance. Both belong to Version 2007. The objective is to check if certain field in Summary table in msaccess db is 0, I will not execute the next step. Please search for the statement "varAMT Regards...

Dear Namlian, Thanks for your quick response. I have done the below as per your guidance. Set accRS = accDB.OpenRecordset("SELECT Sum(Summary.NQ) AS SumOfNQ FROM Summary) varAmt = accRS.Field(1).Value accRS.Close But cannot. I would like to put in the value from accRS.Fields(1).Value to...

Dear All Gurus, I am trying to do a select query in excel vba like the below and would like to put the result in one of the macro variable in excel vba. But cannot, please advise. lngAMT = accdb.execute "SELECT Sum(Summary.NQ) AS SumOfNQ FROM Summary HAVING (((Sum(Summary.NQ))<>0));" Thanks in...

Dear CL, Thanks for your help. I got what I need already. Regards Sandra

Hi all, I need help to investigate my excel vba code. I have wrote the attached code to run query in the attached access dbase. But hit the error message "Run Time Error 3085". I suspect my query definition is not correct. Please teach me what have I done wrong. Regards Sandra

Hi all, I am a new MS Access programmer. I have installed MSAccess 2000 and 2007 under Win XP Pro (Version 2002) SP3. I need to write some Excel VBA to interface with MSAccess 2007 because I am going to deploy the program to my other 3 laptop (Win XP Pro SP3 and Win 7 32-bit and Win 7 64-bit)...