Runtime when usin Win98

[DD]

I am testing a software with Wise Installer on Win 98
In a field i recieve this error #
I do not recieve this error in this field when i test on Win2k or xp
the calculation is as follows

(Val(DSum("bankedPayment","qryReconciliation","[tblPayments.sequence]<="""
& [tblPayments.sequence] & """")))

Can any one advise if the above has something in it that win98 does
not like

I have tried adding a new field and rewriting the code,,but stil no
luck

Also this is tested on a clean system.

any ideas would be great

dd

[Tony Toews]

da**********@bigpond.com.au (DD) wrote:

I am testing a software with Wise Installer on Win 98

What version of Access?

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.

For a very detailed page on reference problems see
http://members.rogers.com/douglas.j....nceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

The Access 2002 default references when the MDB is created in Access
2000 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library.

The Access 2003 default references when the MDB is in A2000 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library

The Access 2003 default references when the MDB is in A2002/A2003 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[David Deacon]

Hi Tony

I have checked the references and the are ok

Iam using XP DEVELOPER

All the underlying qureies relating to the field are working and showing
no errors
the error ony appears in the subForm
as #Error
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Michael \(michka\) Kaplan [MS]]

XP Developer cannot run properly on Win98.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"David Deacon" <da**********@bigpond.com.au> wrote in message
news:41**********************@news.newsgroups.ws.. .

Hi Tony

I have checked the references and the are ok

Iam using XP DEVELOPER

All the underlying qureies relating to the field are working and showing
no errors
the error ony appears in the subForm
as #Error
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!