Search results for query: *

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...

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...

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 ...

Hi. I tried doing the masked and during data entry the entry is appearing on the screen. My problem is how do I save the value of the Masked Edit Control to a table field name ExpDate. Appreciate any help you can give. Thanks.

I got this problem when I'm trying to do some calculations in the table or file, it doesn't update. what's wrong with my syntax ? Program Code : Private Sub cmdBidUpd_Click() On Error GoTo UpdErr With BidRecordset !F_Number = txtbidflds(0).Text !BidDate = txtbidflds(1).Text...

I'm trying to do an update in two files. When I'm doing an update in the first file I'm getting a message : Cannot insert or update columns from multiple tables. Do you know what causes this error to occur :

I have two files TBLPROJECTINFO and TBLBIDINFO. TBLPROJECTINFO is a header File and TBLBIDINFO is a Detail file. TBLPROJECTINFO has data and TBLBIDNFO may not. How do you check if there are records in the other file and display a message "No Record Found" Here is the program I...

I had a program written in VB and the files are running in SQL Server. I don't know why I am keeping getting an error. Somewhere probably My syntax is incorrect. I need some help to debug it.

I was able to call a Crystal Report File in Visual Basic. Now my problem is if I created the crystal to be a Report Expert and define this as Drill Down, it will only show me the first page and when I click to drill down it doesn't work. What is lacking in my setup or definition ? Please help !

I got these data that needs to be summarized and at the end do a averaging totals. How do you do this ? For example I have the following listed : Accuracy 70 F-Number Base/Alt Rebid# Sq. Feet F2000 Alt#1 Rebid#1 480.00 F2001 Alt#2...

The field is being defined is the file as ExpDeliveryDate with Data Type nvarchar. What I wanna do is to have a record selection that will only accept tblProjectInfo.ExpDeliveryDate = DateParm Since I am new to this crystal report, how do you define the parameter when you create one to only...

I am new to VB and I have a hard time coming up with the correct syntax coding for this. strSQL = Select * From tblProjectInfo Inner Join_ tblBidInfo on tblProjectInfo.F_Number =_ tblBidInfo.F_Number _ Where tblProjectInfo.Probability% > 74 _ And...