Re: Pass Parameters to Record Source Query

There may still be other ways...

You started defining the problem from inside and then positing limited
solutions. At the highest level, WHY are you trying to do this thing?
I won't play 20 questions but if you explain the motivating objective
before the means to a solution, maybe someone can help.

I wouldn't have posted back but it seems you're going to place some
information in global variables on the splash screen's module. That's
surely workable but the question is "How did you know in advance what
to place there"? And, still, what are you trying to do?

HTH
--
-Larry-
--

"NoVAFolk" <NoVAFolk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4796BA9D-AF10-4A70-A339-0A4EF940789B@xxxxxxxxxxxxxxxx
> Larry:
>
> Thank you. That was to be my next solution but I had hoped that
there was a
> viable solution that did not rely on using a form in the fashion you
> describe. The application has a "splash screen" that is closed after
five
> seconds. I will hide it instead and use that as my source.
>
> (Sure would have been nice if Access allowed a [Modules]! construct,
though!)
>
> "Larry Daugherty" wrote:
>
> > The answer to your question: Yes but there are caveats.
> >
> > Open the form hidden and only make it visible when you want to
see
> > it. Intercept the Close event to make it hidden instead, then
cancel
> > the close event. The risk is that you may not know what record is
> > exposed by the form.
> >
> > In situations like you describe, I run the report from the form.
No
> > need to hide the form, no ambiguities.
> >
> > HTH
> > --
> > -Larry-
> > --
> >
> > "NoVAFolk" <NoVAFolk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:E928EA63-B8E8-4F57-8CC0-E93BE13F8B04@xxxxxxxxxxxxxxxx
> > > I know that I can pass a variable's value to a query by using
the
> > following
> > > construct:
> > >
> > > ...
> > > WHERE [TableName].[ColumnName]=[Forms]![FormName].[ControlName]
> > > ...
> > >
> > > Is there any other method? The ideal would be a reference in the
> > form
> > > "[Modules]![ModuleName].[VariableName]"
> > >
> > > Some background: I have a meeting minutes report that lists
> > attendees in two
> > > parallel coulumns. The content of a column comes from a
subreport,
> > one for
> > > the left column and a similar one for the right column of names.
The
> > record
> > > source of a subreport is a query looks like this:
> > >
> > > SELECT LineNumber
> > > , MeetingKey
> > > , PersonKey
> > > , Division
> > > , Attended
> > > FROM AgendaReportInvitees
> > > WHERE LineNumber<[Forms]![frm_Meeting].[txtRightSide]
> > > ORDER BY LineNumber;
> > >
> > > My problem is that I want to be able to run this report even if
> > > "frm_Meeting" is closed. Obviously when I do that an error is
raised
> > because
> > > the field txtRightSide cannot be found.
> > >
> > > Any suggestions willingly entertained!
> > >
> >
> >
> >


.

Relevant Pages

  • Re: On Time Delivery Query
    ... Microsoft Access MVP ... The totals for each group should be done on the report footers, ... like ShipStatus. ...
    (microsoft.public.access.reports)
  • Re: counting based ona number of variables.
    ... The formula spreadsheet functions as a report. ... I need to adapt or create formula that will look for ... >> HTH ...
    (microsoft.public.excel.worksheet.functions)
  • Re: inputting criteria from a form
    ... Private Sub Report_Close ... i can print the report now. ... report opens, so that the date controls are available for referencing ...
    (microsoft.public.access.queries)
  • Re: Centering text vertically
    ... Report in the MDB you downloaded. ... > VerticallyCenter Me.txtStrategyName (field names were verified ... >> HTH ... >> Stephen Lebans ...
    (microsoft.public.access.reports)
  • Re: Weather disasters getting worse ??
    ... Oxfam blames global warming but that report also suggests that ... I suspect it's a combination of the two. ... for defining a 'weather disaster'? ...
    (uk.sci.weather)