[dba-VB] Re: [AccessD] Getting Field Type From ADO Control

Stuart McLachlan stuart at lexacorp.com.pg
Thu Sep 11 06:36:16 CDT 2003


On 11 Sep 2003 at 21:08, Stuart McLachlan wrote:

> Field types are enumerated constants.
> 
> In your VB project, set a reference to DAO then open the Object 
> Browser.
> 
> Open the DAO library and look at Globals.
> 

Just noticed, you said ADO, not DAO.

ADO Constants have different values.

ie 
dbBigInt = 16, adBigInt = 20
dbBinary = 9, adBinary = 128
dbBoolean = 1, adBoolean = 11
etc.

You will ned to set the reference to ADO , not DAO to get the correct 
values


 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the dba-VB mailing list