Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / September 2006

Tip: Looking for answers? Try searching our database.

List fields in a query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paco - 18 Sep 2006 20:03 GMT
I know there is a way to list the fields in a query, but I can't quite get
the code right. Can someone please post a way to do this?

Actually, what I am trying to do is check to see if a column exists in the
query.

Thanks.

Paco
Jeff Boyce - 18 Sep 2006 21:12 GMT
Paco

Where are you trying to create this list?

Have you looked at the Database Documentor?

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I know there is a way to list the fields in a query, but I can't quite get
> the code right. Can someone please post a way to do this?
[quoted text clipped - 5 lines]
>
> Paco
Paco - 18 Sep 2006 21:46 GMT
We're setting report filters against the report recordsource and I am writing
a generic piece of code to build the WHERE clause for the filter. If the
WHERE clause contains a field that is not in the recordsource query, it is
treated as a parameter. I want to skip adding a filter that may be selected
if that field is not in the recordsource query.

I'm doing this by using FOR NEXT to loop through all the fields in the
recordsource query to determine if the filter field exists in the query, but
I thought there might be a simpler way. Actually, the FOR NEXT loop is pretty
quick, so that may be the best solution.

Thanks.

Paco

> Paco
>
[quoted text clipped - 16 lines]
> >
> > Paco
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.