[AccessD] DAO/ADO constants

MartyConnelly martyconnelly at shaw.ca
Mon Jul 28 17:26:43 CDT 2003


Under Access.OldConstants   DB_TEXT =10

Susan Harkins wrote:

>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
>>
>>
>>    
>>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>




More information about the AccessD mailing list