gathering metadata especially the fields table

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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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, 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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Johan Koopmans" wrote in message
...
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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Johan Koopmans" wrote in message
...
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

"Johan Koopmans" schreef in bericht
...
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
"Allen Browne" schreef in bericht
...
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

"Johan Koopmans" wrote in message
...
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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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

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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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 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
"Allen Browne" schreef in bericht
...
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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Johan Koopmans" wrote in message
...
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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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

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" schreef in bericht
...
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
"Allen Browne" schreef in bericht
...
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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Johan Koopmans" wrote in message
...
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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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

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

"Johan Koopmans" schreef in bericht
...
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
"Allen Browne" schreef in bericht
...
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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Johan Koopmans" wrote in message
...
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.


"Duane Hookom" schreef in bericht
...
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.

--
Duane Hookom
MS Access MVP
--

"Johan Koopmans" wrote in message
...
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