I am using MS Access 2003 and FrontPage 2003. I want to execute a specific
query and show the resutls using the Database Resutls Wizzard (DRW). -- Paul

When you start the Database Results Wizard, one of the first things it asks
you to do is select your record source from a dropdown. In that dropdown
should be your Access Query, also known as a View.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"sandrocket" <(E-Mail Removed)> wrote in message
news:57CD6AD2-A89A-4580-A40F-(E-Mail Removed)...
>I am using MS Access 2003 and FrontPage 2003. I want to execute a specific
> query and show the resutls using the Database Resutls Wizzard (DRW). --
> Paul
>

Thank you Kathleen, that is so simple, I will try it.
1) I suppose Macros are the same?
2) Also, which command do I use in the marco to execute a query?
3)And, do you know how I can make that ugly yellow DRW panel not appear when
I bring up a IE web page that does not yet have a parameter? It is the panel
that requires a parameter to be entered but because it just came up, there is
no parameter and it shows the database results wording with an error. When I
do enter a parameter, it looks perfect. Maybe another way to ask the
question would be how do I provide a default value so the DRW error msg ugly
yellow will not appear? Sorry to ask so many questions but you appear to be
very knowledgable.

"Kathleen Anderson [MVP - FrontPage]" wrote:

> When you start the Database Results Wizard, one of the first things it asks
> you to do is select your record source from a dropdown. In that dropdown
> should be your Access Query, also known as a View.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "sandrocket" <(E-Mail Removed)> wrote in message
> news:57CD6AD2-A89A-4580-A40F-(E-Mail Removed)...
> >I am using MS Access 2003 and FrontPage 2003. I want to execute a specific
> > query and show the resutls using the Database Resutls Wizzard (DRW). --
> > Paul
> >
>
>
>

Answers inline.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"sandrocket" <(E-Mail Removed)> wrote in message
news:5DD6FEB8-707F-4E90-B380-(E-Mail Removed)...
> Thank you Kathleen, that is so simple, I will try it.

> 1) I suppose Macros are the same?

You can only use Tables and Queries as Record Sources in the DBRW.

> 2) Also, which command do I use in the marco to execute a query?

See 1)

> 3)And, do you know how I can make that ugly yellow DRW panel not appear
> when
> I bring up a IE web page that does not yet have a parameter?

Here's one way - How to prevent DBRW from returning results before searching
http://www.spiderwebwoman.com/resour...cks.asp#return


It is the panel
> that requires a parameter to be entered but because it just came up, there
> is
> no parameter and it shows the database results wording with an error.
> When I
> do enter a parameter, it looks perfect. Maybe another way to ask the
> question would be how do I provide a default value so the DRW error msg
> ugly
> yellow will not appear? Sorry to ask so many questions but you appear to
> be
> very knowledgable.

Some of the other FrontPage MVPs call me the Database Wizard Queen :-)
Here's a link you may want to add to your favorites:
http://www.spiderwebwoman.com/resour...sandtricks.asp

>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> When you start the Database Results Wizard, one of the first things it
>> asks
>> you to do is select your record source from a dropdown. In that dropdown
>> should be your Access Query, also known as a View.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>> "sandrocket" <(E-Mail Removed)> wrote in message
>> news:57CD6AD2-A89A-4580-A40F-(E-Mail Removed)...
>> >I am using MS Access 2003 and FrontPage 2003. I want to execute a
>> >specific
>> > query and show the resutls using the Database Resutls Wizzard (DRW). --
>> > Paul
>> >
>>
>>
>>

Kathleen, I found the answer for the UGLY Yellow and dreaded no default for
parameter. Solution: on the panel where you enter the Criteria and Sorting
order, there is also a "Default" button. Pick it and enter some default and
the Ugly Yellow is gone ! -- Paul

"Kathleen Anderson [MVP - FrontPage]" wrote:

