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 wOOdy-Soft 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 PatSalmon

  1. PatSalmon

    Linked Exchange folder - path question

    I have a linked table to an exchange folder. My access application appends records to this table. When I work on my local machine the "Link Table Manager" says the path is: C:\TEMP\TMP\Inventory Adjustment Tracker I also have a server that has a scheduled job to append the records to this...
  2. PatSalmon

    email hyperlink to Outlook folder

    I get the same result. Opens up a "Locate Link Browser" window. This tells me that it doesn't recognize the path at all. According to the Microsoft http://support.microsoft.com/?kbid=158135 the angle brackets are required for the outlook folder path. I think that it seems to get confused...
  3. PatSalmon

    email hyperlink to Outlook folder

    I almost have this working. [upsidedown] This is my code: strBody = "<A HREF='<Outlook://Public%20Folders/All%20Public%20Folders/Production/z%20InventoryAdjustmentsApproval%20(under%20construction)>'>This is the text that will appear for the link</A>" This puts what appears to be a link in...
  4. PatSalmon

    email hyperlink to Outlook folder

    Thanks so much for all of your help. We are getting really really close. [smile2] The link text does appear to be a link. but perhaps there is a problem with the syntax for the outlook folder. when i paste...
  5. PatSalmon

    email hyperlink to Outlook folder

    Thanks for your suggestions. I get a compile error with the following code: strBody = <A>="<Outlook://Public%20Folders/All%20Public%20Folders/Production/z%20InventoryAdjustmentsApproval%20(under%20construction)>">Link Name Here</A> I'm not very HTML literate and don't under stand the "Link...
  6. PatSalmon

    email hyperlink to Outlook folder

    When I do that the message body is blank. Do I need to do anything to the strBody statement? Thanks, Pat
  7. PatSalmon

    email hyperlink to Outlook folder

    I would like to send an email with a hyperlink to an Outlook folder. This is part of the code I have so far. .Subject = "Inventory Adjustment Approval" 'Forms!frmMail!Subject strBody = "<Outlook://Public%20Folders/All%20Public%20Folders/Production/z%20InventoryAdjustmentsApproval%20(under%...
  8. PatSalmon

    Complex Pivot table, 13 row fields

    I am working with Excel 2002. As I drill into the details of this pivot table from left to right I get the data I expect for the first 3 columns. When I try to get the details for the 4th column, by double clicking on the cell, I get all of the details for anything with the same value in the...
  9. PatSalmon

    &quot;Web Site Map&quot;

    I never did get this working. I went onto Microsoft's site and did some replys from a fellow, but what he said didn't make any sense to me. He made it sound like I needed some other software, but from what I read in the help text, this should work!!. It would be nice if it worked though...
  10. PatSalmon

    &quot;Web Site Map&quot;

    Has anyone successfully created a &quot;Web Site Map&quot;. If so what is the definition of &quot;web site&quot;. I have a mixture of visio diagrams (saved in HTML) and word docs (saved in HTML) linked using hyperlinks. When I try to create a web site map I only get the top level document...
  11. PatSalmon

    Workgroup teamstatus message updating durations??

    I am testing the workgroup functionality in Project 2000. When ever I respond to a teamstatus message (for example: a task with a duration of 1hr, I enter 0 in the &quot;Remaining Work&quot; column and 1hr in the column for the entire period. When I click the update button the duration for the...
  12. PatSalmon

    How do you display objects in a collection

    I am getting the following message: &quot;could not find the object in the collection corresponding to the name or ordinal&quot;. How do I see what objects I have in a collection? Thanks Pat
  13. PatSalmon

    using string variables with OpenReport

    WOW!!! You're awsome. I knew it must be something simple, but that is so hard to spot. Thanks a million!!! Pat [2thumbsup]
  14. PatSalmon

    using string variables with OpenReport

    Thanks John, Let me know your email address and I will send you what I have. thanks again Pat
  15. PatSalmon

    using string variables with OpenReport

    When I select &quot;All&quot; this is the watch I created Watch : + : ListNames : &quot;0&quot; : Object/ListBox : Form_frmSelectionBuild.Command2_Click When I select an idividual name I get Watch : + : ListNames : &quot;Blair T.&quot; : Object/ListBox ...

Part and Inventory Search

Back
Top