Re: Select Sort Order Through a Form

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Duane,

1 = sort by FileName
2 = sort by FileNumber
3 = sort by DateOpened

Thanks again,
Kathy

"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
news:ulIe9dTIGHA.668@xxxxxxxxxxxxxxxxxxxxxxx
> What are the values in your combo box and what field do these values
> correspond with?
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
> news:OZvBf.2813$Dk.751@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> I'm sorry but that doesn't help me. Perhaps it is too advanced for me.
>> :-(
>> Can you, or anyone else, be more specific?
>> Thank you
>>
>> "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
>> news:eX1aPPJIGHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
>>> You might want to check the tip on Allen Browne's site
>>> http://allenbrowne.com/ser-33.html.
>>>
>>> --
>>> Duane Hookom
>>> MS Access MVP
>>> --
>>>
>>> "Kathy Webster" <slickdock@xxxxxxxxx> wrote in message
>>> news:mgdBf.2504$Dk.745@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>> In an MDE database where users don't have rights to edit the report
>>>> design, I would like the user to be able to select the sort order of a
>>>> report in a combo box on a form.
>>>> How would I tell the report that the sort order is, for example, equal
>>>> to [forms]![reportselector]![sortorder] ?
>>>>
>>>> Thanks in advance,
>>>> Kathy
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Tables auto-sorting after setup?
    ... etc. and I certainly didn't intend to sort it that way. ... that I may be hitting on accident? ... "Duane Hookom" wrote: ... MS Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: How do set up a report in Access to track monthly spending?
    ... the criteria or the sorting? ... >> Don't sort on the text month. ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Query doesnt always sort
    ... My table doesn't have a primary key. ... How do I impose a sort on the datasheet view? ... using a query or in Access imposing a sort order on the datasheet view. ... Access MVP 2002-2005, 2007 ...
    (microsoft.public.access.queries)
  • Re: Query doesnt always sort
    ... using a query or in Access imposing a sort order on the datasheet view. ... primary key in the table, then Access will show the records in primary key ... Access MVP 2002-2005, 2007 ...
    (microsoft.public.access.queries)
  • Re: Select Sort Order Through a Form
    ... Duane Hookom ... MS Access MVP ... the report object or the report name as an argument. ... = sort by FileNumber ...
    (microsoft.public.access.reports)