Re: how can I show query results as a subform !!!

Thank you very much !!! it is done already..

Tom van Stiphout wrote:
On 1 Aug 2006 05:52:55 -0700, savas_karaduman@xxxxxxxxx wrote:

Yes. Create the subform and bind it to the query.
Upon button click, set the OrderBy property of the subform to the
value of the textbox, and set OrderByOn property to True.
with Me.mysubform.Form
.OrderBy = txtSortCriteria
.OrderByOn = True
end with

-Tom.


There is a form
There is a text box on that form
There is a button on the same form

there is a seperate query

Sort criteria going to be entered by text box.
Button is going to execute event
A subform will show query results on that form

EASY ??

.

Relevant Pages

  • Re: design: single or multiple queries
    ... same query by varying the selection conditions and sort order. ... or move to MySQL or SQL Server. ... How does the query OrderBy property relate to the Sort specs shown ...
    (microsoft.public.access.queries)
  • Re: how can I show query results as a subform !!!
    ... Create the subform and bind it to the query. ... set the OrderBy property of the subform to the ... value of the textbox, and set OrderByOn property to True. ...
    (comp.databases.ms-access)
  • Re: total number of records
    ... orderby property to the form and this forced it to count the records as the ... I realize the form could have been based on a query, ... > Free Access downloads: ... >> like to add custom navigation instead of the default navigation buttons. ...
    (microsoft.public.access.forms)
  • Re: User choosing sort/group order at query runtime
    ... The simplest way to do this is just to set the OrderBy property of your form ... > hadexamples of how to pass sorting and grouping to a query at runtime, ... > all the pages were dead links. ... > 2000 (other than making a separate query with the sort/group set different ...
    (microsoft.public.access.queries)
  • Re: Record Order?
    ... back and changed the query. ... Then rebuilt the subform. ... > Scott Viney wrote: ... a Form's OrderBy property is useless unless you also set the ...
    (microsoft.public.access.gettingstarted)