Re: How do I declare a variable as a Variant
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 05/31/04
- Next message: Dennis: "Query Form"
- Previous message: John Vinson: "Re: surely a form with a ListBox can be used in a query?"
- In reply to: Sandy C: "How do I declare a variable as a Variant"
- Next in thread: Sandy C: "Re: How do I declare a variable as a Variant"
- Reply: Sandy C: "Re: How do I declare a variable as a Variant"
- Reply: Sandy C: "Re: How do I declare a variable as a Variant"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 May 2004 14:39:39 -0600
On Mon, 31 May 2004 12:16:03 -0700, "Sandy C"
<anonymous@discussions.microsoft.com> wrote:
>I am running an append query and get this error:
>
>You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to declare the variable as a Variant, and then try the operation again.
>
>How do I do this in the Design View or the SQL window of the query?
Neither; you need to do it in the VBA code which is generating the
error! VBA is one language (which has DIM statements and Variants);
SQL is a different language altogether. I suspect that you're either
calling some VBA function from your query, or that this error is
arising for some other reason.
Please post the SQL view of the query and the VBA of the code that
(I'm guessing) that you're using to launch the query.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: Dennis: "Query Form"
- Previous message: John Vinson: "Re: surely a form with a ListBox can be used in a query?"
- In reply to: Sandy C: "How do I declare a variable as a Variant"
- Next in thread: Sandy C: "Re: How do I declare a variable as a Variant"
- Reply: Sandy C: "Re: How do I declare a variable as a Variant"
- Reply: Sandy C: "Re: How do I declare a variable as a Variant"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
