Error in ODBC using ASP with Access calculated field

Error in ODBC using ASP with Access calculated field

Post by Jo Lage » Thu, 23 Oct 2003 01:50:34


Hi all,

I have a BIG problem with maybe a too SMALL resolution ;-)

I have a Win2K server with a database in Access 2000, and
a query with a calculated field. That calculated field use
a function build in Module1 of access. The Query works
just fine.
The problem is, i use a ASP built in FrontPage 2000 to
display the query (Insert/Database/Results), but gives a
error:
"""""""""""""""""""""""""""""""""""""
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
Undefined function 'Add2' in expression.
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.

""""""""""""""""""""""""""""""""""""""

The Access Module function is "Add2".
If a clean the calculate field, the asp works fine.

Thankx for your help,
Jo Lages
 
 
 

1. DB2/400 ODBC time field to MS Access 2000 date/time field mapping error.

2. Using the result of a calculated field in another calculated field's expression

I am stuck on something that seems fairly straightforward but haven't
found a solution anywhere! I understand that calculated fields are
temporary and the data is not stored as such. But I figure the
calculation is done when another command requests the information.
However this does not seem to be the case here:

Test Total before VAT NIS: IIf([Currency]="GBP",[Exchange
rate]*(([Hourly rate]*([Hours]))+[Fixed price]),([Hourly
rate]*([Hours]))+[Fixed price])

Test Invoice Total NIS: [Test Total before VAT NIS]*([VAT rate]/100)

The second field has a calculation based on the first field. However
when I try to run it, I get the error "Enter Parameter Value: Test
Total before VAT NIS" and a field to enter the value. It seems to me as
though the second field is not asking the first for a value or that
they are being run in the wrong order. I am a real newbie so if I'm
being an idiot, please tell me!

(By the way, I realise the field names are less than optimal but for
now I'm just messing around)

Thanks in advance!

Paul

3. ODBC Error while accessing Access from ASP

4. Using Calculated Fields to Calculate other fields

5. Calculated field that uses another calculated field - possible?

6. Calculated field identifiers used in another calculated field

7. Using the result of a calculated field in another calculated field's expression

8. Using the result of a calculated field in another calculated field

9. MS Access Query using calculated field - Access ignores criteria.

10. Client Access ODBC/ASP fields not updating

11. MS Access Query using calculated field - Access ignores criter

12. asp page gets odbc access denied error

13. Viewing Custom Field in BCM Opportunity using MS Access ODBC and S

14. ODBC driver error using ASP

15. Access 97 using ODBC returning SQL server ntext fields dont return the full data