How to do Event on Open of Report, Choice -Sort by Received Date o

  • Thread starter Thread starter dohernan
  • Start date Start date
D

dohernan

Hi, I have a report.

When someone opens it I want them to get the option to either Sort by Date
Received, or Sort by Last name.

Thanks.
 
The user is just going to the Reports folder and clicking on the Report, is
there some way to do it there, instead of having them go to the Forms section
first?

Thanks
 
dohernan,
Users shouldn't normally be given access to the database window. Kick your
development up a notch and use controls on forms for all user interaction.

IMO, parameter prompts, browsing the database window, and some other
behaviours aren't acceptable or very functional.
--
Duane Hookom
Microsoft Access MVP


dohernan said:
The user is just going to the Reports folder and clicking on the Report, is
there some way to do it there, instead of having them go to the Forms section
first?

Thanks
Click to expand...
 
Thanks again.

My particular unit is of 4 people, and we've been using Word, Excel, and
lots of paper to keep track of things.

I decided I wanted to put things in a database for range and ease of use,
and at the moment I am the main person using Access. Issue is, I've never
really used Access like this before, and I need to make everything easy
enough for the others to pick it up quickly, especially if I'm not around.
The idea of running everything via Forms and hiding the backend sounds good
to me.

At the moment I have a few different Queries/Reports that I run but they're
all separate pieces. I would love to get them all on a page together so that
folks can just choose what they want to run, put in Dates, etc. if necessary,
and go.
 
Back
Top