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. kaatjev

    Automatically open a PDF, locate heading, and save heading as subject

    No - it is not possible to put the report heading into the body of the message. it sends an e-mail with subject "Buy Detail Report" and attaches a PDF file named "Buy Detail Report". The heading is only in the actual PDF. I am using outlook 2007.
  2. kaatjev

    Automatically open a PDF, locate heading, and save heading as subject

    I have reports that I have sent to me in an e-mail which I then need to forward to vendors. The reports are e-mailed in PDF format. The subject line of the e-mail is always the same and there is no way (at this time) to change the software to change the subject line by vendor. The only way to...
  3. kaatjev

    Fish! Philosophy

    They tried to implement the FISH! philosophy in our department also. But while mgmt was all for these activities, they never let up on their constant demands. Many of us were stressed out due to impossible deadlines, and then we get told "STOP WHAT YOU'RE DOING!!! Work on these puzzles!". Do...
  4. kaatjev

    Help with a IIF statement

    Since you only have 272 out of 3000 I am led to ask you the following question: are you placing this IIF statement in the criteria field? If so, it needs to be placed in a new field so that you can then query on it. Hope this helps.
  5. kaatjev

    Modifying SendObject to work with Groupwise basGWdemo

    Never mind... made it work :) Here is what I came up with. Private Sub Command0_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim recCount As Long Dim recipient As String Dim recipsubject As String Set db = CurrentDb Set rs = db.OpenRecordset("NH CLIENTS", dbOpenDynaset)...
  6. kaatjev

    Modifying SendObject to work with Groupwise basGWdemo

    I have two working scripts that I need to somehow combine... Global vOfficeID As String Function OfficeID() OfficeID = vOfficeID End Function is in a module, and together with this form script Private Sub Command0_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim recCount As...
  7. kaatjev

    Faxing from Access

    cchristi - I am trying to use BisCom / FAXCOM from Access. Just wondering if you had found a solution for this service? Some of us have the Groupwise integration, and some of us have the BisCom FAXCOM agent. As you stated - lots of manual input. want to get rid of that.
  8. kaatjev

    Email Report to Multiple Recipients

    Thank you to dhookom for providing me with the clue to resolve my issue. I added recCount = DCount("[ACCESSION]", "Query1") If recCount > 0 Then DoCmd.SendObject acSendReport, "CCL", acFormatRTF, rs("E-MAIL ADDRESS"), "", "", "Daily Census Report", "testing daily census", False...
  9. kaatjev

    Prevent printing empty reports

    Thank you! That is exactly what I needed. I added recCount = DCount("[ACCESSION]", "Query1") If recCount > 0 Then DoCmd.SendObject acSendReport, "CCL", acFormatRTF, rs("E-MAIL ADDRESS"), "", "", "Daily Census Report", "testing daily census", False End If and it no longer sends...
  10. kaatjev

    Prevent printing empty reports

    Re: thread 816550 (http://www.tek-tips.com/viewthread.cfm?qid=816550&page=1) When looping through the office ID on my tables, it calls up each client. However, when there are no orders from that client, it sends a blank report to the e-mail address. How do I prevent this from happening?
  11. kaatjev

    Email Report to Multiple Recipients

    Thank you so much for this thread. We are attempting to send e-mails to our clients detailing the orders for the previous day. During testing, I ended up with an empty form for the clients that did not order anything on the day. How do I prevent that?
  12. kaatjev

    Date Prompt for Header

    The macro recorder will give you something like With ActiveSheet.PageSetup .PrintTitleRows = "$1:$1" .PrintTitleColumns = "" .PrintArea = "" .LeftHeader = "blah blah" .CenterHeader = "blah blah" .RightHeader = "blah blah" .LeftFooter =...
  13. kaatjev

    Vlookup on a file without opening it?

    my machine at work does not have the Data,GetExternalData,CreateNewQuery feature turned on. As this is a large corp, I doubt seriously they will ever turn it on. I have a large file also - how do I do a vlookup on a closed file?
  14. kaatjev

    I want no one to print XLS sheet

    Anyone who wants the data bad enough, can get the data they want. It's like any burglary prevention system - the thieves can still get in if they want it bad enough. But, considering that a multitude of people don't know a web address from an e-mail address, some of the above methods can be...

Part and Inventory Search

Back
Top