Search results for query: *

What .dll's does Crystal reports 8.5 need to export a report to .pdf? On a Client's server (server is Win 2000) I can export a report when there is no data linked. When I link to data (SQL server or an Access database) I can preview the data but when I export to a .pdf I receive "Failed to...

...True Label3.Visible = True LRecCount.Visible = True LRecPos.Visible = True Do Until Adodc3.Recordset.EOF oRS.Open ("Select * from tblTransactions WHERE Unapproved=1 And Cardholder='" & frmReports.Cardholder & "'"), oConn Set oCR =...

I have to subforms on a main form. They are both datasheets and both must have horizontal scrollbars due to the number of fields required for display. Is there a way to synch the two scrollbars so that when one scrolls horizontally the other will do the same? I've tried a MS Forms 2.0...

...the two? ( If {?VendorNumber}<>&quot;All&quot; Then {APM_MASTER__DISTRIBUTION.Vendor}={?VendorNumber} Else if {?VendorNumber}=&quot;All&quot; Then True ) And ( If {?Job}<>&quot;All&quot; Then{APM_MASTER__DISTRIBUTION.Job} Like {?Job} & &quot;*&quot; Else if {?Job}=&quot;All&quot; Then True )

I have parameter fields for two fields: a vendor number and a job number. I want the end user to have the ability to specify none, one, or both of the parameters. My record selection formula is below and it doesn't work. End result is no records if I select none, one, or all of the...

I am attempting to export a Crystal Report 8.0 to Excel via a VB app. Works fine on my local machine after VB package/deployment and installation of client's network I am getting an error message that the export can't perform because of missing dll's. Which .dll files do I need to include in...

I have packaged and deployed a VB app which previously contained reference to fm20.dll. I removed the controls and references frm the app and redeployed. Now when client deploys on network app is generating error that component fm20.dll or one of its dependencies is not correctly registered...

I am attempting to export a Crystal Report 8.0 to Excel via a VB app. Works fine on my local machine after VB package/deployment and installation of client's network I am getting an error message that the export can't perform because of missing dll's. Which .dll files do I need to include in...

I am attempting to export a Crystal Report 8.0 to Excel via a VB app. Works fine on my local machine after VB package/deployment and installation of client's network I am getting an error message that the export can't perform because of missing dll's. Which .dll files do I need to include in...

I have a VB application that I am attempting to deploy on a Citrix server. It runs fine on my local machine. On Citrix I am receiving error 380 ... Invalid Property Value. Can anyone shed any light on what might be causing the error?

I need to design a Crystal report (v 8.0) that I will launch and run from a VB app. The database source will be SQL. It will run locally on my machine and later launch on clients machine. How do I set up the database link in the Crystal report so that I can launch it from either a local or...

Report works fine on my local machine. Error appears when installed on clients machine: Server has not yet been opened. How do I correct it? Here is my code: If frmMainMenu.MyLocal = 1 Then Set report = crxApplication.OpenReport(&quot;c:\databases\visual...

I have a VB 6 app that is attempting to launch Crystal Reports. It works fine on my local machine. When I package and deploy they are receiving &quot;Physical Database not found.&quot; Datasource is SQL. It references my local SQL Server. How do I change the datasource for the clients...

I have a datagrid control with 3 columns ... a city or county, a state, and an abbreviation. I want to prevent duplicates from being entered in the third column ... abbreviation. How do I trap the error and clear out any existing data entered in the cell if its a duplicate?

I've tried update as well and the result is the same. Locking is optimistic. Which command settings should I be checking?

Is there any way to show multiple columns of data in a combo box? For example Initials Name gw George Washington al Abraham Lincoln Initials would be the field bound. Is there a better tool to use as opposed to combo box?

...Source=C:\Databases\Visual Basic\EstimatingTracking\esttracking.mdb;Persist Security Info=False&quot; adodc1.RecordSource = &quot;Select * From dbo_tblProjects WHERE BusinessUnit='RGG'&quot; I have an update statement on the unload property of the form. adodc1.Recordset.UpdateBatch What...

I want to launch a DTS in a VB 6 application. I have several questions. 1. Where do I put the VB code that SQL saved for me in my application? Should it reside in a module, class module, or behind the button that I will use to launch the DTS. Where do I call the code from? 2. Do I need to...

Back end of the app is SQL 2000.

My intent is NOT to crack NT security. I am only posing the question with the intent to fulfill a database request and alleviate multiple user logins/passwords. However, I can see that my question may be viewed as malicious in nature. I thank you all for your comments.