|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 21st, 2010, 07:52 AM
posted to microsoft.public.access
|
|||
|
|||
Email Button
I have added an email button to a form 'Chill intake', which looks at the
field 'Haulier' and then looks up the email address for the haulier in a table called 'Hauliers'. On click the button should open a blank email with the hauliers email address in the 'TO:' field. The form macro i'm using is =(DLookUp("[Email Address]","Hauliers","ID=" & ([Haulier],0))) However when i click on the button it causes an issue that closes Access down. Any Ideas? 
|
|
#2
April 21st, 2010, 02:09 PM
posted to microsoft.public.access
|
|||
|
|||
|
Email Button
Charno -
I think the ,0 after [Haulier] is a problem. I removed it. Try this (if Haulier is a numeric): =(DLookUp("[Email Address]","Hauliers","ID=" & [Haulier])) Or this (if Haulier is text): =(DLookUp("[Email Address]","Hauliers","ID='" & [Haulier] & "'")) -- Daryl S "Charno" wrote: I have added an email button to a form 'Chill intake', which looks at the field 'Haulier' and then looks up the email address for the haulier in a table called 'Hauliers'. On click the button should open a blank email with the hauliers email address in the 'TO:' field. The form macro i'm using is =(DLookUp("[Email Address]","Hauliers","ID=" & ([Haulier],0))) However when i click on the button it causes an issue that closes Access down. Any Ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
