Recent content by svm

sorry im new to reporting services ....im trying to count only code = 1 how do you do that ? Part No 7100001 Block Full a Canyon Ledge Gray 10012913003 1 10020113003 1 10020513003 1 10020813003 1 10021212003 1 10021413003 1 10021913003 1 291436001 0 I used this expression but it is...

sorry im new to reporting services ....im trying to count only code = 1 how do you do that ? Part No 7100001 Block Full a Canyon Ledge Gray 10012913003 1...

When I run it, I'm getting a message "Invalid TLV Record".

When it does the OpenRpt.

I have a code below and was running when we were using Crystal Report 8. However when we change to Crystal 9, it won't work anymore. Can you tell me why. Thanks. Option Explicit Dim Crep As String Dim CApp As New CRAXDRT.Application Dim CReport As New CRAXDRT.Report Private Sub...

I have two Date variable Fields defined as Nvarchar in SQL database. What I want is to calculate the difference between the two datefields. My first datefield in Table 1 is Project.ActSignDate and the second datefield in Table 2 is Project.DelDate. In coding, how do you do this ?

Hi. I Have a database table defined in SQL and one of the fields is defined as 500 nvarchar long. Now, when I was entering data in my program in VB6, the data seems to be saved in that field. The only problem is when it shows up on the screen, it won't display the whole data, somehow it is...

This is only one time deal. It happens when we are converting the access data to SQL and we failed to convert one column because the SQL Table wasn't defined properly. I just need to know how you are going to update the one field in SQL and get that data from access table. Thanks.

I have an SQL Database Table right now and only one field/column should be updated. The column name is TimeChecking. I need to update this column with a column in Access called Timechecking too. What do you do to update the field. Appreciate any help you can give. thanks.

I have a program that needs to browse the drive and directory and also select a Word Document Filename but I don't know how to insert a command in order to retrieve Word Document. Can anyone finish my coding ? Appreciate to any help you can give me. Thanks. Private Sub Command1_Click()...

Hi. I have a VB Program that displays excel spreadsheet only the first time but if you close this file and open another spreadsheet file, it won't display data. What's wrong. Appreciate to any help you can give me. Thanks. Form : Option Explicit Private Sub Command1_Click()...

Hi. I am working on creating a Log-On Screen that pops up when a button is pressed from another screen. I have to check when I am entering User Id and password if it is in the table (tblUSerID with fields : ID, UserName & Password). If UserID is found and password is correctly entered...

Hi, I have an application programmed using VB and one of the options in the menu is printing reports done using Crystal. after creating an exe file and run the program I am getting an error pdsodbc.dll not installed. I tried copy ing this dll file to c:Winnnt\System32 but it doesn't help...

Hi. I have txtfields1.Text and txtfields2.Text defined. Txtfields1.Text refers to month and txtfields2.Text refers to Year(yy). How do I connect the two values to output only as one in table or file fieldname : BIDDATE. Appreciate any help you can give me. For example ...

It didn't work. I define a mask edit box (MaskEdBox1) with a caption of Exp Del Date. Users entering date in here with format mm/yy. After she entered this should be saved in a table with a field name called expdate.