Search results for query: *

Howdy folks, Got an existing VBA app that runs an export to excel. Works perfectly fine in excel 2003, fortunately one of my testers has recently had Office 2007 installed and when testing, gets the 'Run-time error 1004, Unable to get the Characters property of the Textbox class.' Do Until i...

Checked the FAQs and came up empty, so if this has been done before, please set me straight. In a nutshell, I'm using a multi-select list box, the second column in the grid (the data displayed based on the selection in the first column, a combobox). When I select multiple items, I need to add...

I'm using XMLReader, so far so good. However, my problem is I need to parse out a subnode and cannot figure out how to use the XMLReader to do that. My code: If xtr.Name = "Quote_Coverage" Then xtr.MoveToAttribute("Quote_Coverage_Id") xml_MessageArray.Quote_Coverage_Id = xtr.Value...

Hello all, I'm looking for some ideas for a problem that has just manifested itself. I have a CR that worked perfectly fine yesterday. Today I made some changes to it, basically overhauling data elements. When I open my project using VB, and run the report, it works. If I close the app to...

Hi all, VB6 - CR9 DE. I need to print reports with multiple pages, in this case an auditor can have numerous audits assigned to them, each with it's own auditnumber. The following code gets the criteria the reports will be based on, in this case get all audits requested for an auditor and...

Forgive me if I'm flogging a dead horse, but everywhere I've searched I find the .Net solution and not VB6. Using VB6 and CR9, using a stored procedure. When I select the SP in my report, it automatically creates a parameter which means I get the parameter prompt at run time. How do I...

Hi group, I've got a data field that is outputted as a date range: 200410-200506 which indicates Oct 2004 to Jun 2006. The customer now wants to see the literal dates above. One part of the report is done in code, and I figured it out. However, how do I do this in the CR data field? IOW...

CR9, VB6. Created report in CR9 using OLE DB connection from a SQL stored procedure. Works fine in CR9. Imported into VB6 app, at the line CRViewer.ViewReport, receive Login Failed, MS OLE DB Provider for SQL Server, and the description being the subject line. Temp work around to verify that...