Search results for query: *

Hi everybody, With help of this forum I was able to create a VBA code that helps to send two attachments in one email using Access. This code works perfectly. However, when I run this code with a form or via a macro Access sends the same email three times. It looks as if it is in a sort of...

Hi everybody, With help of this forum I was able to create a VBA code that helps to send two attachments in one email. This code works perfectly. However, when I run this code with a form or via a macro Access sends the same email three times. It looks as if it is in a sort of loop. I have...

It is unbelievable, but if I run the VBA code in the VBA programme I receive one email. And if I run it in a form or with a macro I receive three emails. I am doing nothing special, just making the command SendMessage

I don't know how but i have succeeded. However a new problem has arisen. This is the vba code i use: Private Sub Knop43_Click() On Error GoTo Err_Knop43_Click Dim stDocName As String stDocName = "Macro3" DoCmd.RunMacro stDocName Exit_Knop43_Click: Exit Sub Err_Knop43_Click...

Indeed I am using outlook to send email. And I have checked that there was a check in the box of the Outlook 9.0 Library (it is possible to send email via a macro so that can't be the probem, i guess). The problem is still there, unfortunately. Using the code Paul suggested the error is in...

Hi ChaZ, Thanks for your answer but it just isn´t working yet. My knowledge about VBA is zero so i think i need a complete code. the problems start in the following sentence Set ObjOutlook = CreateObject("Outlook.Application") Is there something i have to adjust here? Thanks a lot!

Hi, I have a small problem with which I need some help. I want to use a macro to convert two access-reports to .rtf and paste them in ONE email. Now I have used a macro with the step 'send object' in which I define the options to convert to rtf and the persons to send the email. When I use two...

I deleted all the relationships between the tables. In total I have 8 tables spread over 4 pages. The 8 subreports are inserted/pasted in one main report. In each table there are 13 identical records (in the first field). The report of 4 pages is then repeated 13 times leading to 52 pages. If I...

Hi there, This my problem. In a report I pasted a number of tables (subreports) that should be independent from each other. In the head report the number of pages is 52 in stead of 4. the problem is that the head reports shows the first 4 pages again and again and again. The solution has to be...

Excuse me, I made a mistake in regard to my previous post. The error message is as follows: Fault -2147221164 (80040154) during execution Class not registered I hope this helps.

OK, this is the wording of the error message: Fault 438 during execution This feature or method is not supported by this object thanks in advance

When starting my Access-database today, the switchboard didn´t function anymore. Using problemsolving the following problem appeared on my screen in the program Visual Basic: Set con = Application.CurrentProject.Connection. Visual Basic is a new programme for me and I don´t know how to handle...