#Name? error in spreadsheet.

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

Guest

For Frontpage 2000: I'm trying to retrieve values entered by a user into a
form (text boxes and drop downs) and use this information in a spreadsheet on
the same page. The fields of the form are layed out within a table to
facilitate alignment.

I have a textbox named txbTestData. In the spreadsheet I've entered this
exact formula: =document.txbTestData.value and the spreadsheet returns
the error #Name?. I've tried the formula: =document.txbtestdata.value
with the same #Name? result. The web has been published to a site that runs
Frontpage extensions. The form in all other ways works properly.

What am I doing incorrectly?
 
You must use ASP/VBscript to access the spreadsheet, however it is better to use an Access database
instead of Excel. See FP database components.

You site must be hosted on a Windows IIS web server.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
While I agree that would be the preferred method, my efforts are focused on
fast-tracking a prototype website. Once I have approval for the project, I
will hand this off to developers that will likely take your approach.

In the mean time, the help file for FP2000 says that I can use the formula
as I've entered. Several days ago, this function worked properly, but
something I've done has changed the spreadsheets ability to recognize the
reference (either document or textbox name). Any thoughts, since I really
don't have time to learn ASP/VB scripting?
 
I only know how to access it using ASP/VBscript from within a web site.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
O.K. If I save the results of the form to a database, manipulate the data
within a query, and return the results using the results wizard,...

Is there a way (without an extensive scripting background) to send the
returned data from the query via email?

Bottom line, I need to take user data from a form, perform some calculations
on it, and then email all of the field names and values (including some
calculated values) to a Blackberry (assuming RIM is going to survive). Is it
possible?
 
It is possible, but you will need to know how to code via ASP/VBScript or ASP.Net, etc. as you will
not find anything already written.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top