Search results for query: *

I have a CR9 report that contains a Report Header (suppressed), Page Header a (not suppressed), Page Header b (conditionally suppressed), Group Headers 1, 2 & 3 (all three suppressed), Details a & b (not suppressed), Group Footers 3, 2 & 1 (1 & 2 are suppressed and 3 is conditionally...

I have a table that contains remarks regarding a customer. The remarks can be up to 8000 characters in length and there can be multiple records for a given customer. What I need to do is compare the differences between 2 sets of remarks for a given customer and then list out what was changed...

I am converting a VB 6.0 application that uses MS Word & Outlook that runs on an XP platform to work with Vista. The Office package has also changed (from Office 2003 to 2007). When the Word document is to be saved, the error "Run-time error '-2147417851 (80010105)': Method 'SaveAs' of object...

Can anyone tell me how to get subtotals by Street_Address for the OH_Qty and CM_Value columns in the following SQL: SELECT Sort_Order, Facility_Quarters, Street_Address, Current_Status, Item_Description, Stock_Number, OH_Qty, CM_Value FROM TM ORDER BY Sort_Order, Facility_Quarters...

I have a VB6.0 application that creates an Excel spreadsheet and updates 1 table in a SQL Server (2000) database. When I run the application from the Visual Basic environment, no problem. Takes about 12-15 minutes to complete. However, if I install this application on a workstation (XP) and...

I am creating a VB6.0 application that selects some data and then writes it to an Excel 2000 file. When I call up Excel from within the VB app, the Standard and Formatting command bars do not display. This is what the code looks like: Dim xlApplicationObject As Excel.Application Dim...

I am creating a VB6.0 application that selects some data and then writes it to an Excel 2000 file. When I call up Excel from within the VB app, the Standard and Formatting command bars do not display. This is what the code looks like: Dim xlApplicationObject As Excel.Application Dim...

I have an application that runs a local stored procedure against a remote database. The data is returned to my app, formatted into Excel and then the Excel file is automatically e-mailed to a distribution list. This works fine the first time I execute the app for a given customer site. But...

I have a form that pops up when the user clicks on the Add button that displays which address this record should be associated with (current and any potential past addresses). I am using an MSFLEXGRID form to display the address information. I would like to add an option button as the first...

I am receiving the following errors in a new Crystal Reports report: "Failed to open a rowset", then "Unknown Query Engine Error". The report is based upon a parameterized stored procedure. I am using CR 9.0 (sp4). If I create a report under CR 8.0 using this same SP, no problems. The stored...

A stored procedure that is called/executed from a SQL Server Agent job continues to fail with the following error message: "could not complete cursor operation because the set options have changed since the cursor was declared. [SQLSTATE 42000] (Error 16958)." This is on SQL Server 2000. The...

I am receiving a run-time error 713: application-defined or object defined error on my VB/CR application. I am using VB 6.0 and Crystal Reports 9.0. I already checked out Q248055 on the Microsoft webpage and applied the fixed (include msdbrptr.dll, msderun.dll and msstdfmt.dll into the...

I recently upgraded from CR8 to CR9. Now, one of my applications is receiving a run-time error 13 type mismatch. It is in the section of VB code where I set the recordselectionformula for a subreport. I have a variable SubRptPlaces defined as CRAXDRT.Report in General Declarations and in the...

I have a slight problem with my CR8.0 report. I am using VB 6.0 and the RDC against a SQL Server 7.0 DB. I have a main report and a subreport, and both use the same stored procedure. The sp has 4 parameters that are passed via VB code. So far, so good. The user submission form allows the...

All, I know someone has gone through this same process that I currently face. Hopefully, someone can share some insight/tips. I have 2 SQL Server 7.0 DBs that need to be merged into 1. They have the same structure/schema. It's just 2 different customers who have decided to merge their data...

Shortly, I will begin a project to merge 2 SQL databases together. The databases are for the same application, just for 2 different customers. Can anyone recommend a good book on DTS or overall SQL Server that covers data migration/consolidation? Thanks in advance, Michael A. Martin

I need a date validation procedure. If someone can direct me to an example, that would be most nice. I am using VB 6.0 with a SQL Server 7.0 DB. I have 2 dates on my user form: Open Date and Close Date. Within the DB table, they are defined as datetime. I am using a masked edit box to...

I know (hope!) that there is an easy solution to this one. Why, when I display a date on my form, is the date wrong? Using VB6.0 with a SQL Server 7.0 DB. I have a table (Damages) and a datetime field (Date_Opened). My form accepts the date in with a format of dd-mmm-yyyy. When the row is...

When I export a CR8 report to Excel (regardless of version), I receive an access violation error (Dr. Watson). Anybody else have this problem, and if so, what is the solution? Thanks, Michael A. Martin

I have a VB (6.0) app that is calling a SQL Server 7.0 stored procedure. The app calls the stored procedure from a Do Until loop based upon the number of rows returned from a query. The SP gathers rows from remote databases and inserts them into a temporary table created on the local server...