Search results for query: *

Check in Page Setup: Tab Margins: is the checkbox for 2 pages per sheet checked? If so, uncheck it.

You do not need an add-in. For a how to export to Excel see: http://office.microsoft.com/en-us/access/HA012241221033.aspx Does this not work for you? Tania

Ray, Have you tried asking in the excellent Crystal Reports Forums on Tek-Tips already? I don't know how to get a setup like yours working, but if all else fails, could you have a second report pull it all together? Ilse

Hi Keef, Reporting off an Access database I got the following working: SQL: WHERE (Klanten.Land Like '%' & ? & '%') In Criteria: Like '%' & [Enter letter] & '%' in fact using the & to concatenate the pieces of the like phrase with the parameter. Ilses

sept2006 would "like to type one key or two to change the font size of a word or a set of characters." If sept2006's intention was to write a macro for that, excluding the use of keyboard shortcuts, then I misunderstood. No, I do not use a custom shortcut manager and did not even know these...

Strange, works for me with US English, Norwegian and Dutch on HP, Dell and IBM keyboards. The Microsoft KB list of keyboard shortcuts gives the same key combinations (see http://office.microsoft.com/en-us/assistance/HP051955191033.aspx). Ilse

Ctrl+Shift+> and Ctrl+Shift+< http://www.pptfaq.com/ Ilse

You can set the maximum number of characters to be returned for text fields and for rich text fields in the odbc connection: 254 is default - max for text is 15,360. (Control Panel, Administrative Tools, ODBC, select DSN, click Configure). This then applies to all text fields. I think you may...

{IF {MERGEFIELD Year} = 0 "" {MERGEFIELD Year} = 1 "1 year" "2 years}} I find the esiest way to do this is to use Insert Word field for the first part - with If ... Then ... Else, so that you get: {IF {MERGEFIELD Year} = 0 "" ""} and then replace the second pair of quotes by {IF {MERGEFIELD...

Supposing the date you want to llok up is in BN1 =INDEX(B1:BK30,30,(MATCH(BN1,A1:BK1,0))-1)

One way is to bluntly copy your personal workbook and your xlb file (file with extension .xlb which holds toolbars) to your colleagues' machines. They will immediately loose their own customisations and may not be so happy about that. You may prefer to distribute templates or turn your personal...

Type the starting numbers in the first cells. Select the range you want to fill. Press Ctrl+G (GoTo). Select special cells, Visible cells only. Click Edit on the menu bar, point to Fill, and then click Series. Ilses

Hi, Userform controls like Button, Label, Image (didn't check them all) have a MouseMove Event. Ilse

You'll need a macro to do that: Sub ReprotectFields() If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _ NoReset:=True End If End Sub Assign a shortcut for ease of use. Ilse

Hello Patrick, If you want to see the date on which the document was created, go to: Insert > Field. Select the date/time category in the left-hand panel and the CreateDate option in the panel on the right. HTH Ilse

Don't know about any "compacting" feature. The biggest culprit is often not the data, but the formatting. Ilse

Keep a copy of your Excel.xlb in another place. It's the file in which menu/toolbar customisations are kept, unless you create your menu's/toolbars on the fly. HTH for next time, Ilse

Gavin, This =AND(LEFT(Data!$AD$10,1)="1",RIGHT(Data!$AD$10,1)="1") works if you change the references to relative references, i.e. without the $$. Plus, if you use a formula as criterium the column in the criteria range should not have a header (leave it blank) or the header should be...

Sam, Check out Ron de Bruin's site: http://www.rondebruin.nl/copy6.htm I use 2 burst subs to quickly burst an Excel export from Crystal Reports - when that's faster then creating separate exports to Excel (say one for each country in the world). Ilse

You can share a workbook: Go to Tools > Share Workbook (not sure about the right term). There are some problems and limitations for shared workbooks. See for instance Help on "Limitations of shared workbooks". Ilse