stuart at lexacorp.com.pg
Thu Sep 11 06:19:02 CDT 2003
Sorry, I sent this to accessd instead of dba-vb the first time. On 11 Sep 2003 at 21:08, Stuart McLachlan wrote: > On 11 Sep 2003 at 12:40, paul.hartland at fsmail.net wrote: > > > To all, > > I have a field selection box in a find form that I have created myself, but what I need to know is what datatype the field is that the user selects. > > Has anyone ever done this and can tell me how....I tried the following line of code which runs through all the fields but it returns a number...... > > MsgBox frmPersonnel.ADOPersonnel.Recordset.Fields(fldCounter).Type > > Anyone have any ideas ? > > Thanks in advance for any help received....... > > Paul Hartland > > Database Designer/Programmer > > 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. > > You will see things like: > dbBigInt = 16 > dbBinary = 9 > dbBooelan = 1 > dbByte = 2 > dbChar = 18 > dbCurrency = 5 > dbDate = 8 > dbDecimal = 20 > dbDouble = 7 > dbFloat = 21 > dbGUID = 15 > dbInteger = 3 > dbLong = 4 > dbMemo = 12 > dbNumeric = 19 > dbSingle = 6 > dbText = 10 > dbTime = 22 > dbTimestamp = 23 > > > > -- > 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 -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.
More information about the dba-VB mailing list