Search results

  1. S

    Help needed for DBEngine.Workspace(0)

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

    Help needed to get total of one field in access dbase table via Excel VBA

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

    Help needed from Append Query in Excel VBA

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

    Hi from Singapore

    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)...
Back
Top Bottom