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 / Forms Programming / December 2005

Tip: Looking for answers? Try searching our database.

QUERY FORM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ftrujill0 - 05 Dec 2005 21:22 GMT
What is the best way to create a form that will allow users to search/query a
joined set of tables.  I would like to create a dynamic query that would
allow users basically the ability to write their own query by using a series
of drop down lists, which contain the table field names, operators,
conditions.  I am unable to allow the users to use the QBE so using access
gui is out of the question.

thanks.


KARL DEWEY - 05 Dec 2005 23:37 GMT
See my post to Freeda - many-to-many Relationship under Database Design.
What I passsed just might be what you want.

> What is the best way to create a form that will allow users to search/query a
> joined set of tables.  I would like to create a dynamic query that would
[quoted text clipped - 6 lines]
>
>  
 
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.