Greetings, Looks like you creating a counter .
To fix your problem, put
F("ITEMDONE")=0
Somewhere in your script before the addition starts.
Flags (the F("ITEMDONE") is a flag, are a variant datatype - meaning it becomes
whatever it's set to.
VB doesn't allow math against something unless it is a number - that's the
Type Mismatch error - it's datatype doesn't match with the action you are
attempting to perform (math).
So setting the counter to 0 "makes" it a number - and then allows math to
performed.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Sign up for my weekly webinar!
<http://www.bostonworkstation.com/customer_center/special_events.aspx>
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to this
E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [email protected] [mailto:[email protected]]
Sent: Friday, August 21, 2009 10:38 AM
To: Talk
Subject: [talkbws] RE: Run-time error '13': Type Mismatch
If it is declared as a string it will give you that error. You could either
change the type to integer. Or try putting a Val(F("ITEMDONE")) + 1. This is
not the most correct way to work around it, but would be a quick test to see if
it works.
From: [email protected] [mailto:[email protected]]
Sent: Friday, August 21, 2009 10:30 AM
To: [email protected]
Subject: [talkbws] Run-time error '13': Type Mismatch
Can anyone tell me why this:
F("ITEMDONE") = F("ITEMDONE") + 1
Would give me this:
Thank you,
Mitch Lawrence
Lead Applications Analyst
Technical Support - NPR/Automation
CHRISTUS Information Management
: [email protected]
<mailto:[email protected]>
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
________________________________
"CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. The information is intended
only for the use of the individual(s) or entity to whom it is addressed. Any
disclosure, distribution, copying or use of the information by others is
strictly prohibited. Please delete it from your files if you are not the
intended recipient. Thank you for your compliance"
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
<<image001.jpg>>
<<image002.jpg>>
