Passing parameter from text field in vb6 to crystal report 8.5

Posted on 2009-05-10
Medium Priority
Last Modified: 2012-05-06
Dear Experts,
I have a report generated to create invoices. I need to take in parameters from text fields in vb6 to that report. I encountered a problem when I try to pass the value in a text field containing the prices for the items. I set up the fields in crystal to be currency but whenever i pass the value of my text field in my vb6, it will come up with strange values. (eg, when the value of my text box is 100,000, crystal will only show 100,00). I tried passing my textbox value using
val(textbox.text) in vb6 but if i use this, crystal won't accept it. Any ideas experts?

thank you...
btw, im using CR8.5
Question by:Slythie
1 Comment

Accepted Solution

nirojexpert earned 375 total points
ID: 24351378
canyou try to send without any formatting for the number. can you also try declaring the variable as single/double and then pass the varaible.
also verify that the datatype supports the precision level. maybe you defined the database field as number(4) and you are trying to pass a value that is number(5).

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question