If the program is in .mde format, is there any way to get the names of the
controls in a form? I'm using a 3rd party scripting language and I'm
wondering if it's possible to modify the form data through COM..
You certainly can. I mean, virtually everything in ms-access is a
collection. That includes forms, reports, controls. Even when you pull data
into a recordset, all of the fields are in a collection. (I suspect you are
new to access..but, collections are a fundamental way to work with code in
ms-access, and, if you don't grasp the concept of collections, then you
can't really write code in ms-access)..
However, why load up ms-access to modify some data in a table? Why not just
connect to the data? If you connect to the actual tables, then your
scripting language will not have to load, or launch an instance of
ms-access. in fact, the same database engine (JET) is shipped on every copy
of windows, and thus you don't really even need to have ms-access installed
to modify that data. I would STRONGLY reconsider trying to use automaton,
and then launching a form that modifies some table. this is possible, but it
like when you are sitting on the ability to write out a
simply text file,a nd you then launch word,a nd use automaton in word to
create a silly simple text file. So, I just saying hits is around about way
to approach this.
However, for the form, there is a controls collection, and you can use the
name. however, each control on a form may, or may not necessary be bound to
the data that the form edits.....
I not sure you really want the names of all the controls and labels on a
form? I would think that just opening the table and not even using ms-access
would be a better approach here??? (the JET data engine us useable without
ms-access)
as I said, all windows boxes ship with the ability to read/write JET (access
mdb) files...you don't need to install any software (let alone ms-access) to
read and modify the data in those mdb files.
