473,396 Members | 1,895 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Getting Type mismatch: '[string: ""]'

I'm getting this error for the last line of this code:

Expand|Select|Wrap|Line Numbers
  1. Dim ComKey
  2. Dim ComCode, SubComCode
  3. Dim SelectedCompanys
  4.  
  5. ComCode = rpt.Sections("Detail").Controls("COM_CompanyCode12").DataValue
  6.     SubComCode = rpt.Sections("Detail").Controls("SUBCOM_SubsidiaryCode12").DataValue
  7.  
  8.     ComKey = ComCode & "_"
  9.     If SubComCode <> "" Then
  10.         ComKey = ComKey & SubComCode & "_"
  11.     End If
  12.  
  13.     ' Totals were not being accumulated correctly by default, so must keep track of them manually
  14.     vars.StrVar(ComKey & "_GROUPTOT") = vars.StrVar(ComKey & "_GROUPTOT") + rpt.Sections("Detail").Controls("GLFormula1").DataValue
Aug 21 '14 #1
1 1162
twinnyfo
3,653 Expert Mod 2GB
cgoodwinjr,

Are you sure that "vars.StrVar(ComKey & "_GROUPTOT")" actually has a value in this expression?
Sep 8 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Laura | last post by:
Help. Below is my code. Getting Type mismatch error on the noted line. I'm trying to send an array (aryNewD) with 4 columns and x rows to a function to save all the array info into a SQL Server...
10
by: Mark Sargent | last post by:
Hi All, why am I getting this error..? Cheers. Mark Sargent. Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: ''
2
by: Tom Jordan | last post by:
Hi all, I've thrown together a simple shoppng cart and basket, but I occasionally get a type mismatch error on the basket. For example: Microsoft VBScript runtime error '800a000d' Type...
3
by: Snow | last post by:
Hello: I have Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: '' The error happened at this line: if session("systemIdCount" & arrSystems(iLoop)) 0 The code like this:
1
by: mstrjohn | last post by:
I am using access as the front end to a mysql database using linked tables. I have a table called dailytrx that has all the transactions, there are 2 fields that I am concerned with, a date and a...
1
by: FOREST GOLDEN | last post by:
i'M want to select multiple choice by using checkbox, but it come out the above mistake, plz help me solve it, thankx....... my ItemCode is using text eg:cg001 <%@ Language=VBScript %> <HTML>...
2
by: dstorms | last post by:
Hi, I am trying to write code that opens a form using data highlighted from a listbox, but I keep getting Type Mismatch errors. I finally ran a test code and still got the error message. Dim...
7
vikas251074
by: vikas251074 | last post by:
I am getting error above in following code since few days giving tension day and night. How can I solve this? I am facing since Oct.25. in line no. 362 After doing a lot of homework, I am...
3
by: kisho87 | last post by:
i have coded a username password program via using DAO control created a ms access 7.0 DB file and linked with data1 control and used 2 textbox controls for username and password. For login cmd...
4
by: samytee | last post by:
The following lines of code return error message Microsoft VBScript runtime error '800a000d' Type mismatch: 'FormatCurrency' /UnetER/sam_CCMSamEditRules_Bottom.asp, line 51 When users scrolled...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.