Recent content by Siggy19

When I compile my Access 2003 database-based application into the ADE format, my option groups produce an error message "The expression On Error you entered as the event property setting produced the following error: Resume without error." It usually seems to happen when I have selected a...

On a serious note; 1. It does now work since we upgraded to version 11. 2. Exporting to Excel allows for manipulation of the data, for example including historical data in future projections etc. The row limit has been almost eliminated in Excel 2007, although I don't know if crystal knows this.

Upgrade to version 11 of Crystal !

This seems to be a problem when exporting from Crystal 8.5 to Excel 2003 SP3 ONLY WHEN Excel 2003 SP3 is on the Crystal machine. I have two users, one on Excel 2002 and the other on Excel 2003. If the 2003 user exports to Excel, he gets the error. If the 2002 user does it, no error. If 2003...

My user wants my text to look as follows; "This text is bold and this is italic. Please do not ..." Unfortunately the report writer seems to format the whole paragraph or none of it. Any ideas ? Thanks,

It has the options Left, Right, Center and 'Distribute' for justification... and Distribute does just what it says on the last line as well as the others therefore looking awful. Any ideas ?

This is one of my pet peeves also... I would like to be able to 'chain' SQL statements so that a single query can perform multiple statements. I do not know of a way to do this in Access (SQL server is happy to do it OTOH). Macros is the 'official' way to do it. The alternative is the way I...

Thanks ZmrAbdulla. Unfortunately, that only tells me how to disable and then re-enable the shift key access to the full development environment. What I would like to be able to do is to have a button within the application which will exit from the application into the full development...

I have an Access 2003 application which is set to automatically launch when the user runs it. To avoid security issues, I disable the database window, the status bar and the full menus using the Startup form. The users CAN still hold down the shift key when they run it, but I would like to...

The only thing I can suggest is to hard code the page number on the main report as "Page 1" and then start the page numbering on the subreport at page 2. You will not be able to do the Page x of y thing since you do not know how many pages are being generated by each subreport. Like I say, I...

Use a couple of formulae; one to set a variable to zero in the group header and another to increment the variable in each page footer and then display it. The variable will have to be declared so that it is shared between the multiple formulae. However, this will not work properly if you are...

Depending upon why you are doing this, you may want to consider putting the criteria in the select statement so that you only get the records that you want... where possible, let the database do the work for you - that's what it's designed for.

I ended up creating the temporary table explicitly in the stored procedure, rather than having the first select statement do it with the 'INTO #Report_Data' command. No idea why, but it now seems to work. Thank you all for your help and advice.

I tried that and still no joy. <sigh>

It's SQL Server, but the same code would work in Oracle without the (nolock) statements... The bit that should return data to the Crystal Report (and does work if I run the Stored Proc on its own) is from SELECT 'Paid' AS ClaimType, CLM_PHCode, HPC_Intlzip, MONTH(CLM_DateRecd)...