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: *

  1. kathryn

    Get at second to last word in title

    Good morning, all. I have a database table, tblJobPostings that I need to clean up. I have a number of rows with data in the Title field that looks like Manager Trainee - AnyTown XX123 CSR - MyTown ZQ123 Branch Manager - YourTown AA345 I need to get at the town names, i.e. AnyTown, MyTown...
  2. kathryn

    Why is autoforwarded message from folder have incorrect From: Address

    Good evening, I have written an agent which forwards all mail received into a public folder to different addresses, based on the text in the message. The forwarding is working fine; however, all the forwarded mail is coming from me and not from the folder. The folder has an email address...
  3. kathryn

    Debugging simple script

    Good morning! Here is the situation. We have set up a simple script that forwards email from a public folder. We wrote the script while at the client PC, using Properties...Agents. Here are my questions: How do I get debug information? I don't want anything fancy, I just want a popup to...
  4. kathryn

    Newbie question on DTS package

    Good afternoon all, I have created a DTS package that contains an Execute SQL Task, and ActiveX Scripting Task, and another Execute SQL Task. What the DTS Package does is delete indexes from a table if they exist (the first Execute SQL task), load in a variable number of text files from a...
  5. kathryn

    Create a custom To: box in Outlook custom email form?

    Is it possible to create a custom form for emails which has a dropdown box with a limited number of recipients listed in it? If so, how would it work? Would we use scripting with the Send event? Any ideas, references, resources, or war stories would be greatly appreciated. Kathryn
  6. kathryn

    Need to programmatically edit dts package and run it

    Good afternoon all, This is what I want to do: 1. Drop indexes from a table. 2. Append a variable number of text files to the table. 3. Rebuild the indexes on the table. The text files are all in the same directory on the network and they are the only files in the directory. Since the...
  7. kathryn

    Setting default folder in Query Analyzer (minor annoyance)

    Well...that was easy! Thanks, I was, as usual trying to do it the hard way (checking the registry!) Kathryn
  8. kathryn

    Setting default folder in Query Analyzer (minor annoyance)

    Good afternoon, all. This is minor, but it should be fixable. When I check a sql file out of Visual SourceSafe, I open Query Analyser and click File Open. The default directory is the Personal directory under C:\winnt\profiles... I would like it to be the directory that VSS checked the sql...
  9. kathryn

    STILL having trouble with CFSCRIPT and SaveAs in Word

    You are a LIFESAVER!!!! I have spent three days pulling my hair out on this one. Thank you so much. If I hadn't already named him, I would almost name my first born son after you! (Your name doesn't happen to be John, by any chance?) Have a happy New Year and thanks again. Kathryn
  10. kathryn

    STILL having trouble with CFSCRIPT and SaveAs in Word

    I am going nuts trying to get a very simple (??!!) CFSCRIPT to work. I would appreciate any ideas. I have gotten very detailed in what I have done to pinpoint the problem. The following code works fine: ****BEGIN CODE SNIPPET***** /* set a reference to the opened document*/ objDoc =...
  11. kathryn

    Problem with CFSCRIPT and Word - COM error 0x80020005. Type mismatch.

    thanks for the suggestion. I assumed that I had to use the code instead of the named constant. I will give that a try. Kathryn
  12. kathryn

    Problem with CFSCRIPT and Word - COM error 0x80020005. Type mismatch.

    Good afternoon, all, I have been fighting with the CFSCRIPT below for hours. I have scoured the Internet for help and haven't found a solution. I found a CFSCRIPT to convert a Word document to HTML in cfcomet.com. The code works fine with some modification, to a point. The problem comes...
  13. kathryn

    Really weird behavior with CFEXECUTE

    tleish, Yes, the exec is in the correct place. Even though it is in the system32 directory, it can be called directly from the c: prompt. One important thing I didn't mention is that I can get another, dummy, VBscript to run using the exact same syntax. The dummy script just copies a file...
  14. kathryn

    Really weird behavior with CFEXECUTE

    tleish, Thanks for the quick reply. The answers to your questions are: 1. Yes, CFEXECUTE is enabled. 2. The cfoutput is there because originally the arguments for the wscript.exe were dynamically generated. We have hardcoded them for debugging purposes. 3. Yes, the ping of yahoo worked...
  15. kathryn

    Really weird behavior with CFEXECUTE

    OK, here is the situation We have a development server, GENESIS, which is an NT box with CF 5.0 Server installed. On this box, CFEXECUTE runs fine. The CFEXECUTE calls wscript.exe which runs a VBScript to convert uploaded Word and Excel documents to HTML. We also a test server, ODYSSEY...
  16. kathryn

    Changing Link fields dynamically when number of link fields changes

    Solved it myself. for archive purposes, here is the solution. You need to set the linkchildfields and linkmasterfields properties to an empty string "" before resetting them. For example: Me![frmShowRecordsSubForm].LinkChildFields = "&quot...
  17. kathryn

    Changing Link fields dynamically when number of link fields changes

    Good morning, all. Long time no post. I am helping a coworker with a project. He needs to change the linking fields of a subform in code. The problem is that in certain circumstances, there will be one field to link the form/subform and in other fields there will be two fields. What happens...
  18. kathryn

    Automatically forward Internet mail to internal users?

    Good afternoon, all. Here is our problem. We have 600 branches who do not, and will not, have access to Internet email. They can receive internal email from each other and from headquarters. The branches do have access to select sites on the Internet and can order items from our vendors...
  19. kathryn

    HREF QUERY RESULT HELP !!

    if I understand you, how about <cfoutput query=&quot;yourqueryname&quot;> <a href=&quot;#yourqueryfield#&quot;>#yourotherqueryfield#</a> </cfoutput> Kathryn
  20. kathryn

    Formatting applied to entire document?

    Thanks!!!!!!!!! Your reply jogged my memory. That's it. I have the Update box check in the Style box for the Normal style. Kathryn

Part and Inventory Search

Back
Top