Recent content by ilses

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