Search results for query: *

This is what ended up working: @True formula in the Report Header section. @False formula in the Details a section. @True formula in the Group Footer 3 section. Page Header b Section Expert for Suppress contains: whileprintingrecords; booleanvar flag; flag = true; This differs from your post...

1. Thanks for the prompt reply. 2. This works except that I get the page header info on the summary pages (report footers), too. How can I turn off Page Header b contents printing in the report footer sections?

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

RiverGuy, thanks for the prompt response and it does look promising. I'll do some tweaking and let you know. Thanks.

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'll give it a try and let you know the results. Thanks much.

strongm/hmckillop/RoyVidar, first, sorry that I did not respond earlier, was unexpectantly out of the office for a few days. My code post was incorrect, I am using &, not + for concatenation. The original document being opened is Word 2007 .docx. I have tried using different extensions...

Negative. Microsoft Office Professional Plus 2007 is installed.

Yes. And, actually, it does not matter what I put into strWordFileName. I receive the same error each time. I have another application that uses Excel and I am receiving a very similar error to this one. In this case, I get "Method 'Add' of object 'Workbooks' failed". It must be the same...

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 should define the purpose/function of the application a bit better. I have a master table that resides on a server in my office. There's about 2800 rows in this master table. I read this table sequentially and then compare the values for a given row to a corresponding table in a remote...

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

That was the problem. I had not made the Excel instance visible, even though Excel was displaying and the VB app was writing data to the cells. Once I added "xlApplicationObject.Visible = True", it worked. Thanks.

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

Zemp, the ZOrder did the trick. Actual code is .opt_addr(Row_Number).ZOrder 0 Thank you very much, Michael A. Martin

I thought that was what I did. I created the grid form, created an option button (opt_addr), placed it on the form, sized so that it fits snugly in the first row/column cell, set the index property to 0 (creates a control array, correct?), then wrote the code behind it all. When I run my form...

Yes, I found that document earlier. But I am not "tracking" when you mention "floating controls". Can you expand a bit on that, please? Michael A. Martin