Zip Code Search

[Nicholas]

I set up an Excel file as a database to allow customers to
search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it shows the
following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

 

[Nicholas]

I post questions and then find my own answers.
You have to enter a default value when setting it up in
the Database Results Wizard, as opposed to setting an
initial value in the form field.
Wizard Step 3>More Options>Defaults

 

[Thomas A. Rowe]

Suggest that you import the Excel data into Access and use that on your site, as Access is a
multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Nicholas]

Meaning only one web user at a time could do this search?
This would be a major limitation, then.

Is there any easy way to convert Excel data to an Access
db without having Access??? Or would I be stuck doing a
Front Page data entry form and copy/paste 200 records?

-----Original Message-----
Suggest that you import the Excel data into Access and

use that on your site, as Access is a

multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I set up an Excel file as a database to allow customers to
search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it shows the
following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

.

 

[Thomas A. Rowe]

See inline below:

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Meaning only one web user at a time could do this search?
This would be a major limitation, then.

Not really, but the number of users would be less than using Access.

Is there any easy way to convert Excel data to an Access
db without having Access??? Or would I be stuck doing a
Front Page data entry form and copy/paste 200 records?

Send me an email with the spreadsheet attached and I will convert for you, as you do have to have
Access or know ASP well enough to import the data via scripting to Access database that FP can
create for you.

-----Original Message-----
Suggest that you import the Excel data into Access and

use that on your site, as Access is a

multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I set up an Excel file as a database to allow customers to
search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it shows the
following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

.

 

[Andrew Murray]

yes, you can use excel files as your data source in an access database.

You can import the xls file into the access database table.

Meaning only one web user at a time could do this search?
This would be a major limitation, then.

Is there any easy way to convert Excel data to an Access
db without having Access??? Or would I be stuck doing a
Front Page data entry form and copy/paste 200 records?

-----Original Message-----
Suggest that you import the Excel data into Access and

use that on your site, as Access is a

multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I set up an Excel file as a database to allow customers to
search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it shows the
following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

.

 

[Thomas A. Rowe]

However the Nicholas doesn't have Access.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

yes, you can use excel files as your data source in an access database.

You can import the xls file into the access database table.

Meaning only one web user at a time could do this search?
This would be a major limitation, then.

Is there any easy way to convert Excel data to an Access
db without having Access??? Or would I be stuck doing a
Front Page data entry form and copy/paste 200 records?

-----Original Message-----
Suggest that you import the Excel data into Access and

use that on your site, as Access is a

multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

I set up an Excel file as a database to allow customers to
search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it shows the
following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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


.

 

[Nicholas]

Thanks but no thanks. This list changes frequently. I'm
just going to have to get Access, enlist someone who has
it, go to Kinko's or use Excel. There won't be many people
trying to hit this file at once.

I do genuinely thank you for the offer. It's nice to know
there are helpful people out there.

-----Original Message-----
See inline below:

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp



Not really, but the number of users would be less than using Access.


Send me an email with the spreadsheet attached and I will

convert for you, as you do have to have

Access or know ASP well enough to import the data via

scripting to Access database that FP can

create for you.

-----Original Message-----
Suggest that you import the Excel data into Access and

use that on your site, as Access is a

multi-user product whereas Excel is a single user product.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Nicholas" <[email protected]> wrote

in
message

I set up an Excel file as a database to allow

customers
to

search for businesses by zip code.
It works superbly and I am now amazed at how easy it was.
However, when you first pull up the .asp page it

shows
the

following error. How to get rid of this...? Putting an
initial value in the search field makes no difference.

Database Results Error
Description: [Microsoft][ODBC Excel Driver] Extra ) in
query expression '(Zip = )'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

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


.

.