email right click

[colinod]

i have to set up a access database with details of mp3s held on company server with the facility to search them, i need to know if it is possible to right click on a found mp3 in the database and send the file it lists by email just like you can with an image on a website thanks

[MMcCarthy]

i have to set up a access database with details of mp3s held on company server with the facility to search them, i need to know if it is possible to right click on a found mp3 in the database and send the file it lists by email just like you can with an image on a website thanks

Access does not have an on right click facility.

Your options would be to use the on click, on double click event or a command button. You can then use the send object method to send the information by email.

[colinod]

where do you set this up from i amm very new to using access for this

[MMcCarthy]

where do you set this up from i amm very new to using access for this

I'm speaking of vba.

If in form design you right click on the textbox containing the data and open properties then look under the event tab you will see a list of the "events".

Choose an event (like On Click) and click on the little arrow to the right. Select [Event Procedure] from the list. Then click the button to the right with the dots. You would add your Send Object code to the blank event procedure that appears.

[colinod]

thank mmcarthy i have tried what you said but im afraid i have never used vba before i get as far as the input code point but im not sure what to put or exactly where, this is what i have so far

Option Compare Database

Private Sub Command8_Click()
On Error GoTo Err_Command8_Click


Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command8_Click:
Exit Sub

Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub

Private Sub filename_Click()

End Sub

[MMcCarthy]

OK so in Private Sub filename_Click() try something like the following:

Option Compare Database
Option Explicit
 
Private Sub Command8_Click()
On Error GoTo Err_Command8_Click
 
 
    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
 
Exit_Command8_Click:
    Exit Sub
 
Err_Command8_Click:
    MsgBox Err.Description
    Resume Exit_Command8_Click
 
End Sub
 
Private Sub filename_Click()
 
DoCmd.SendObject ObjectType:=acSendNoObject, _
Subject:="mp3 details", _ 
To:="Tom Jones", _
EditMessage:=True, _ 
MessageText:=Me!filename
 
End Sub
 

[colinod]

this is not quite what i was looking for i was hoping for it to be sent using outlook or outlook express so we could enter an email address etc thanks anyway

[MMcCarthy]

This will open outlook or outlook express. Just change 'Tom Jones' to whatever email address you want. For example ...

Option Compare Database
Option Explicit
 
Private Sub Command8_Click()
On Error GoTo Err_Command8_Click
 
 
    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
 
Exit_Command8_Click:
    Exit Sub
 
Err_Command8_Click:
    MsgBox Err.Description
    Resume Exit_Command8_Click
 
End Sub
 
Private Sub filename_Click()
 
DoCmd.SendObject ObjectType:=acSendNoObject, _
Subject:="mp3 details", _ 
To:="[e-mail]", _
EditMessage:=True, _ 
MessageText:=Me!filename
 
End Sub
 

[colinod]

sorry to be pain but i have tried this and am getting the following in an alert box

The expression On Click you entered as the event property settign produced the following error:Ambiguous name detected:Command8_Click
* The expression may not result in the name os a macro, the name of a user defined function, or [event procedure]
*There may have been an error evaluating the function, event, or macro

[colinod]

its ok i have sorted it i made the mistake of not replacing the whole script thanks

[colinod]

ok i have got it to open the email but i am trying to attach an mp3 file from a folder in our network have you got any ides an this maybe the way it is written in the access database

[colinod]

Hi all

The code used also adds the mp3 just as text in the message and not as an attachment????

[MMcCarthy]

Hi all

The code used also adds the mp3 just as text in the message and not as an attachment????

Sorry I misread your original question. Attaching something that is not a database object like an mp3 file will require much more complicated code.

To see what I mean have a look at these two other questions for two ways of doing this.

http://www.thescripts.com/forum/thread706529.html
http://www.thescripts.com/forum/thread553562.html

Mary

[colinod]

Sorry im afraid i just do not understand the codes its beyond me at the moment????

[MMcCarthy]

Sorry im afraid i just do not understand the codes its beyond me at the moment????

In all honesty I think it is. You need to get a good grounding in Access and VBA before attempting something this complicated.

[colinod]

ok thanks anyway i will go back to trying to do it with a web form and asp