Search results

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

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

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?

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

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

I have developed and Access 97 application at work that uses .FileSearch in a module. Everything works fine under Windows NT. Our company is making a change-over to Windows XP. When an XP user goes into my application everything works as it should until they try to use the module with the...