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!

  • Congratulations SkipVought 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: *

  1. ArnieNZ

    Pivot Table grouping

    Hi You can do it in the pivot table using the grouping command. With Workflows in the ROW area and Ages in the COLUMN area and Loan in the DATA Area, RightClick on Ages group heading > Select Group and Show Detail.In the Grouping command box ,tick Starting at and enter 0 in this field, Untick...
  2. ArnieNZ

    Very Odd but when i open an email it opens the one above too

    Have you checked the following: Tools, Options, Prefernces, E-mail Options - there is a selection box that offers to "open the previous item" You might fix your problem by asking to "return to inbox" instead. Regards from NZ Arnie
  3. ArnieNZ

    Hyperlinking an MSWord document to a Task in Outlook

    Just to add to that - use the shift key as you drag to get a hyperlink rather than an icon. Hope this helps. Arnie
  4. ArnieNZ

    Hyperlinking an MSWord document to a Task in Outlook

    Open your Word doc and also your task list, arrange on screen so you can see both, then drag task onto word page. Double clicking task object will open task item - Is this what you were meaning? Regards Arnie from NZ Arnie
  5. ArnieNZ

    Convert Text to Number using MsAccess Query

    Thanks Anne for your help again. Fortunately my problem is solved. I had tried all sorts of combinations. Someone I spoke to since I posted this thread gave me the solution. Anyway, the good news is it works using the function VAL as follows: Expr1:VAL([field-Name]) in the spare query...
  6. ArnieNZ

    Convert Text to Number using MsAccess Query

    Thanks for your help, but still no go. The field remains as a text field. Any other suggestions? Arnie
  7. ArnieNZ

    Convert Text to Number using MsAccess Query

    I am not VBA conversant, and I would like to know if I can convert a text field to a number field using a "good old query". The table of data I am using is imported from another source - no problems there - but the client field is stored as text in the original source, even tho the...
  8. ArnieNZ

    Custom Labels in Word 2000

    Thanks Indu - it appears that the distance of 17mm between last line of previous label and first line of next label on the correctly printed labels has become has become 15mm when transfered to the other PC, causing the whole sheet of labels to gradually creep up. I guess I could manually...
  9. ArnieNZ

    Custom Labels in Word 2000

    I have just found your site and I am so thrilled. I have checked previous threads but have not found any other questions about this. I have a label mail merge that uses a custom format that works perfectly on one PC but totally rearranges on another PC in the same office, using the same...

Part and Inventory Search

Back
Top