Is there a way to determine a field type from VBA? I've made a smart query form that lets the user build a query using combo boxes. Right now I'm pulling the colum list in a combo box using FieldList on the query that they are searching through. I need a way to determine the field type without hard coding each field name into my VBA Select Case statement.
For example, I have to catch the colums that are dates and surround their input with # signs. I also need to determine if the field is numeric or not because I'll have to use " marks on strings. I've got this working already but I don't want to leave my special fields hard coded. I'm leaving this project and somebody else will probably come back later and decide to change field names... I don't want to be called back to fix it.
I can post the code and some more info if needed. Don't worry about being too specific.. I'm pretty fluent in technical programming terms. -Dustin
Rom 8:28
For example, I have to catch the colums that are dates and surround their input with # signs. I also need to determine if the field is numeric or not because I'll have to use " marks on strings. I've got this working already but I don't want to leave my special fields hard coded. I'm leaving this project and somebody else will probably come back later and decide to change field names... I don't want to be called back to fix it.
I can post the code and some more info if needed. Don't worry about being too specific.. I'm pretty fluent in technical programming terms. -Dustin
Rom 8:28