Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mamartin

    Conditional Suppress Page Header

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

    Conditional Suppress Page Header

    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?
  3. mamartin

    Conditional Suppress Page Header

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

    Compare 2 Columns

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

    Compare 2 Columns

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

    Method 'SaveAs' of object '_Document' failed

    I'll give it a try and let you know the results. Thanks much.
  7. mamartin

    Method 'SaveAs' of object '_Document' failed

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

    Method 'SaveAs' of object '_Document' failed

    Negative. Microsoft Office Professional Plus 2007 is installed.
  9. mamartin

    Method 'SaveAs' of object '_Document' failed

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

    Method 'SaveAs' of object '_Document' failed

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

    Get subtotals SQL

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

    Slow Response Updating SQL Server Database

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

    Slow Response Updating SQL Server Database

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

    Tool/Command Bars Do Not Display

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

    Tool/Command Bars Do Not Display

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

    Excel Command Bar Does Not Display

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

    No mapping between account names and security IDs was done

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

    MSFLEXGRID and Dynamically Created Option Buttons

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

    MSFLEXGRID and Dynamically Created Option Buttons

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

    MSFLEXGRID and Dynamically Created Option Buttons

    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

Part and Inventory Search

Back
Top