[AccessD] Type mismatch in Array

I was using Set -- just a really stupid mistake Charlotte. 

Susan H. 

>I don't understand what you're doing here, Susan.  What are you planning
> to use varErrors for?  I can't recall trying to take a bunch of other
> datatypes and stuff them in a variant array and pass that into a variant
> variable.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Thursday, October 30, 2008 2:51 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Type mismatch in Array
> 
> It's been a while since I've used an array -- can someone give me a clue
> why the Set statement is returning a Type Mismatch error? How can
> Variant be a mismatch to anything?
> 
> Susan H.
> 
> 
> Public Sub LogError(errdte As Date, comname As String, _  usernme As
> String, errno As Long, errdes As String, errmod As String)
> 
>  Dim varErrors As Variant
> 
>  Set varErrors = Array(errdte, comname, usernme, errno, errdes, errmod)
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com