Concatenate Email Addresses as a Query Result

[crwilliams]

I think I may not know how to attach it.

 

[crwilliams]

so now I am getting an Ambigious name detected: SendeMail

 

[GinaWhipp]

You can't name the Module the same as the Function. Name the Module modSendeMail.

 

[crwilliams]

now it says ambigious name Command_19Click as well as I had it set to pen the form on load and now instead i get that same error as well when i open the database

 

[crwilliams]

when i click on my form in vb it is set to command19 and click. when I click on the modsendemail it is set on the same. both places show the code

 

[crwilliams]

and now I'm back to expected error

 

[crwilliams]

how do I fix the Compile Error: Expected end sub? The debugger is set at the Private Sub Command19_Click()

 

[crwilliams]

When I try to delete that line it tells me it will reset my project.

 

[GinaWhipp]

Sorry, it's the 4th and I'm trying to get ready for guests...

Sounds like you need to add an End Sub after the SendeMail line.

 

[crwilliams]

I am going to attempt to work on this more today to figure it out. I did not have much luck on say or sun.

 

[crwilliams]

I can not figure out what I am doing wrong. I keep getting the same outcomes, either the ambigious error or the expected sub error or absolutely nothing happening at all. Any ideas what I could be doing wrong? Am I able to attach and you could take a look?

 

[GinaWhipp]

Ambigious error means you have entered something twice. Expected Sub means you forgot the End Sub line. So, please copy everything you have behing the Form that has the button and post it here. And, please everything, not just the section that has to with the button.

 

[crwilliams]

I have attached a database with the form.

 

[GinaWhipp]

A few side notes...

When you get an Ambiguous Name detected error it is the result of an Event Section appearing two or more times behind the same Form, i.e.

Private Sub modSendeMail_Click()
Private Sub modSendeMail_Click()
 
End Sub
End Sub

The Expected Sub message was because you entered so many of the routines two of them where missing the End Sub line.

You were also missing an important Reference...

Microsoft Office 14.0 Access database engine Object

...since it's automatic I'm not sure hwo that got unchecked. I did not test, only cleaned up code and compiled.

 

[crwilliams]

Hello again,

I really appreciate your help but when I try to make the changes in my database I am having much difficulty.

I do not have "SendeMail" as an action. I only get declarations for General. You have the code in General then SendeMail and I only seem to be able to put it in cmdSendeMail and Click. I am assuming you removed the module since I can not see it? Is it safe just to delete my form and import yours? Is all my code for other buttons still in there?

 

[crwilliams]

Also, where check the "Microsoft Office 14.0 Access database engine Object"?

 

[GinaWhipp]

The *SendeMail* is not a Macro, it's code and I added it behind a behind a button on the Form. So look at the button and the Event Procedure. The *other code* did nothing so I removed, you're using embedded macros so I *think* it's safe to just use mine.

Follow these steps to get to Forms Module...
http://www.access-diva.com/d5.html