Re: Date range on reports

I don't see anything in your macro that asks for a date range. If you don't
tell us how the dates are being requested, we can't tell you how to put the
values in your report.

--
Duane Hookom
MS Access MVP
--

"Mark_Milly" <MarkMilly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FDA4871-7306-4619-9431-AFC5F655763C@xxxxxxxxxxxxxxxx
> the macro is as below;
>
> Macro Name Condition
> Action
> Open Dialog
> Openform
> OK
> SetValue
> Not IsLoaded("Salaes Manger Monthly Report")
> CANCEL
> Close
> Close Dialog
> Close
>
> CamcelEvent
>
> any help would be great.
>
> Cheers Mark
>
> "Duane Hookom" wrote:
>
>> Would you mind sharing some information about your macro? If you want
>> assistance, you need to provide enough information to allow someone to
>> provide help.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Mark_Milly" <MarkMilly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:01AC05F6-8EF0-428D-A3B9-6F3D1134CEC1@xxxxxxxxxxxxxxxx
>> > Sorry Al,
>> >
>> > I meant "macros", i have created a macro to ask for a date range and
>> > need
>> > this date range to show on my report.
>> >
>> > Sorry for any confusion
>> >
>> > Cheers Mark
>> >
>> > "Al Camp" wrote:
>> >
>> >> Mark,
>> >> Not sure what you mean by "popups."
>> >> Do you mean you created a parameter query, and two "Input Boxes"
>> >> come
>> >> up
>> >> to prompt the user for a StartDate and EndDate?
>> >>
>> >> If that's so, then you probably have two parameters in the query
>> >> behind
>> >> your report.
>> >> Something like...
>> >> Between [Enter Starting Date] and [Enter Ending Date]
>> >> Given that example, an unbound text control on the report with a
>> >> Control
>> >> Source of...
>> >> = "From " & [Enter Starting Date] & " to " & [Enter Ending
>> >> Date]
>> >> would yield the "date subtitle" your looking for in your header.
>> >> --
>> >> hth
>> >> Al Camp
>> >> Candia Computer Consulting - Candia NH
>> >> http://home.comcast.net/~cccsolutions
>> >>
>> >>
>> >> "Mark_Milly" <MarkMilly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:90655C4C-F7C3-435D-B3C8-50490A0C389F@xxxxxxxxxxxxxxxx
>> >> > Hi Guys,
>> >> >
>> >> > I have created a report for monthly sales with popups to enter the
>> >> > date
>> >> > range. How can I show the date range on the header of the report?
>> >> >
>> >> > If anyone can help it would be greatly appreiciated.
>> >> >
>> >> > Cheers Mark
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: macro in a query?
    ... query contains only one "SET". ... MS Access MVP ... i know that i could also just trigger the macro to run the query and then ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)
  • Re: Date range on reports
    ... "Duane Hookom" wrote: ... > Would you mind sharing some information about your macro? ... >> this date range to show on my report. ... >> Cheers Mark ...
    (microsoft.public.access.reports)
  • Re: backup
    ... Mark, here is one way, from a post by Gord Didden ... The macro could be run manually or in beforesave code in ThisWorkbook. ... 'Saves the current file to a backup folder and the default folder ...
    (microsoft.public.excel.newusers)
  • Re: Messages Box
    ... Is there a form or code or macro or anything else involved in this? ... Duane Hookom ... MS Access MVP ... I have a search set up to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Refresh SQL database links in Access
    ... I can't image trying to do this with a macro. ... Duane Hookom ... MS Access MVP ... "Beatrice" wrote in message ...
    (microsoft.public.access.modulesdaovba)