> Answers inline.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "sandrocket" <(E-Mail Removed)> wrote in message
> news:5DD6FEB8-707F-4E90-B380-(E-Mail Removed)...
> > Thank you Kathleen, that is so simple, I will try it.
>
> > 1) I suppose Macros are the same?
>
> You can only use Tables and Queries as Record Sources in the DBRW.
>
> > 2) Also, which command do I use in the marco to execute a query?
>
> See 1)
>
> > 3)And, do you know how I can make that ugly yellow DRW panel not appear
> > when
> > I bring up a IE web page that does not yet have a parameter?
>
> Here's one way - How to prevent DBRW from returning results before searching
> http://www.spiderwebwoman.com/resour...cks.asp#return
>
>
> It is the panel
> > that requires a parameter to be entered but because it just came up, there
> > is
> > no parameter and it shows the database results wording with an error.
> > When I
> > do enter a parameter, it looks perfect. Maybe another way to ask the
> > question would be how do I provide a default value so the DRW error msg
> > ugly
> > yellow will not appear? Sorry to ask so many questions but you appear to
> > be
> > very knowledgable.
>
> Some of the other FrontPage MVPs call me the Database Wizard Queen :-)
> Here's a link you may want to add to your favorites:
> http://www.spiderwebwoman.com/resour...sandtricks.asp
>
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> When you start the Database Results Wizard, one of the first things it
> >> asks
> >> you to do is select your record source from a dropdown. In that dropdown
> >> should be your Access Query, also known as a View.
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web: http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> "sandrocket" <(E-Mail Removed)> wrote in message
> >> news:57CD6AD2-A89A-4580-A40F-(E-Mail Removed)...
> >> >I am using MS Access 2003 and FrontPage 2003. I want to execute a
> >> >specific
> >> > query and show the resutls using the Database Resutls Wizzard (DRW). --
> >> > Paul
> >> >
> >>
> >>
> >>
>
>
>

Yup, that works, too :-)

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"sandrocket" <(E-Mail Removed)> wrote in message
news:914B6B1D-EF14-44C4-9DF9-(E-Mail Removed)...
> Kathleen, I found the answer for the UGLY Yellow and dreaded no default
> for
> parameter. Solution: on the panel where you enter the Criteria and
> Sorting
> order, there is also a "Default" button. Pick it and enter some default
> and
> the Ugly Yellow is gone ! -- Paul
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> Answers inline.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>> "sandrocket" <(E-Mail Removed)> wrote in message
>> news:5DD6FEB8-707F-4E90-B380-(E-Mail Removed)...
>> > Thank you Kathleen, that is so simple, I will try it.
>>
>> > 1) I suppose Macros are the same?
>>
>> You can only use Tables and Queries as Record Sources in the DBRW.
>>
>> > 2) Also, which command do I use in the marco to execute a query?
>>
>> See 1)
>>
>> > 3)And, do you know how I can make that ugly yellow DRW panel not appear
>> > when
>> > I bring up a IE web page that does not yet have a parameter?
>>
>> Here's one way - How to prevent DBRW from returning results before
>> searching
>> http://www.spiderwebwoman.com/resour...cks.asp#return
>>
>>
>> It is the panel
>> > that requires a parameter to be entered but because it just came up,
>> > there
>> > is
>> > no parameter and it shows the database results wording with an error.
>> > When I
>> > do enter a parameter, it looks perfect. Maybe another way to ask the
>> > question would be how do I provide a default value so the DRW error msg
>> > ugly
>> > yellow will not appear? Sorry to ask so many questions but you appear
>> > to
>> > be
>> > very knowledgable.
>>
>> Some of the other FrontPage MVPs call me the Database Wizard Queen :-)
>> Here's a link you may want to add to your favorites:
>> http://www.spiderwebwoman.com/resour...sandtricks.asp
>>
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> >> When you start the Database Results Wizard, one of the first things it
>> >> asks
>> >> you to do is select your record source from a dropdown. In that
>> >> dropdown
>> >> should be your Access Query, also known as a View.
>> >>
>> >> --
>> >>
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> web: http://www.spiderwebwoman.com/resources/
>> >>
>> >>
>> >> "sandrocket" <(E-Mail Removed)> wrote in message
>> >> news:57CD6AD2-A89A-4580-A40F-(E-Mail Removed)...
>> >> >I am using MS Access 2003 and FrontPage 2003. I want to execute a
>> >> >specific
>> >> > query and show the resutls using the Database Resutls Wizzard
>> >> > (DRW). --
>> >> > Paul
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>