find all fields with the same name

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

From: Jim Tanis <JimTanis@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 15 Apr 2005 03:46:04 -0700

I have a set of tables that each has a field named 'dued', data type = date.

I want to find a way to search all records, in all tables that have a field
named 'dued' and compare it to system date.

I guess that is done using a for ... next loop but how do I retrieve the
values??? maybe defining a temp table and copying field values????

Please help!!!

PS I am not very familiar with all that ADO, DAO, etc..
.

Follow-Ups:
- Re: find all fields with the same name
  - From: Nikos Yannacopoulos

Prev by Date: How to accelerate query processing?
Next by Date: Preventing program from running at a certian date
Previous by thread: How to accelerate query processing?
Next by thread: Re: find all fields with the same name
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO or DAO
... like using ADO. ... One reason could be data type mapping. ... consequently DAO cannot differentiate between SQL ... data types (dbComplexInteger, dbComplexDecimal, etc) which is absent ...
(microsoft.public.access.modulesdaovba)
Re: Problem with decimal number smaller than 1
... I then queried the data using DAO and, sure enough, the value was ... I looked at the underlying data type e.g. in the ... change the column's datatype or use ADO. ... > Sub SqlConnect() ...
(microsoft.public.excel.programming)
class module & continuous forms
... using but its ADO and I use DAO so it's a challenge for me...I've ... Is it possible to use the class I've created to fill a continuous form? ... Prev by Date: ...
(comp.databases.ms-access)
Re: Creating Queries in DAO vs ADOX
... lylefair wrote: ... >I have programmed very extensively in DAO, ... >I have programmed very extensively in ADO and I continue to do so. ... Prev by Date: ...
(comp.databases.ms-access)
Re: Creating Queries in DAO vs ADOX
... >I have programmed very extensively in DAO, ... >I have programmed very extensively in ADO and I continue to do so. ... Greg Strong ... Prev by Date: ...
(comp.databases.ms-access)