Prev: Join a table, queryfails with "Query input must contain at least one table or query
Next: XIRR Calculation
From: Bob Barrows on 5 Nov 2009 07:19
Bob Frank wrote:
> So I found out the variable type. I had to reference MS DAO first then
> declare the variables as database, querydef, etc.
>
> The problem is I'm still getting an "Object variable or With block
> not set" error.

Well, you certainly have my sympathies. Do you want help with it?

Hint: I'm not standing behind you looking at your code over your shoulder
:-)

Did you forget to use the Set keyword to assign an object to a variable?

PS. I'll be happy to help you here, but coding issues really belong in one
of the VBA groups in the Access hierarchy.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


First  |  Prev  | 
Pages: 1 2
Prev: Join a table, queryfails with "Query input must contain at least one table or query
Next: XIRR Calculation