Recent content by kettie

Thank you Pete That formula worked perfectly and I have been able to complete my report successfully. Kettie

I am using Crystal Reports V.10. In our organisation, every employee is to have a performance appraisal completed by 31 August annually. In our database, the due date for the next appraisal is stored as a date field {Apr_Next_dt}, ie 2012,06,07 For instance I may have Employee Name...

You did 'bonza' (means fantastic). You're a 'little ripper' (means teriffic person). Kettie [gorgeous]

And the kangaroos are hopping and koalas hoeing into the gum leaves down here in beautiful downtown Melbourne town!! [lol]

Skip You are just too good. Thanks and have a good day (or maybe it's evening where you are). Whatever the time, I hope it's a good one Kettie [wavey2]

Skip Thanks for that help - it seems to work. If I might be a pain, could I just get some help understanding the code as I will be applying it to an existing document. Do I have to substitute the "Name" mentioned in the following((Selection.Bookmarks(1).Name))with the unique name...

G'day to everyone who replied to my thread. A big thanks. The problem is that I'm able to get this to work for a text form field, but my document contains drop-down form fields and it doesn't appear to work for that kind of form field (or perhaps I have done something incorrectly). Does the...

I have developed a form in word which has a number of drop down boxes. I would like to force the user to choose an item from the drop down list, but am unsure how to do this. Is it possible to do this in a Word form and, if so, how can I do this?

Crystal Reports V9 SQL database I have developed a main report which forecasts leave balances by employee at a future date, and then linked a sub-report which details any future leave events recorded for that particular employee. What I'm trying to do is to deduct the total leave hours booked...

Well, how stupid is that! Does anyone know whether it's true that they're not supporting V8 Crystal Reports and Crystal Enterprise now. We upgraded both because our administrator was told they don't support them any more. It seems a bit odd to me and the troubles we're now having with V9...

I've just upgraded to V9 Crystal Reports. In V8.5, I was able to turn off the smart linking option in Options, but I can't find a similar function in Version 9. I know that I can clear all links from the links box, but I frequently add tables as I build a report and don't want to have to clear...

Thanks for everyone's assistance. I now have the report working with a Year to Date formula. Kettie

Thanks Reebo & lbass Alas, neither of your solutions worked. Reebo - your formula returns nil rows lBass - I receive an error message "The ) is missing" (the cursor then moves to before the comma after (Year(CurrentDate) I have played around with adding commas and brackets but am...

My report requires me to report on total absences for the current financial year. The Australian financial year runs from 1 July to 30 June. Is there some way I can put a selection criteria in the report that will automatically return records pertaining to the current financial year only...

I have recorded and saved a macro to the Personal Workbook. My understanding is that whenever I open a new worksheet in Excel, the macros saved in the Personal Workbook are available for use. However, I can't find it. When I go to the XLSTART folder, I can manually open the personal.xls and...