Recent content by Jack III

When using the wizard to create a lookup to a table I get this error: Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizard." I get this error only on my machine, not on others??? Any ideas It doesn't matter what...

ERROR-on one machine but not another Data cannot be retrieved from the source you have selected. You must select a different table or query to continue in the wizard." I get this error only on my machine, not on others??? Any ideas

almost I get an error that says "default e-mail program could not be started please check your settings. Any suggestions?

Does anyone know if you can capture the sender's(From) e-mail automatically without specifying in the code? Const cdoSendUsingPort = 2 Const cdoSendUsingPickup = 1 Const strSmartHost = "AppEmail.Tgt.Com" dim OMsg Set OMsg = CreateObject("CDO.Message") Set Iconf = OMsg.Configuration...

Here's a work around The code below works. Does anyone know if you can capture the sender's e-mail automatically without specifying in the code? Const cdoSendUsingPort = 2 Const cdoSendUsingPickup = 1 Const strSmartHost = "AppEmail.Tgt.Com" dim OMsg Set OMsg =...

Other ways? Is there any other way of getting around automation server in outlook?

I'm pretty new to VBA...How do I get the Redemption ActiveX Object??

The line it stops on Set SafeItem = CreateObject("Redemption.SafeMailItem")

When I put the following code in "after update" I get the run time error 429. ActiveX componet cannot create object. Any suggestions would be greatly appeciated! Public Sub SendMessage() > Dim objOutlook As Outlook.Application > Dim objOutlookMsg As Outlook.MailItem > Dim objOutlookRecip...

Thanks for the Input, but it didin't work for me thanks

Does anyone know the code to get around Outlook's Automation Security? I get the warning message when sending an auto e-mail from access. Thanks

It's not ZA it's Outlook's Automation Security Does anyone know the code to get by Outlooks Automation Security? Thanks

Hi, I'm sending an auto e-mail from Access to Outlook and I get (from what I've been told) a message from zone alarm. How can I disable this for this particular action? Thank you, Jack

any suggestions would be appreciated Private Sub Move_Completed_AfterUpdate() Dim NameSpace As Object Dim EmailSend As TaskItem 'for the task item Dim EmailApp As Object Dim strProjectID As Integer Dim strEmail As Object Set strEmail = Me.Email Set strID = Me.Project_ID Set EmailApp =...

zone alarm is there a way to disable the zone Alarm?