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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ilses
  • Order by date
  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
  16. ilses

    Excel 2000: File size is too large

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

    Excel Toolbar - How to save customized?

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

    Advanced Filter Criteria

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

    Report Bursting in Excel 2000?

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

    .xls spreadsheet for editing permissions?

    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

Part and Inventory Search

Back
Top