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 Rhinorhino 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 Pugs320

  1. Pugs320

    Printing to a Network Printer

    Thanks for your quick response Dyarwood. I tried this but I get a compile error on ActivePrinter. The error is "Method or Data Member not found". I have Access 97. Andy
  2. Pugs320

    Printing to a Network Printer

    How can I print a report to a network printer that is not my default printer? Right now I print to my default printer and I have to run the report across the building to the right department. I tried going through the help topics but I didn't see anything about this. Does anyone know code to...
  3. Pugs320

    Code to move Msg in Outlook

    I have tried a few things with different code suggestions. The code I have now I am able to step through it OK but there doesn't seem to be any result. Function DelMailInbox() Dim myOlApp As Outlook.Application, olNameSpace As NameSpace, Inbox As mapiFolder, mailCounter As Integer Dim...
  4. Pugs320

    Code to move Msg in Outlook

    Thanks for the response Page410. I tried your code and nothing was deleted from my Inbox. Here is what I did Public Function DelMailTest() Dim myOlApp As Outlook.Application, olNameSpace As NameSpace, Inbox As mapiFolder, mailCounter As Integer Dim AllMessages As Items, message As...
  5. Pugs320

    Code to move Msg in Outlook

    I have several Modules set up to extract Email attachments to a file. The code is like this: Public Function getmailZip1() Dim myOlApp As Object Dim myNamespace As Object Dim MyFolder As Object Dim myItem As Object Dim myAttachments As Object Set myOlApp =...
  6. Pugs320

    Process is not finishing

    Thanks, I will be working with your suggestion as soon as the rest of the emergencies at work are addressed. I will let you know the results. Andy
  7. Pugs320

    Process is not finishing

    I wouldn't even know where to begin with this code. If this is the way to do this, can someone give me an indication where to place this code in the module.
  8. Pugs320

    Process is not finishing

    What code can I insert in a module running several processes, that will allow a process to finish B4 moving to next process. Right now I am not getting desired results because 1 process is stepping on the other.
  9. Pugs320

    Running a Batch file from a Macro

    I need a suggestion as to what I am doing wrong. I am trying to run a batch file from a macro. I am doing this after I run a module from the same macro. It looks like the batch file runs but the expected results do not occur. If I run the batch file by clicking on it, everything is OK. I do a...
  10. Pugs320

    Automatically inserting date in file name ??

    Rollo58, I took your code and tried a couple of things. I was thinking on a much lower level than you, I was thinking MACRO. This code is working the way I wanted it to. THANK YOU for your help OutputTo acOutputReport, "FileName",acFormatRTF, "J:\FileName" & Format(Date -...
  11. Pugs320

    Automatically inserting date in file name ??

    I am putting it into the "Output to" action. Andy
  12. Pugs320

    Automatically inserting date in file name ??

    I tried this and I get the same error msg I got B4 Andy
  13. Pugs320

    Automatically inserting date in file name ??

    Another point, I am using the "OutputTo" Action in my Macro Andy
  14. Pugs320

    Automatically inserting date in file name ??

    The message is like this: Can't save the output data to the file you selected. *The file may be open. If so close it, and then save the output data to the file again. Yada, Yada, Yada Andy
  15. Pugs320

    Automatically inserting date in file name ??

    I tried this Paul but no luck. I also tried a couple of variations with and without quotations but I keep on getting an error msg.
See more

Part and Inventory Search

Back
Top