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 Chriss Miller 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 austinh

  1. austinh

    IPOD volume

    no i dont use an apple remote control on my ipod. I heard the same comment that rosenk said about the classic. I think its by design. I think its really stupid but what can you do.
  2. austinh

    Cannot send to internal email address

    I can send an email to outside email addresses such as yahoo or hotmail but cannot send an email to an internal email address such as mycompany.com. I wonder if it has something to do with my server. Any help?
  3. austinh

    XP freezes at start up

    awesome! Thanks for the advice guys. Thanks Wahnula for the detailed explanation. I will try it and let you know what happens.
  4. austinh

    XP freezes at start up

    After logging into XP the screen just loads the wallpaper and nothing else. There are no icons, and no taskbar. I have to do a hard restart and try and log in again. I am working on a Dell Optiplex 745. Nothing new has been installed and no new hardware. Any Ideas?
  5. austinh

    unread messages no longer BOLD!

    RLK1983UK "she had changed the Automatic formating and selected standard font for unread messages instead of bold" I have a user who is having the same problem. Can you explain in more detail what you meant by your answer above? Where can I find the automatic formatting and selected...
  6. austinh

    Event ID 7001...Help!

    I restarted the services but was trying to figure out what the error was and why it didnt start automatically.
  7. austinh

    Event ID 7001...Help!

    Im getting an event message 7001 on an Exchange server with a description of: "The Message Queuing service depends on the Distributed Transaction Coordinator service which failed to start because of the following error: %%0" Can anyone shed some light on this?
  8. austinh

    Subscript must be between 1 and the length of script

    Nevermind I had to change the 'or' after the second line to 'else' and everything worked fine. Thanks for the help synapsevampire and
  9. austinh

    Subscript must be between 1 and the length of script

    Is this what you were talking about 'synapsevampire'? if isnull({Renewal_Information.RNL_Rate_Code}) or len({Renewal_Information.RNL_Rate_Code}) = 0 or if isnull({Renewal_Information_Jt_Mbr.RNL_Rate_Code}) or len({Renewal_Information_Jt_Mbr.RNL_Rate_Code}) = 0 then "ERROR" else if...
  10. austinh

    Subscript must be between 1 and the length of script

    Should I follow that with all the other errors and then the regular else statements?
  11. austinh

    Subscript must be between 1 and the length of script

    Sorry for being too general. Here is the formula that its giving the error for I hope its not too sloppy. if {Renewal_Information.RNL_Rate_Code} in ['Y','WY','QY'] and ({Renewal_Information_Jt_Mbr.RNL_Rate_Code}[Len({Renewal_Information_Jt_Mbr.RNL_Rate_Code})-1]) = "J" and...
  12. austinh

    Subscript must be between 1 and the length of script

    I keep getting this error message, "A subscript must be between 1 and the length of the string", when I run the report with certain dates but not with others. Any idea what I have to do or change to fix this?
  13. austinh

    Querying from one table

    The data is the list of jobs and specifications. Like J1,J2,J3,J4,S1,S2,S3 etc. There is too much to list here. I tried to do what "synapsevampire" did in the second post ( {table.job} = "artist" ) and ( {table.specialization} in ["painter", "sculptor", "photographer"] ) but the jobs and...
  14. austinh

    Querying from one table

    Ill try and clarify. If I have a table called members and inside that table I have a field called ID. In that field is a list of jobs and specifications. Jobs such as artist, editor, critic etc. Specifications such as film, paint, photography. I want to create a report that will list all...
  15. austinh

    Querying from one table

    what if they are in the same field? For example there is the field, ID, in the member table and that is where all the jobs AND specializations are. So using your example, I wrote the same thing you had written but instead of {table.specialization} I had {table.job} for both.

Part and Inventory Search

Back
Top