Search results for query: *

I think this is not a difficult thing to do but it is not occuring to me.... I want to insert the result of a cell value as the table name in the following formula. I am just getting the number of records that fall between to dates...

We have upgraded or server (AS400,I520)and I have a new ODBC link. I have large and complicated Crystal dictionaries and need to change my dictionaries to the access the new Server. Any thoughts? Thanks, Todd Horst

Thank you... worked great.

I need to calculated elapse time for each room a patient is located in a hospital) during a stay. Each (Pt #, Room, and Begin time) row of the database has only begin time. I need to use the previous begin time as the end time for the previous record (records sorted descending)in CR 8.5. Is...

I am trying to paste a text box at the bottom of an Excel chart with a macro. If there are more that 256 characters nothing is showing up. I tried a label and am having the same problem. What Control can I use? Here is my code: Dim newTextBox As Shape Set newTextBox =...

I am trying to add a text box to an Excel graph if one does not exist. How can I determine if one has already been added? ActiveChart.Shapes.AddTextbox(msoTextOrientationHorizontal, 3#, 367, 750, 23).Name = "SC_TxtBox" ActiveChart.Shapes("SC_TxtBox").Select...

Thanks. Simple and works perfectly. I have a errorhandler to catch certain errors (chart not selected. ect) but both seem to work since this is within the for/next loop.

That did not work. I still get the same error? Plus the software I am using (SPC XL 2000) creates the worksheet from which the graphs are the source.

I need to modify a line chart based on the MarkerBackgroundColorIndex of a third party software company. This works unless a point does not have a value, like the first point in a moving average chart (Error #1004 unable to get MarkerBackgroundColorIndex ...). It don't think it would be...

A utility subprogram that will do all “intelligent” record navigation buttons for any form Public Funtion SmartNav(cmdFirst As CommandButton, cmdPrev As CommandButton, _ cmdNext As CommandButton, cmdLast As CommandButton) Dim frm As Form 'Set object...

Thank you. It works perfectly.

I have an Excel add-on that graphs spc charts and colors "special cause points". Not all users have access to a color printer so I am trying to write a macro to change the marker Style and line style for these points which are colored red by the program. How do I identify the number of...

I am working in Crystal 7.0 I have a cross-tab with two row values (a code and a corresponing description). By Suppressing Subtotal in Crystal everything works fine, but when I export to Excel the subtotals reappear. The Code(and Total)and Description appear on alternating rows. The only...

I often use the "in specified order" for by my groups in Crystal Reports (8.0). Is there a way to copy my group order from one report to another.