2 problems...Reports + shortcuts

[Phil]

How can i group a report so the data for each new week is on a new page?
Also..
When i place a shortcut for a macro or any other part of the database on my
desktop it fails to run or open.

Thanks

[Allen Browne]

Re: 2 problems...Repo rts + shortcuts

Not sure what's wrong with your shortcuts, but here's how to handle your
reports.

1. Open your report in design view.
2. Open the Sorting And Grouping box (View menu).
3. In this dialog, select the date field.
4. In the lower pane of the dialog, set:
Group Header Yes
Group On Week
5. Close the dialog
6. Right-click the new group header on your report (grey bar), and choose
Properties.
7. Set the Force New Page to "Before".

The report will now start a new page for each week.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil" <mrnw31666@blue .co.uk> wrote in message
news:Aoy7d.1212 $xb.597@text.ne ws.blueyonder.c o.uk...[color=blue]
> How can i group a report so the data for each new week is on a new page?
> Also..
> When i place a shortcut for a macro or any other part of the database on
> my
> desktop it fails to run or open.[/color]

[Phil]

Re: 2 problems...Repo rts + shortcuts

Report bit works good now,thanks. Had to tinker with it a little as it was
showing a blank 1st page. Thanks again
"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:415ebed7$0 $26028$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
> Not sure what's wrong with your shortcuts, but here's how to handle your
> reports.
>
> 1. Open your report in design view.
> 2. Open the Sorting And Grouping box (View menu).
> 3. In this dialog, select the date field.
> 4. In the lower pane of the dialog, set:
> Group Header Yes
> Group On Week
> 5. Close the dialog
> 6. Right-click the new group header on your report (grey bar), and choose
> Properties.
> 7. Set the Force New Page to "Before".
>
> The report will now start a new page for each week.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Phil" <mrnw31666@blue .co.uk> wrote in message
> news:Aoy7d.1212 $xb.597@text.ne ws.blueyonder.c o.uk...[color=green]
> > How can i group a report so the data for each new week is on a new page?
> > Also..
> > When i place a shortcut for a macro or any other part of the database on
> > my
> > desktop it fails to run or open.[/color]
>
>[/color]

[David Schofield]

Re: 2 problems...Repo rts + shortcuts

On Sat, 02 Oct 2004 13:52:32 GMT, "Phil" <mrnw31666@blue .co.uk> wrote:
[color=blue]
>When i place a shortcut for a macro or any other part of the database on my
>desktop it fails to run or open.
>
>Thanks
>
>[/color]
1. Does the db require a startup option, eg a workgroup file?
2. Check the security properties of the shell link (ie shortcut)
3. You can send the shortcut to notepad and check the path but this is
unlikely to be the problem.
David