Hi ProgramError(!?),
I know all about DoCmd.SendObject - but you are missing my requirement - to send EXISTING files as an attachment - not ones that are generated from MS Access - ALSO - I have a problem with DoCmd.SendObject as when I try it with EDITMESSAGE = FALSE then it fails on various...
Hi,
I have a variety of files that I need to e-mail based on certain conditions.
i.e.
On C:\myfilesToSend directory I have
Case1.xls
Case2.xls
Case3.xls
I have some logic that sits in a module and determines which file should be sent and which e-mail to send it to - easy!
But I cannot...
Okay - I have over ten years with Oracle - so Oracle perspective.
Oracle too has event driven forms - 6i / 9i they have triggers at more levels in the form than you could dream of in access.
Oracle forms are distributed without (excess) desktop prescence thanks to the 3-tier architecture -...
Also try .NET express - there are some very nice tutorials on line you can get started for no outlay and it has a number of very nice built-ins / templates - you may never look back...
I used to be an access man.
Then I found Oracle.
Sure it takes me longer to build a solution BUT the power and scope of the solution means I would not dream of going back to my Oracle days (I found myself on this forum as someone needed a cheap as chips solution - I would not dream of Access...
Thanks for that..
I found the problem was with the client machine I was on - the code works fine on another desktop - but adding the final , false to the use of SendObject - helped also...
BTW - my report is coordinated to the form by means of a condition on the report which references the...
Hi,
I am using Access 97 (no choice here - so please don't recommend upgrading!) and attempting to send a report via e-mail in a loop using module code (see below)
All works okay EXCEPT when I set the last parameter to FALSE to not edit the e-mail before sending - then the result is a zero KB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.