Recent content by GregGood

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

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

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

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

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

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

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

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

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

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

Thank you! That did the job. Greg

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

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

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

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