Search results for query: *

I have a datbase containing a table or query with several records containing hyperlinks to files located on a server. I would like to be able to click a command button which: 1) Opens the common dialog box to allow the user to select the new file desination 2) Copies each of the hyperlink...

I have a piece of code which sends out multiple attachments from the hyperlinks on a subform. This works great but I want to avoid, or at least warn the user from sending an email with multiple attachments which total, say 6 mb. Can this be done?

Hi. Pretty easy really. I have a table detailing all the docs in the business and each doc has a hyperlink to the relevant document on the server. When creating the table in design view, select 'Data Type' to force a hyperlink entry. Then, once the form's created, just go to the menu and 'Insert...

I hope someone can help me with this. I have an access database for document control from which there a hyperlinks to all the technical documents within the business. I have just upgraded to Acrobat Reader 7.0 and can no longer open the documents using hyperlinks. I see the Adobe application...

It works! Thanks. I was barking up the wrong tree entirely.

Hi, I have a subform which has a field for each supplier detailing various product types for each supplier in the format of "Calibration, Gauges, Instrumentation, Valves" etc. I also have an unbound combobox which contains each of the items listed above. What I need to to do is to select a...

Hi, I have a form which is used for document control. It has a field which hyperlinks directly to the controlled document. When I activate such a document, it emails relevant people informing them of the new rev, doc title etc. It also shows the path of the document but I'd like to add this...

Thanks for the suggestion - I will try it and see what happens. I also think that it might be something to do with MS Exchange not being used in my present company. My previous company had Exchange and I never had this problem when using the same system.

Hi, How can I stop Outlook 97 sending an identical e-mail to the same person 3 times?? The reason this is happening is because I have an Access DB that tracks corrective actions. I want to send the email to the buyer, the person responsible for the short term action and the person responsible...

The database is used for corrective action tracking. The OLE object is used for further information such as photo's, Excel spreadsheets, Word docs etc. I want to add this additional information as an attachment to the e-mail that is sent. Any help is appreciated.

Hi, I'm using Microsoft Outlook. See below for an example of code: Dim objOutlook As New Outlook.Application Dim objMail As MailItem Set objMail = objOutlook.CreateItem(olMailItem) With objMail If Text83 = "No" And Text194 = "1" And Text221 =...

Can someone help me?? My database automatically sends an e-mail containing all the information that is entered on a new record. However, there is an ole object on the form that I want included in the mail as an attachment. I cannot work out how to do this.