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

    Getting "User Name" while in Access db

    How do I get the Log-in User Name when I am in an Access DB?
  2. GregGood

    Access 2000 loading slow in win XP

    The last few weeks I have noticed that my Access 2000 applications have been loading very slowly. I'm looking for help in resolving this problem. Thank you, Greg Good BI Technologies
  3. GregGood

    Sending HTML Email body via Access/VBA

    Remou, Well, by doing what you suggested I was able to see the picture in the outgoing email (big step) and when I sent the email to myself I was able to see the picture in the received email (another big step)! When I sent the email to someone else, however, the picture was, again, nowhere to...
  4. GregGood

    Sending HTML Email body via Access/VBA

    Much simpler than what I've got. I'll make some changes and let you know. Thanks, Greg
  5. GregGood

    Sending HTML Email body via Access/VBA

    I went in, as you suggested, and checked the address of the picture in the html code; it looks ok and works fine when I open the page with a browser. I'm wondering if the picture must be in a particular directory in order for Outlook to see it as it is rendering the page? Greg
  6. GregGood

    Sending HTML Email body via Access/VBA

    Hi Remou, I have 2000 pro at home and xp pro at work and both are failing. I've tried different things with the image. I have it in a directory and it is also imbedded in the Word doc that I'm using to create the html page. How would I build the email page maually? I tried opening a new...
  7. GregGood

    Sending HTML Email body via Access/VBA

    Remou, I used .HTMLBody and I did get the document to render in the Email. The only problem that remains is that I have a picture at the top of the page that is not coming through. When I browse the html page, the picture is there but all I have is a place holder in the email (no picture)...
  8. GregGood

    Sending HTML Email body via Access/VBA

    Remou, I have not tried .HTMLBody I will do that now. Thanks for the tip. Greg Good
  9. GregGood

    Sending HTML Email body via Access/VBA

    Hi Alex, This is what I am currently using: Public Function SndLPEmail() Dim db As DAO.Database Dim MailList As DAO.Recordset Dim MyOutlook As Outlook.Application Dim MyMail As Outlook.MailItem Dim Subjectline As String Dim BodyFile As String Dim fso As FileSystemObject Dim MyBody As TextStream...
  10. GregGood

    Sending HTML Email body via Access/VBA

    I am using a VBA module for sending email from Access through Outlook. I am currently using a txt file for the email body but wish to us an HTML body. I have tried simply using the HTML file but all I get is the HTML code in the body of the email (un-rendered). Is there anyone out there who...
  11. GregGood

    Press ESC key via Command Code in Access

    Thank you! That did the job. Greg
  12. GregGood

    Press ESC key via Command Code in Access

    I have a procedure that I'm running that is working fine except for an Access requirement right in the middle of it that requires a press of the ESC key. Is there some code I could put in a module or some other way that I could simulate the pressing of the ESC key? Thanks for any help that I...
  13. GregGood

    Outlook stopping an Email that I'm trying to send automatically

    Hello, I have a VB module that I'm calling from Access for sending email via Outlook. The process is working well except that I am now getting a warning message that I must respond to before the mail will be sent. The required response has messed up my otherwise automated system. Does anyone...
  14. GregGood

    Running Windows Application from VB

    Hello, Does anybody have an example that you can send me of VB code that runs (launches) a window application like Word or Excel or a BAT file. I know just enough about VB to be dangerous. Thank you for any help you can give me. Greg Good
  15. GregGood

    Criteria question for a query

    Regarding the question you have with your start and end dates; I create a field in the query called UseThisRec. I describe this field as follows: iif([StrtDt] => [ComboStrtDt] and [EndDt] =< [ComboEndDt],yes,iif(ComboStrtDt] is null and [ComboEndDt] is null,yes,no)) Then, in the criteria for...
  16. GregGood

    dbase import problem

    I'm trying to import a Dbase lll data base into my existing Access 2000 data base. My operating system is Windows 2000. When I try to import via FILE / Get External Data / Import, I get the following message: "The Microsoft Jet Engine could not find the object 'giftorder.dbf'. Make sure the...

Part and Inventory Search

Back
Top