How do I execute a specific MS Access query from FrontPage?

[Guest]

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 Anderson [MVP - FrontPage]]

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/

 

[Guest]

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]]

Answers inline.

--

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

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/resources/dbrwtipsandtricks.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/resources/dbrwtipsandtricks.asp

 

[Guest]

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]]

Yup, that works, too

--

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