Search results for query: *

Found this repsonse here http://forums.whatpc.co.uk/thread.jsp?forum=12&thread=7081 And it worked for me. Start>Run>"C:\Program Files\Microsoft Office\Office\excel.exe" /regserver I'd tried Office service packs, Windows service packs.. nothing. But the above worked a treat

strParam = Command Beauty!

This used to be a commonly used feature of DOS scripting. I wanted to write a simple app using the Crystal report viewer and have it open a report whose name is passed as a parameter. eg; c:\apps\CrystalView.exe "C:\Docs\Report1.rpt" The app would open and display the...

It does export a calculated field I have in the report header, and I just tried calculating a field within the report detail, that Exports to excel as well. It has a hard time with the footer, it will not display any kind of calculated field or even label, it seems to urge Excel to summarize the...

Another Excel related question.. Rephrased re-posted.. "Totals vanish when exporting to Excel" I'm using the DoCmd.OutputTo method of transferring the contents of a formatted report out to an Excel file. The report contains 6 subreports and I've attempted to line them all up so as...

Another Excel related question.. I'm using the DoCmd.OutputTo method of transferring the contents of a formatted report out to an Excel file. The report contains 6 subreports and I've attempted to line them all up so as to achieve a sense of continuity. Everything is just fine except for...

It's Genius like that that I was after.... It works an absolute treat. Thanks Steve.

I'm attempting to pass data from a form to a parameter within a query. In the criteria cell I've entered: Not In ([Forms]![MyForm]![MyTextBox]) MyTextBox contains the literal string "Stoves","Ovens" Yet Stoves and Ovens are still returned. Any Clues? Thanks, Rob Dexter.

Ooops! Field1 is numeric and NZ is a VBA function.

CR8.5Dev, Access97, ODBC I'm trying to replicate VB's Nz "null to zero" function within a Crystal formula, is this the correct method? IIF(IsNull({db.Field1}),0,{db.Field1}) Not getting the desired results: Falsepart - formula returns field1 when it is not null - ok that's good...

Bewdy! Thanks.

I'm going crazy here, struggling with selection syntax. FName MName LName ---------------------------- Fred James Flinstone Ted Bertie Beetle Irene Payne Greg Philpott Brady Ron Birdseye I want to exclude all records whose middle names =...

CRDev8.5 ODBC Access97 Client would like to view summarized weekly data inclusive of running sum to display "Period to Date" figures. "Period" could be anything from 2 to 52 weeks. I've atttempted using a crosstab to display the data on an x-axis timeline, it's great, but I...

Hi & tanks, I tried - Report.ExportOptions.DestinationType = crEDTDiskFile Report.ExportOptions.FormatType = crEFTExcel70 Report.ExportOptions.DiskFileName = "c:\ExportedCR.xls" Report.ExportOptions.ExcelAreaType = crPageHeader It didn't have the same result as previewing then...

Any Clues? Anyone? Bueller?

CR8.5Dev, VB6, ODBC I have a report that is always exported to Excel, always "7.0 Extended" and Column width always based on Page Header, plus I'd also like to control the resulting file name via code as well. This would save users a few extra keystrokes, plus ensure it ends up in the...

Thanks rogar.

Using the DRT I found I can access most of this stuff - Report.ExportOptions.DestinationType = crEDTDiskFile Report.ExportOptions.FormatType = crEFTExcel70 Report.ExportOptions.DiskFileName = "c:\ExportedCR.xls" But I cannot find the option to use column widths based on Page...

CR8.5Dev, VB6, ODBC Are the Crystal export functions controllable by VB code? I have a report that is always exported to Excel, always "7.0 Extended" and Column width always based on Page Header, plus I'd also like to control the resulting file name via code as well. This would save...

You are a true legend! Thank you very much..