A
Alp Bekisoglu
Hi all,
How can I reach individual fields of a table using VBA code?
TIA
Alp
How can I reach individual fields of a table using VBA code?
TIA
Alp
A
Allen Browne
Alp Bekisoglu said:
If you want the data in the fields, OpenRecordset and examine the Fields
collection.
If you want the structure of the fields, examine the Fields of the TableDef.
Example of this at:
http://allenbrowne.com/func-06.html
A
Alp Bekisoglu
Thank you very much Allen. I'll do some homework on your advice.
The reason behind the question was related to auto-entry of data via a form
to all tables, well almost all. I might have resolved it in a weird manner
but I came up with a module (156 lines! including comments) performing the
task(s) through forms bound to each table. I was actually hoping to
accomplish that by dealing with the tables directly, thinking it could be
neater and much smaller code.
Well, still in crawling stages... Will learn to do better someday, if age
permits that is.
Thanks again.
Alp
The reason behind the question was related to auto-entry of data via a form
to all tables, well almost all. I might have resolved it in a weird manner
but I came up with a module (156 lines! including comments) performing the
task(s) through forms bound to each table. I was actually hoping to
accomplish that by dealing with the tables directly, thinking it could be
neater and much smaller code.
Well, still in crawling stages... Will learn to do better someday, if age
permits that is.
Thanks again.
Alp