Search results for query: *

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

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 ?

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

I have a report which had a view attached to it which I have replaced with a stored proc (for efficiency... the view had a load of UNION ALLs but were pulling from the same tables so creating a temporary table and then doing the UNIONs is much faster) I am now getting a "There are no fields in...

When I try to save the following formula, I get an error saying "The Remaining Text does not appear to be part of the formula" and Crystal puts the cursor on the line before the IF statement; numberVar Limit := 0; select {RPT_Inventory_1.ClaimType} case 'Acknowledged' : Limit := 15...

On my main form I have a multi-select list box of patient names. When the user presses the 'View Patients' button, I want a form to pop up with the information for the patients selected in that list box shown one at a time with the normal navigation buttons available. Currently, the View...

I know this is dumb. I want to display a "Please wait" message in the middle of the screen while saving a big document in Excel. When the save is finished, I want the message to vanish without any intervention by the user. How do I do this ??? MsgBox demands a response and when I try putting a...

I know this is dumb. I want to display a "Please wait" message in the middle of the screen while saving a big document in Excel. When the save is finished, I want the message to vanish without any intervention by the user. How do I do this ??? MsgBox demands a response and when I try putting a...

In Crystal 8.5 I have a parameter from a Stored Procedure called @Check_Number. It is a number from 1 to 13. In Crystal, I have assigned descriptions to each of these values and set the parameter to only show the Description when prompting the user. For example, value 1 has the description...

1. Use (nolock) hints for EVERY table used in any report query. This is most commonly done by including the hint in any reporting Views and Stored Procedures (unless the SP is doing an update). Ideally, it should be done even in the transactional queries whenever a dirty read is acceptable...

In Crystal 8.5, I have a number of reports that use multiple tables (actually multiple linked views). I am replacing these queries with a single view for each report since this is MUCH faster in this particular environment. However, while I can set the location of the multiple original views so...

We have thousands of clients and want to be able to display each client's logo when they run the reports. For example, for client A we want logo A, for client B we want logo B etc. The only two ways I can think of to do this are; 1. Have multiple header sections and only display the relevent...

I have a report which has a drilldown group. The problem I have is that the Group Header is (now) shown on every page, but the Group Footer is only shown on the last page of the Group. In neither case is the Page Header or Footer shown when I drill down into the Group. Ideally, for this...

I have a number of users who need Macros installed in Excel on their machines. Currently, we add the relevent macros to their individual xlstart directories. However, this becomes an administrative nightmare since when a particular macro is changed, it needs to be manually re-installed on each...

My spreadsheet has two sheets and I am using a SUMIF on the second sheet to sum data with specific values from the first sheet. Both sheets have the following Columns; Type Value In the Value Column of the second sheet, my code is putting =SUMIF('Sheet1'!A:A,RC[-1],'Sheet1'!B:B) This...

Is there any way to spawn a child process in VBA for Excel ? I want to write a program to automatically check a folder for files every few minutes and, if it finds a file there to run a conversion utility in Excel. At any time, the user should be able to press a 'STOP' button on the screen to...

The 'trick' to avoid getting the header on every line when exporting to a CSV file does not seem to work for version 8.6.2.219 of the u2fsepv.dll No other method I have tried works either ! Any ideas ?

I have multiple parameters that I want to use and each can be set to 'ALL' or a specific value. Rather than using multiple IF statements in the Stored Procedure to select the correct SQL statement, I am creating a single SQL Statement dynamically and then executing it using the EXECUTE command...

I have multiple parameters that I want to use and each can be set to 'ALL' or a specific value. Rather than using multiple IF statements in the Stored Procedure to select the correct SQL statement, I am creating a single SQL Statement dynamically and then executing it using the EXECUTE command...