Re: where to find column name and properties in system tables in a

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Allen-once again, thank you for your response and taking the time. This did
work for me. Access fascinates me, but I have so little time due to work to
get into the things like programmtical recordsets, forms, etc. If I could
only learn more on this I would be able to do some remarkable things with my
work. But this is a start, thank you.

"Allen Browne" wrote:

The code prints its results to the Immediate Window.
Press Ctrl+G to open the Immediate Window.
Then in that window, enter:
? TableInfo("Table1")
to see the results for Table1.

It would be possible to re-write the code so that it writes its results into
a temporary table if you need to view it in a query, but this would require
some understanding of programmatically manipulating recordsets.

--
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.

"costpointconsultant" <costpointconsultant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message
news:981618F3-7A3D-43B4-B8CE-139D6AD9BB11@xxxxxxxxxxxxxxxx
I tried figuring out how to use the code referenced and I can't seem to
figure out what I need to do. I do a lot of query manipulation of linked
and
local tables, but am not proficient with many other areas of access like
forms, modules, reports. I created the function and referenced it in a
query
with a table input for one column and a second column with the function
and
the table i wanted to describe, and it gives me the error code if i type a
table that doesn't exist, so i know it's using the code, but i get a null
value in that cell. i realize there will be many rows returned to a table
that has multiple columns, but am not quite sure how to use this code to
get
a list for a table. I know it has a print statement, so i guess it must
print to somewhere. this will be valuable. more valuable would be to be
able to get rows in a result set or a table that have this info-so anyone
who
has some guidance on these two things to use this would be helpful. sorry
i'm such a greenhorn! thanks


"Allen Browne" wrote:

Access does expose the column names and their properties like that.

You can get them programmatically like this:
http://allenbrowne.com/func-06.html

"costpointconsultant" <costpointconsultant@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote
in message
news:FC11A57F-FB6A-4F34-8B06-D4572F2578D9@xxxxxxxxxxxxxxxx
I have a need to find information on the column names and properties
from
within the objects in the dbase. I have unhidden the system objects
(am
using access 2003) abd found msysobjects and other tables. I have
noted
objects like queries and tables, but don't see where I might find the
column
names and properties like length, field type, etc. In sql server this
info
is contained in information_schema.columns and oracle it's in
all_tab_columns
table. Is there a place in ms access to find this info dynamically?
Thank you


.

Relevant Pages

  • Re: need help creating criteria for time
    ... Allen Browne - Microsoft MVP. ... I then removed the criteria and left everything else and ran it ... Now let's verify that these date/time fields have *only* date or time, ... If you switch your query to SQL View (View menu, ...
    (microsoft.public.access.queries)
  • Re: a query to produce sales activity totals
    ... The query generates a row for each salesperson, ... Allen Browne - Microsoft MVP. ... of the sales process, including the number of sold and delivered vehicles. ... put these totals into a spread sheet that shows each salesperson's ...
    (microsoft.public.access.queries)
  • Re: Problem with Send Object
    ... Inserted into criteria of report query: ... How are you passing that filter string to the report, ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.formscoding)
  • Re: >> Current Items only
    ... I didn't get the bit about needing a UNION query. ... Allen Browne - Microsoft MVP. ... Assuming a RowSource like this: ... To do this I have the combobox recordsource listing all items. ...
    (microsoft.public.access.formscoding)
  • Re: Please help!
    ... From the 2nd row down to the last is the same duplicate ... Allen Browne - Microsoft MVP. ... In a query, depress the Total button on the Toolbar. ... Access adds a Total row to the grid. ...
    (microsoft.public.access.forms)