[AccessD] Type mismatch in Array

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