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 / Database Design / August 2004

Tip: Looking for answers? Try searching our database.

How do you ask for input from the user to filter out just those r.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
yackoooligan - 17 Aug 2004 13:25 GMT
How do you put in a query or on a switchboard requesting input from the user.
This input filters out just those records and puts them into a report.  The
example is I want items from a certian date.    I want only items with the
specific dates specified with input from the user to be shown on a report.  
If anyone can help me it would be appreciated.  Thanks a ton.

Yackoooligan
Rick B - 17 Aug 2004 15:30 GMT
In the query (upon which your report is based) you need to specify the
desired dates.

For example, if you have a "date created" field on your report and you want
to see all records after a given date, you'd add the "date created" field to
the query.  In the criteria field youd put something like...

> [EnterStartDate]

This would prompt the user to enter a date and the querry would find records
where the date was greater than that entered by your user.

Post back with specifics if you need more help.  Include things like the
names of your fields, and what criteria you wish to use.

rick b

How do you put in a query or on a switchboard requesting input from the
user.
This input filters out just those records and puts them into a report.  The
example is I want items from a certian date.    I want only items with the
specific dates specified with input from the user to be shown on a report.
If anyone can help me it would be appreciated.  Thanks a ton.

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