[AccessD] DAO/ADO constants

Thanks Marty -- I tried a couple but they didn't work in the following:

Private Sub Form_Load()
  Dim boo As Boolean
  boo = SetStartupOptions("AppIcon", 10, _
      "C:\A\TechRepublic\Icons\h.ico")
  If boo = True Then
    CurrentDb.Properties("UseAppIconForFrmRpt") = _
        vbTrue
  End If
End Sub

This just passes arguments to a procedure that appends and adds properties
to the Application object -- as such, even though it uses DAO, you don't
need to reference the library. If there's an explicit reference to DAO, you
can use the dbText constant instead of the integer 10. But I'd rather not
reference the library just for that -- and I can't find the appropriate text
constant to replace it with.

Susan H.
----- Original Message -----
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, July 27, 2003 3:29 PM
Subject: Re: [AccessD] DAO/ADO constants


> Here is a list of ADO constants vs their Access SQL Oracle data types
> http://www.able-consulting.com/ADODataTypeEnum.htm
> so adVarWChar or adVarChar dependent on unicode or ascii.
>
> Susan Harkins wrote:
>
> >The DAO library uses the constant dbText (integer value is 10) -- does
> >anyone know if there's an ADO counterpart? The dbText constant only works
if
> >the DAO library is referenced.
> >
> >Susan H.
> >
> >_______________________________________________
> >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
>
>