PC Review


Reply
Thread Tools Rate Thread

Access 2007 Query

 
 
M Joseph
Guest
Posts: n/a
 
      1st Jan 2010
I have a query that uses wild cards, what and parameter query box to ask for user input and then shows a report later on.

what I want to do is create a form that override the parameter query box and instead through the form user can input for example name or number and click a button to show the report.

how can I do it?

Thanks in advance.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET with Examples in VB.NET
http://www.eggheadcafe.com/tutorials...t-with-ex.aspx
 
Reply With Quote
 
 
 
 
John W. Vinson
Guest
Posts: n/a
 
      1st Jan 2010
On Fri, 01 Jan 2010 12:10:29 -0800, M Joseph wrote:

>I have a query that uses wild cards, what and parameter query box to ask for user input and then shows a report later on.
>
>what I want to do is create a form that override the parameter query box and instead through the form user can input for example name or number and click a button to show the report.
>
>how can I do it?


Use a parameter query with

=[Forms]![NameOfYourForm]![NameOfTheTextbox] & "*"

as a criterion if you want to return records starting with the text string
entered by the user; use

="*" & [Forms]![NameOfYourForm]![NameOfTheTextbox] & "*"

if you want to find a record with the user's string anywhere within the field.
--

John W. Vinson [MVP]

 
Reply With Quote
 
Clement Gulston
Guest
Posts: n/a
 
      1st Jan 2010

"M Joseph" wrote in message news:(E-Mail Removed)...
>I have a query that uses wild cards, what and parameter query box to ask
>for user input and then shows a report later on.
>
> what I want to do is create a form that override the parameter query box
> and instead through the form user can input for example name or number and
> click a button to show the report.
>
> how can I do it?
>
> Thanks in advance.
>
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Essential ASP.NET with Examples in VB.NET
> http://www.eggheadcafe.com/tutorials...t-with-ex.aspx
>thank you for that infomation that linked your query


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 Neurogenesis Microsoft Excel Discussion 6 12th May 2011 11:25 AM
Exporting Query from Access 2007 to Excel 2007 AMW0830 Microsoft Access 4 7th May 2010 05:02 PM
With a Query in Access 2007, How can I Create This Query Terry Microsoft Access 3 29th Apr 2010 05:43 PM
Excel 2007 Connectivity to Access 2007 Query Beamer Microsoft Excel Discussion 1 17th Jul 2009 06:32 PM
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Microsoft Excel Misc 0 4th Dec 2008 05:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 PM.