gathering metadata especially the fields table

[Duane Hookom]

You can't query the fields directly with SQL. There are options such as the
Documenter or snippets of code like this page on Allen Browne's web site
http://members.iinet.net.au/~allenbrowne/func-06.html.

 

[Allen Browne]

Johan, from your code window, choose References on the Tools menu, and check
the box beside:
Microsoft DAO 3.6 Library

The library is checked by default in all versions of Access except 2000 and
2002.

More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

 

[Allen Browne]

Yes, Johan.

We can't develop all your code for you, but you can concatenate each line
into a string instead of printing to the debug window. Then at the end of
the procedure you can assign the value of the string to the unbound text box
on your form, e.g.:
Forms!Form1!Textbox1 = strMyOutputString

 

[Johan Koopmans]

I managed to unlock all system tables within access.
When querying sysobjects I get an overview of all tables, queries,forms etc.
within my database.
The only thing I can't manage to do is getting an overview of the fields
used in my tables.
When using Visual case I'm able to extract all metadata including the fields
..

Can somebody tell me what to do to make system fields queryable within
access?

thanks
Johan

 

[Johan Koopmans]

Thanks a lot for the codepage! I copied the function within a new module but
it causes the following error:
a user defined datatype hasn't been defined

I have the feeling Access doesn't accept the 'Dim db As database' code-part.

 

[Johan Koopmans]

Thanks I tried and still doesn't work. Currently I'm looking for a download
for DAO 3.6, will be back about the issue later

 

[Johan Koopmans]

Ok, I installed DAO 3.6 and referenced it within Access. I have valid proof
DAO 3.6 was succesfull, finally I have database as an object within my
object browser.
But, the code is still not working. I've put the code in a new module called
functions. I reference the code within a text box and have put the function
within the recordsource. Even when running from intermediate window it
generates an error called called sub or function hasn't been defined.

 

[Johan Koopmans]

Ok, now it works within the intermediate window, nice piece of code mr.
Browne!
Next thing I would like to do is get the result into a text field on the
form. I have a text field as input (to choose a table), a button to execute
the function
to get the result into another text field. Is it possible with a metadata
function to run it at runtime?

Thanks,
Johan