Recent content by cchristi

That's what I need today - saving my report to .pdf. I send/save Excel wkbks in Adobe, but can't figure out why the same 'OutputTo' won't work thru Access. The OutputFormat to use is acFormatRTF. Oddly enough, the next part of the code is DoCmd.PrintOut. The prompt for a file name comes up...

Hi kaatjev Yes, I got it to work, but there is still too much user entry. I believe the problem is I don't know the Novel extensions. (i.e. *.bodyText *.Subject *.Recipients.ADD etc.) By trial and error I figured some/enough out, but still haven't figured out a way to pass the minimum...

Question: Does anyone know Novel's allowed object extensions? The same Q for Faxcom's extensions. Background data relating to the question: I created an application in 2003 which faxes an Access Report and attachment to persons stored in my Access tables. Although faxes are going out, there...

Thanks Ken, The following is from my Excel code: bCloseX = MsgBox("Close Xdisk File", vbYesNoCancel, "CLOSE COMPANY XDISK FILE") Select Case bCloseX Case vbYes Windows(FileNbr).Activate ActiveWorkbook.Close (False) On Error Resume Next If...

I have 2 two year old Excel and Access applications, and a new Access application, which suddenly have started ignoring the On Error Resume Next & On Error GoTo commands. Within the last 2 months we have upgraded to Access 2002, and within the last month we have been applying the security...

The SendObject Method is : expression.SendObject(ObjectType, ObjectName, OutputFormat, To, CC, BCC, Subject, MessageText, EditMessage, TemplateFile Good Luck.

Eupher, my code sends a 'Task'. It can't be that different to send an appointment. As a trial I changed the dim to 'Appointment3' and ("GW.MESSAGE.TASK") to ("GW.MESSAGE.APPOINTMENT") and commented out some lines that were clearly pertaining to sending a task. It worked...

Hi Steve101 Did you ever get the code to run in FaxCom? My current project is to automate sending faxes, with attachments, to persons in our Access Database. I am currently creating an email, attaching the body etc and having it save the email for subsequent manual input in the 'Fax Address...

Snapshot (.snp) is a free Microsoft product. What I like about it is that it provides a .pdf style doc that is only a fraction of the size. If you would like to try it, here's the address. http://www.microsoft.com/accessdev/prodinfo/snapshot.htm Thanks again.

Thanks HenryAnthony and Eupher! I struggled with SendObject for several hours yesterday and it wasn't compatible with the rest of my code. Also, it doesn't allow sending in .snp format. Who wants to completely rewrite their code anyway? [wink] Eupher, I am so excited about Dmitri Furman's GW...

Hi n2jesus, Here is some code that works. SELECT CROSSCHECK_RESULT.COCODE, CROSSCHECK_RESULT.RESULT_TYPE, VALIDATION_RULE.DESCRIPTION FROM VALIDATION_RULE INNER JOIN CROSSCHECK_RESULT ON (VALIDATION_RULE.VALIDATION_RULE_ID = CROSSCHECK_RESULT.VALIDATION_RULE_ID) AND (VALIDATION_RULE.YEAR =...

By searching the net, I have been able to put together some code to automate sending Access reports via Groupwise attachments. The one problem still unsolved is trying to attach another recipient as a .BC, or as a .CC Does anyone know the code? The code to attach the 'To:' recipient is...

Have you tried putting the following in your critera: Is Null Or "*" ?

I'm not sure what the solution is, but I found some code in a different Forum that got me past the prob. Try: Set gWAccount = GWApp.Login("user", "password") I found that it ignors the "password", and if GW is not already open, prompts me to enter my PW. My...