MS Access, accessing field properties through code in Access 2000

accessing field properties through code in Access 2000

Author	Message
Erni #1 / 3	accessing field properties through code in Access 2000 I am trying to recreate the user friendly SQL parser that came as part of the database demo program that came with VB4. Sort of a predacessor to Visdata but much more comprehensive. I have core functionality but have been unable to come up with a method to learn the datatype of the field the user selects from a combo box. Have found little about datatype in Access help other than how to set it or change it. Thanks in Advance Ernie
Mon, 29 Aug 2005 08:50:25 GMT

peter walke #2 / 3	accessing field properties through code in Access 2000 see... Comparison of Data Types in Access help or create a database / table/ Set it up with fields of different types and ... debug.print currentdb(0).Fields(0).type and use either the object browser... Enum DataTypeEnum Member of DAO or help to decode. bear in mind some field type need to be created with DAO, not Access. -- peter walker Please post replies to the news group so everyone can benefit. www.papwalker.com/links.html Quote: > I am trying to recreate the user friendly SQL parser that > came as part of the database demo program that came with > VB4. Sort of a predacessor to Visdata but much more > comprehensive. I have core functionality but have been > unable to come up with a method to learn the datatype of > the field the user selects from a combo box. Have found > little about datatype in Access help other than how to set > it or change it. > Thanks in Advance > Ernie
Mon, 29 Aug 2005 19:54:03 GMT

Erni #3 / 3	accessing field properties through code in Access 2000 Peter, Thanks for the reply In VB I could always get the data type from the ItemData of the combo box where I chose the field. This made seting punctuation of WHERE criteria convenient. I will see if I can get the results I need by using the combo listindex property against the form you have suggested. Thanks Again Ernie Quote: >-----Original Message----- >see... >Comparison of Data Types >in Access help >or >create a database / table/ >Set it up with fields of different types and ... >debug.print currentdb(0).Fields(0).type >and use either the object browser... >Enum DataTypeEnum > Member of DAO >or help to decode. >bear in mind some field type need to be created with DAO, not Access. >-- >peter walker >Please post replies to the news group so everyone can benefit. >www.papwalker.com/links.html >> I am trying to recreate the user friendly SQL parser that >> came as part of the database demo program that came with >> VB4. Sort of a predacessor to Visdata but much more >> comprehensive. I have core functionality but have been >> unable to come up with a method to learn the datatype of >> the field the user selects from a combo box. Have found >> little about datatype in Access help other than how to set >> it or change it. >> Thanks in Advance >> Ernie >.
Mon, 29 Aug 2005 23:21:11 GMT

Page 1 of 1

[ 3 post ]