Recent content by Krusher

I want to loop through fields in a table within Microsoft Word if that helps.

Instead of using "Selection.WholeStory" to select every piece of text in a document, I'd like to just be able to select all active document "fields" instead. I need to select the fields to change color. Thanks in advance. -K

How can I reset public variables? Or, how do I simply tell VBA to "recompile" everytime the user executes the macro? Thanks in advance. K

Is anyone aware of any VBA code that can take a screenshot of a window and save it as an image file (jpeg, gif, whatever..)? Basically, I have a VBA form in word that I want to automatically copy to the clipboard and save to a file. The form contains a bunch of data that I need to display...

At some point, I had a VBA program from the web that generated an excel listing of all plotters on my system and their equivalent canonical media sizes, because canonical media is all that VBA accepts as plot sizes. Can anyone point me in the right direction. Thanks in advance, K

Here's my formula: IF {WOSTATUS.STATUS} in ["DESIGN"] THEN datediff ("d",{WOSTATUS.CHANGEDATE}, next({WOSTATUS.CHANGEDATE} I have never been able to summarize this "type" of formula for whatever reason. Maybe someone out there can help. Thanks in advance. -K

The version is Crystal Enterprise 10 and I was wondering if there is a way to add an hourglass to show that a report is processing or some other means to show my users that the report they requested hasn't crashed and they shouldn't keep hitting the "OK" button. Thanks in advance, RT

Never mind, figured it out by adding a variable to store the top-level parent. Thanks anyway. -RT

Ok, Here's my problem. I have a report that shows workorders in a hierchical grouping, but don't want to show all of the hierarchies at once. I want the user to be able to enter a single work order number and show the entire hierarchy structure it appears in (front top level parent to the...

This has been on ongoing problem for me. It seems as if I can't have more than one condition statement when suppressing a Section in the formula field: isnull({EMPLOYEE.EMAIL}) or EMPLOYEE.EMAIL = "OFFSITE ADDRESS" The section is only being suppressed if the first condition is met (isnull)...

I am using Crystal Reports 10 and am struggling with one small issue. I am using a percetage bar chart that graphs a series of running totals in the form of counts. My question is, how can I place the total number of counts over top of each bar in the chart? I don't want to show values for...

I just installed Crystal Enterprise 10 on a Windows Storage Server 2003 R2 Box. The Report Application Server will not start. I get errors upon boot up in the event log such as: Faulting application crystalras.exe, version 10.0.0.533, faulting module unknown, version 0.0.0.0, fault address...

PDQBack, I just got it!!! I decided to sort by finish date and filter on task name "Design" and then select the last record in the list. Easier than I thought I guess! Thanks, K

PDQBach, Good questions! There shouldn't be more than one task with the same finish date. The dates are formatted as dd/mm/yy. Also, milestones are fine as potential predecessors. I actually looked at the "ActiveProject.Finish" value as a potential answer, however, it gives me the last...

Does anyone have any ideas on creating a macro that allows me to insert a new task and link it as a successor to a task with the latest finish date? Basically I want the macro to search through every task in the project and determine the "newest" task. -K