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 bkrike 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. SteveFairclough

    Outlook 2003 / 2007 - color code internal email ?

    Hi does anybody know how to color code emails in Outlook 2003 / 2007 that are only from internal addresses or servers, ie the Global Address List ? I know you can apply automatic formatting based on the sender's address but I'm trying to do this based on the fact they are in the GAL. Any...
  2. SteveFairclough

    Help - Migration from 5.5 to 2003 with Outlook 2000 ost files.

    Hi, is it possible to migrate mailboxes from a 5.5 server to a 2003 server without having to re-create ost files for remote mobile users. We have many laptop users who use Outlook 2000 and 2002 in offline mode and I am trying to avoid having to recreate the offline ost files. Can anybody...
  3. SteveFairclough

    Excel Application.Quit only works when stepping though

    I have a simple macro that automatically starts when the spreadsheet is opened. I am desperately trying to get the macro to automatically close excel at the end. However, Excel will only quit when I'm stepping though the code to debug it, if I run the code normally then all the other code...
  4. SteveFairclough

    Application.ActivePrinter port name in Excel ???

    Hi I am trying to get my code to select a PDF printer to generate PDF files. When I look at the properties of the printer in XP, the details are Printer Name "Win2PDF" Printer Port "PDFFILE:" Therefore, my code for selecting the printer is Application.ActivePrinter = "Win2PDF on PDFFILE:"...
  5. SteveFairclough

    Appending strings in group summary

    I hope sombody can help with this. I need to create a query based one just one table that will group records by a Reference Number but join the contents of a string field into the group summary. Here's a simple example of what I'm looking for :- Ref String 1 A 1 B 1 C 2...
  6. SteveFairclough

    Outlook (2000/2002) AutoReply with attachment

    I'm trying to set up an email requestor service that will automatically reply with an attachment. I am trying to use the Rules Wizard to create this function. The attachment is just an Excel file that is updated every night. As I see it, there are two possible ways to acheive this. 1. Create a...
  7. SteveFairclough

    ODBC Driver required for Sage Payroll v8.03

    Hi does anybody know where I can download an ODBC driver foir Sage Payroll v8.03 ? Many thanks Steve. Steve Fairclough I.T. Manager
  8. SteveFairclough

    Latest Firmware for Archive Python 06408-xxx

    Does anybody know where I can get the latest firmware for an Archive Python 06408-xxx DDS Dat drive. I have one in a Poweredge 2450. I've searched Dell and Seagate web sites without success. It will write to the tapes but no longer reads them ? I want to make sure I have all the latest drivers...
  9. SteveFairclough

    Create Trust Error "User Account Already Exists"

    Hope somebody can help with this. I've searched Microsoft Technet and their web site but cannot find anything about this. I'm trying to establish a two-way trust that once existed but has since been removed. I have a one way trust going but when I try to set up the trust in the other direction...
  10. SteveFairclough

    Crystal SQL Designer Syntax

    I'm trying to create a view in SQL Designer that looks at the minimum date of a field in my table for each reference to a ClaimID field. The SQL I'm trying to use is as follows :- SELECT ClaimProgress.ClaimID, Min(IIf([ClaimProgress]![Status] In...
  11. SteveFairclough

    Efficient Report Design help required

    I need to write a report that shows parent records with totals calculated from child records from two different tables. The basic scenario is as follows :- Claims Sales Purchases ClaimID ClaimID ClaimID Name SalesItem PurchaseItem Address SalesValue...
  12. SteveFairclough

    Default font problem

    I'm trying to set all the default fonts to Arial (TrueType font) under File -> Options -> Fonts. However, it keeps reverting back to a Helvetica Printer font. Anybody know why it does this ?
  13. SteveFairclough

    Web Viewer Options ?

    Does anybody know if it is possible to control the availablility of the icons (Group Tree, Export, find etc) in the web viewer by passing paramaters at the end of the URL ? eg. http://mywebserver/test/rpt?GroupTree=off Thanks
  14. SteveFairclough

    ActiveX Web Viewer control

    Does anybody know if it is possible to control the availablility of the icons (Group Tree, Export, find etc) in the web viewer by passing paramaters at the end of the URL ? eg. http://mywebserver/test/rpt?GroupTree=off Thanks
  15. SteveFairclough

    Can't set default fonts

    I'm using Crystal Report v7 and am trying to set all the default fonts to Arial (TrueType font) under File -> Options -> Fonts. However, it keeps reverting back to the Helvetica Printer font. Anybody know why it does this ?
  16. SteveFairclough

    DateTime field shown as a string

    Can anybody tell me why my report is seeing DateTime fields as strings. I've set the option in the Reporting tab of Options to "keep date-time type" and in Report Options I've set the Convert Date-Time option to "To Date-Time". If I change both of the above to see the fields...
  17. SteveFairclough

    Using "Min of" summary function with Null Dates

    I'm trying to use the "Min Of" summary function on a date field that is not always populated. The problem I have is that if just one of the dates is a null value then the "Min Of" function doesn't display anything on the group summary line. I've tried to get around it by...

Part and Inventory Search

Back
Top