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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
 
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.
 
Answers inline.

--

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


sandrocket said:
Thank you Kathleen, that is so simple, I will try it.
Click to expand...
1) I suppose Macros are the same?
Click to expand...

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?
Click to expand...

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?
Click to expand...

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.
Click to expand...

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
 
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
 
Back
Top