Forum Discussion
MS Access Email Report
No worries! We all started at the beginning!!!
2 Ways:
- Ctrl + G
- Atl + F11
Daniel
I gave it another go, I didn't get the errors I previously got but I only returned blanks in outlook. I have attached a snip of how i filled out the formula. Could you please let me know where i am going wrong. Thanks.
Sorry for the delay, I'm not on this forum very often.
What happens if you try that in the VBA/VBE Immediate window? This is truly the best place to fiddle with creating a DLookUp and testing things until you get the result you're after. Then just copy it back into your Query/Macro/Form/Report.
Sorry I'm having a bit of a hard time with the image, but is there an underscore in the field name Email_Address in the table design, Or is it a space and therefore it should be "[Email Address]" in the DLookUp()?
Is Contract Number a String or a Numeric field? If it is numeric, then it should be "[Contract Number] = SomeValue" (no single quotes around the value).
Yes there is an underscore in the field name Email_Address. Contract Number type is 'Single line of text' in the Sharepoint List.
You may by now have noticed that i have very limited knowledge when it comes to computer programming, I have built the database to date via YouTube.
I am prob sounding very stupid but how do i open a VBA window for this button?
No worries! We all started at the beginning!!!
2 Ways:
- Ctrl + G
- Atl + F11
Thanks, It Works!! now on to the next hurdle. Thanks again for your help