Search results for query: *

On 6th September 2013, I retire from my regular job. Not necessarily from IT Work: I intend to see how things go with my various pensions. I might later go looking for contract work, but if so, I'll let you know. Definitely not interested at the moment. My working career has mostly been...

This tiny window does give you the opportunity to select one sort of paste as default. But I've already done this, and the window with its icons always appears again, often getting in the way of something I want to work on. The Esc key gets rid of it, but it is irritating to have to do this...

I already know there are downloads that offer this, but I'm not allowed to download software at work. I got used to those menus after 15 years using them, and they do have everything somewhere, if not neatly placed as an icon. I've also found how to add my own extras to the Ribbon and Quick...

For both Windows 7 and Windows XP, taskbar buttons appear in sequence of opening that software. I've got Windows 7 set to not combine unless the taskbar is full, meaning that it looks much like Windows XP did. (Except that it puts buttons for the same software next to each other, but that's...

Just moved from Outlook 2002 to Outlook 2010. All-day events used to show without a time, which makes sense to me. But it seems that Microsoft feels that their customers need to be told that all-day events start at 00:00, and put this first on the subject line for the monthly view. I found a...

My workplace has just moved us all from Outlook 2003 to Outlook 2010. Some improvements, but I don't like the new calendar. Two particular points: a) Multi-day events no longer extend across all the days to which they apply on the month-view. b) There is no longer an option on the month-view...

For Microsoft Outlook 2003, I like to use a monthly display, starting Monday and with Saturday and Sunday compressed. My screen shows five calendar weeks, with the first calendar week of the current month at the top. So far, so good. My problem is that a few months extend over six calendar...

I mostly write Crystal reports, sometimes using SQL to collect the data. But now I need to fix an existing report that does most of its logic in SQL and just uses Crystal to display the result. A problem occurs when the first of a month is also a Sunday. I know how to test for this in...

I'm writing a report that will select one of several OLE images from a specified folder, using a file name entered using a parameter. That much works fine. If I enter a file name that does not exist, I get the image of a little black square, but no other indication that there is a problem...

When you start Crystal 2008, you get a distinctive Start Page. This has recent reports and new options, as before. It also has what I took to be an advert. It is that, but it also has links to some useful data. Click the [Report Designer] tab: you’ll see a new page that includes [What's New...

A lot of my job is developing detailed specifications for screens and reports that may get changed many times by many different people. We use Track Changes, and I find it convenient to use multiple colours for different authors. While doing a search of an advanced usage problem (using color...

A lot of my job is developing detailed specifications for screens and reports that may get changed many times by many different people. We use Track Changes, and I find it convenient to use the [By Author] option. (Available from Tools > Options and the [Track Changes] tab. One trouble...

We've recently upgraded from Crystal 11.5 to Crystal 2008. For previous upgrades, there were useful guides to what was new. Googling, I found some hopefull-looking links but they no longer work. The official site seems all about Crystal 2011, which we don't have and probably won't get for a...

I am enhancing two rather similar reports, each of which needs to be able to choose data from either one of the last 7 days or one of the last 12 months. For the first of these, I created two parameters with pre-set value. So far, so good. Enhancing the second report, I naturally copied some...

Recently I took a copy of an existing Crystal 11.5 report and tried to use ‘Set Datasource Location’ to move it from one table to another within the same database, e.g. from WIB01 to WIB01ALT, each having much the same fields. The process seemed to have failed: it accepted ‘Update’ but still...

Running totals include Weighted Average as one option. If you're not already familiar with Crystal's automated totals, see FAQ767-6524. [yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]

I have Excel 2003. Normally the mouse wheel causes vertical scrolling, which is usually what I want. Occasionally it switches to horizontal, and I can't get it to go back without closing Excel and starting again. Using SEARCH I found some threads which mention this. I get the 'intelligent...

Better done in a formual field: if udfgenid=53 then if isnull(udfnum)) or udfnum=0 then 1 else 0 else 0 If that does not work, try displaying the original values in a diagnostic detail line. You could also try changing the zero values to 2 and 3, as a diagnostic, just to see...

I was amending a letter where a phone number was separated with spaces and was being split over two lines, which the business did not want. I tried using Chr(255), which should be a non-breaking space in Extended ASCII. Unfortunately it came out as a strange and visible character, a y accented...

I recently had to adjust an electronic signature in letter-generating report, because it was regarded as 'too large'. My first step was to create a set of reduced versions to clarify just how much they wanted it reduced by. So far, so good. My problem was when I pasted the electronic...