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 IamaSherpa 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. 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 ...
  16. PatSalmon

    using string variables with OpenReport

    ListNames is the list box control name. The names listed are in the format Salmon P. - I used to have a comma after the last name but thought that it might be causing me problems so I removed it. I have added an &quot;All&quot; selection which the If ListNames = 0 Then strWhere =...
  17. PatSalmon

    using string variables with OpenReport

    I have the following code which is supposed to take the selection from a list box and run a report based on that selection. I am have trouble getting the quotation marks right (I think that's my problem). I have tried many different formats. This current one does not give me an error message...
  18. PatSalmon

    sendobject works once

    I replace my command with yours, it worked but only the first time. The only other commands before this one, are DoCmd.OpenQuery's that run a series of queries. I can't see that they would affect the email portion,
  19. PatSalmon

    sendobject works once

    Thanks anyway. It isn't the end of the world, but I would like to understand why. Thanks Pat
  20. PatSalmon

    sendobject works once

    The to is a distribution list called &quot;test&quot; (right after the &quot;RichTextFormat(*.rtf)&quot;. It does send the mail automatically without allowing edit, the first time it is run. After that I must shut and start Access again. Thanks Pat

Part and Inventory Search

Back
Top