Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ilses

  1. ilses

    Document set on 8.5x11" pages is showing 5.5x8.5" pages

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

    Access 2007 report - output to Excel is not an option??

    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
  3. ilses

    Links not updating in Excel 2003

    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
  4. ilses

    EXCEL and MS Query Question - PLEASE HELP

    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
  5. ilses

    how to create a macro with powerpoint

    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...
  6. ilses

    how to create a macro with powerpoint

    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
  7. ilses

    how to create a macro with powerpoint

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

    Data retrieval

    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...
  9. ilses

    Word - ail merge condition

    {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...
  10. ilses

    Match for column Reference

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

    How to share Personal workbook and custom icons

    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...
  12. ilses

    Autonumbering (not hidden cells)

    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
  13. ilses

    No mouse over event?

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

    Losing Data in Protected Forms

    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
  15. ilses

    Word date macro

    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
See more

Part and Inventory Search

Back
Top