gathering metadata especially the fields table

  • Thread starter Thread starter Duane Hookom
  • Start date Start date
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
 
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
 
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.
 
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
 
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.
 
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
 
Back
Top