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 / Macros / May 2005

Tip: Looking for answers? Try searching our database.

Macro to Enter Criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan - 26 May 2005 20:36 GMT
I have a report I am trying to automate based on a query. The Criteria
Section states [Enter Area:] How do I get the Macro to enter "South East" by
default? Thanks in advance
Steve Schapel - 27 May 2005 00:50 GMT
Dan,

You can't.

Another approach, instead of using a Parameter Query, is to put an
unbound textbox on a form where you are running the report from, where
the user can enter the Area criteria.  You can set the Default Value
property for this textbox to "South East".  Then, in the query criteria,
in the place of the existing parameter prompt, you refer to the textbox
on the form, using syntax such as...
 [Forms]![NameOfForm]![NameOfTextbox]

Signature

Steve Schapel, Microsoft Access MVP

> I have a report I am trying to automate based on a query. The Criteria
> Section states [Enter Area:] How do I get the Macro to enter "South East" by
> default? Thanks in advance
 
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.