Re: Selecting a report's sort order & sort fields at runtime

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 00:54:50 -0600

The qbf builds a dynamic query. You could add code that would select the
fields from the report. 

-- 
Duane Hookom
MS Access MVP
"Alp" <me@newsgroup.com> wrote in message 
news:%230Rq$dI8EHA.3908@TK2MSFTNGP12.phx.gbl...
> Hi Duane,
>
> Thank you for your message advising Allen's solution. I was actually going
> through your DH_qbf and wondering if I could incorporate that into my
> application to work with my report. I am also thinking of how to add 
> another
> option (Ascending/Descending) to your form which would help more. Then I
> will need to figure out a way to use the output as the record source for 
> the
> report. The frmQBFSource is very tempting (!) eventhough I do not need all
> that it offers at present.
>
> If I can manage to do so, then it will clearly end my headache. One 
> question
> though; would there be any potential problems in an mde?
>
> Alp
>
> "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
> news:O3$cmrD8EHA.3368@TK2MSFTNGP10.phx.gbl...
>> Allen Browne has a solution for this at
>> http://members.iinet.net.au/~allenbrowne/ser-33.html.
>>
>> -- 
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "Alp" <me@newsgroup.com> wrote in message
>> news:%23du91aC8EHA.1408@TK2MSFTNGP10.phx.gbl...
>> > Hi Experts,
>> >
>> > I would like to have opinions, advices or pointers on how to achieve 
>> > the
>> > subject matter. App is in A2K, the report has quite a few columns. 
>> > There
>> > are
>> > several fields that are/will be used for the sort order such as
> comp_name,
>> > reg_date, tot_items, comp_priority. The aim is, if possible, to give 
>> > the
>> > user the option to select which (or more that one) field the sort 
>> > should
>> > be
>> > on and Asc/Desc.
>> > This should be achievable via a form but just can't seem to focus where
> or
>> > how to start.
>> >
>> > Any help is much appreciated.
>> >
>> > Thanks in advance.
>> >
>> > Alp
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)
  • Re: Passing a value from a form to a Reports SQL stored procedure
    ... Duane Hookom wrote: ... MS Access MVP ... second page of my report ... Dim strVersionID As String ...
    (microsoft.public.access.reports)
  • Re: Timetable
    ... FieldName3 Datatype (display this one on time line) ... MS Access MVP ... I've been looking at your ship rotation report, and I've taken it apart to ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Timetable
    ... out on each of my e-forms. ... I have tried and managed to change the timeline on the report to weekly so I ... "Duane Hookom" wrote: ... MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Crosstab Report
    ... "Duane Hookom" wrote: ... MS Access MVP ... I try to write the report my headings/totals crash. ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)