Search results

Michael, You should be able to use a Date\Time Format: Format([yourDate],"y")

Need some help from the Pros. I have been wrestling with a problem for a while now and have not been able to find the solution. The problem is to find a specific file and then attach it to an e-mail. The section of code below works fine except if, for example I am trying to find a QuoteNo...

Hi All, My company currently has dozens of Access 97 databases and is now going to MS Office 2003 including Access 2003. The transition is going to be made over a period of time. Consequently, In Access 2003, I have "Opened" the Access 97 dbs as opposed to converting them. The databases can...

I was able to do what you are looking for by using the following for generating an email To: string. just move your e-mail routine after the following code and use the EAddrB as your "To:" variable. Dim EAddrA As Variant Dim EAddrB As Variant Set EAddr =...

For anyone that has the same problem, I found a workaround. I got the file "msoutl.olb" for the Microsoft Outlook 10.0 object library and put in on the updated computers (under the correct path) and then went into the application and "registered" it in the reference section (using the browse...

Our company is gong through an MS Outlook upgrade. I have a MS Access 97 application that sends out automatic e-mails through MS Outlook. I have referenced Microsoft Outlook 10.0 object library and everything works fine. The problem occurs on the machines that are updated to a newer version...

agallah: Change the vbCrLf to Chr(13) for each line return you want to create in the e-mail message.

Thanks for the information and suggestion.

Hi All, My Access 97 application sends an email notification through Outlook. I use the display mode in the code so that the sender can edit the email before actually sending. I would like to know if the sender actually sent the message (ie pressed the Send button in Outlook). Can this be done?

Found Problem Just to inform everyone, I found the problem in that I had the table with the internet addresses formatted as a hyperlink. I change it over to text and the "Followhyperlink" routine now works like a champ.

Hello Everyone; I have a Form with a List Box that displays hyperlinks to the internet and intranet. Behind the "After Update" event, I use "Application.FollowHyperlink strXXX" to go to the internet. Private Sub Combo46_AfterUpdate() Dim strhyperlink As String strhyperlink = Me!List46...

The following is the code that I use to look up a saved quotation and if any drawings exist for the quote attach it to the e-mail along with the quote. Right now it only attaches the first drawing that it finds. What I need is a way to Array the drawings it finds and then attach them along...

Thanks for the quick response, the DateDiff gives me what I needed and the format function will really help. Thanks again.

I have a query where I need to calculate the the total hours (or days and hours) between two dates and times for a process that may span a number of days. I have an outdate and time in one pane of the query and the returndate and time in a second. Each has an input mask for the date and time...

Hi All; I am building an application where I need to look up a list of drawings in a particular folder (L:\drawings\abc123.dwg) on our company network. I would then like to attach the found files to to a single e-mail. From browsing the boards, I believe that I need to built an array in code...

re:ghudson I was able to work with the code and the application now works under Windows NT, XP and 2000. It was as you stated, a problem with using a Wild Card. Thanks again. The code that finally worked is indicated below. With FileSearch .LookIn = "L:\Drawings\Acaddwgs\" & d1...

re: ghudson One other point. In the Object Browser, I was able to local Application.FileSearch , however, .FileSearch is a Hidden Member. Do this have any effect on it not running under Windows XP?

re: ghudson I entered the code as you showed and I had to reference Office for the "Filetype =" line. When I ran the code on my Windows NT machine, where the old code ran successfully, the routine just sat there with the Hourglass cursor and churned after about 5 minutes I had to go to the...

re: ghudson I understand now, thanks again.

re: ghudson Thanks ghudson, I AM using the Wild Card "*" in the data string search. I am searching for drawings with different revision levels. It is of the form "ABC123" with different revision levels (r00.dwg, r01.dwg,...). If I set the ".TextOrProperty = ABC123" and then set...