Search an Access Database

R

RJP

Hi. I am new to FP 2003 and want to know how to do the following. I want to
create a search page using a textbox as my form to search through my
database. How can I accomplish this? Please respond to my email address if
possible. (e-mail address removed)
 
K

Kathleen Anderson [MVP - FrontPage]

RJP:
It's no bother - that's what we're here for :)

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True

If you don't see the _fpclass folder, go to Tools | Site Settings | Advanced
| Options - the checkbox for 'Show documents in hidden directories' needs to
be checked.


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

RJP

Hello. That helped....kinda. I am now experiencing a new error.
http://catalanooptics.com/invoice/Results/editor/search.asp

It tells me: Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
 
R

RJP

That helped....kind of. I now have a new error. It says: Database Results
Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

You can view it at:
http://catalanooptics.com/invoice/Results/editor/search.asp
 
K

Kathleen Anderson [MVP - FrontPage]

RJP:
Your page is trying to do a search as soon as it's loaded, before someone's
had a chance to input their search criteria. When I fill in all the search
fields, it works (at least, I don't get that error message - I get "No
records returned").

The way to resolve this is to give each search form field a default value
(it's done in the wizard).

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

RJP

Ok. I typed in part of a name in the name search box and nothing. However
the name is in the database. Therefore it is not searching my database. And
can you explain how to put a default value in each search form field?

Thanks
 
R

RJP

Ok. I entered default values of "0" and the error message went away. Now
when I try to conduct a search it finds nothing. The search page is in the
root. I checked the database and it contains the information. What should I
do?
 
R

RJP

Hello. It worked your way but I want it to do partial searches like
just putting in "kath" in the name box instead of the full name. And
also I would like to be able to maybe just enter text in one field
instead of them all for the search. How can I do this? Thanks so much
for your help.

RJP
 
R

RJP

Hello. Thanks to you I am now running perfectly. Everything is going
perfect. I just have one more question; its not that technical. If you go
to http://www.catalanooptics.com/drsearch.asp and type in "nava" in the name
box and hit search the results all come up in a long table. How can I split
the table so half of it appears and the other half appears below it. Kind
like this.

Key Name blah blah blah
2

blah blah blah
-2.5

Hope this isn't confusing. I just want to break the table. How can I do
this? Thanks for any help.


Kathleen Anderson said:
This KB article:
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430 will help you
with the SQL to do partial matches.

--

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



RJP said:
Hello. It worked your way but I want it to do partial searches like
just putting in "kath" in the name box instead of the full name. And
also I would like to be able to maybe just enter text in one field
instead of them all for the search. How can I do this? Thanks so
much
for your help.

RJP
Click to expand...
Click to expand...
 
K

Kathleen Anderson [MVP - FrontPage]

I don't think that's possible with the DRW. What you could do is chnage the
output to paragraphs and then rearrange the fields in Design View, so that
half are on one line and half are on another.

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



RJP said:
Hello. Thanks to you I am now running perfectly. Everything is going
perfect. I just have one more question; its not that technical. If
you go to http://www.catalanooptics.com/drsearch.asp and type in
"nava" in the name box and hit search the results all come up in a
long table. How can I split the table so half of it appears and the
other half appears below it. Kind like this.

Key Name blah blah blah
2

blah blah blah
-2.5

Hope this isn't confusing. I just want to break the table. How can
I do this? Thanks for any help.


Kathleen Anderson said:
This KB article:
http://support.microsoft.com/default.aspx?scid=kb;[LN];306430 will
help you with the SQL to do partial matches.

--

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



RJP said:
Hello. It worked your way but I want it to do partial searches like
just putting in "kath" in the name box instead of the full name.
And also I would like to be able to maybe just enter text in one
field instead of them all for the search. How can I do this?
Thanks so much
for your help.

RJP

:

Hi:
I logged in, verfied the database connection, did a search, added a
record, etc. Everything seems to be working OK.

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



I sent an e-mail to spiderwebwoman @mvps.org. Mine is
ronaldpalka@ optonline.net

:

I would have to be able to log into the site and look - it could
be anything. Email me off-line if you'd like - this address is
real.

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



Ok. I entered default values of "0" and the error message went
away. Now when I try to conduct a search it finds nothing. The
search page is in the root. I checked the database and it
contains the information. What should I do?

:

Default values are defined in the wizard; in the More Options |
Defaults section.

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



Ok. I typed in part of a name in the name search box and
nothing. However the name is in the database. Therefore it is
not
searching my database. And can you explain how to put a
default value in each search form field?

Thanks

:

RJP:
Your page is trying to do a search as soon as it's loaded,
before someone's had a chance to input their search criteria.
When I
fill in all the search fields, it works (at least, I don't
get that error message - I get "No records returned").

The way to resolve this is to give each search form field a
default value (it's done in the wizard).

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


That helped....kind of. I now have a new error. It says:
Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

You can view it at:
http://catalanooptics.com/invoice/Results/editor/search.asp

:

Hello. I am sorry to bother you but I am very new at this.
I created the search page, published and now receive an
error.
You can view the error message at
http://catalanooptics.com/invoice/Results/editor/search.asp.
What am I doing wrong? Please help.

RJP

:

Import the database into your web:
http://www.spiderwebwoman.com/tutorials/create_dbc.htm

Create a form to query your database and show the results:
http://frontpagehowto.com/asp/page00004.htm


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


Hi. I am new to FP 2003 and want to know how to do the
following. I want to create a search page using a textbox
as
my form to search through my database. How can I
accomplish this? Please respond to my email address if
possible. (e-mail address removed)
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Search Database 0
WORD VBA Search and switch to advanced ... 1
Have 4 email addresses Want to auto forward all in one of them 0
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
MS ACCESS: SEARCH in a split form 0
VBA Export to PDF 0
Need Help with Macro Security 1

Top