I want to find the information on the fields in each database in an Access database. I need the Visual Basic code to get this information from the structure. I have Googled with no results. Can someone help?
I want to find the information on the fields in each database in an Access database. I need the Visual Basic code to get this information from the structure. I have Googled with no results. Can someone help?
That helps, but I was hoping to get it using VB.
Allen Browne to the rescue again.
This web page Microsoft Access tips: DAO Programming Code Examples (allenbrowne.com) contains several functions you can use
For example: ShowFields/ShowFieldsRS. You will also need FieldTypeName
That looks like exactly what I want. Now if I Can close this thread.
FYI:
I attached some source code for a simple dictionary in this thread
a while back. It's simple but it may help.