Search results

IT have finally come back. Due to me testing the code using my email address several times for testing purposes, our email server didn't take kindly to it having the same email address in the 'To' and 'cc' lines. It was simple as that, it's now really slick - apologies for this, I did...

Hi again I've stripped the reliance on qryEmailRecipients (query containing list of email recepients) out of the equation and also the attachment. I've simply put 6 email addresses (all the same addresses) into the 'To' and CC lines of the code. To formalise what I've already outlined, but...

Anyone else experience this sort of behaviour? Wondering if I could get some pointers for the IT crowd

The code surprisingly zips right through to the following line in about one second (upon attempting to sending to 6 email recipients. objMessage.Send Putting a break on the following line and the code takes approximately 25 seconds to run MsgBox "Thank you, your report has...

Great, if something is slowing this down, here goes: Option Compare Database Option Explicit Public Sub EmailFromNMQuery() Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory. Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the...

Apologies Continued to play about, misinformation re the manually inputting of numerous email addresses straight into the VBA. It takes forever as well so looks like it's not the code that I've posted but the number of recipients. Using CDO method, avoiding the Outlook prompts etc, to...

Hi I've adapted the following code to email a report based on the values of a query. If an individual is ticked, they will receive an email with a report attached. All goes well.... if you have the patience of a saint. In the event that 1 person is being emailed, it takes approximately 5...

Thank you so much. Your prompt and comprehensive solution has ultimately led me to cancel my Exp's Exchange subscription (posted same problem over a week ago with little in the way of assistance), saving me almost £14 a month and lots of my hair. Keep up the great support

Hi all, I'd like to be able adjust the colour of a column chart (on a form) depending upon the series being graphed. ie Lab is blue, Office is green etc. There will only be 5 different series (areas) but the parameter query upon which the graph is based may have no data for the Lab in certain...

It's possible to link Access to MS Visio - I've got some code if you're interested in pursuing this option. Very easy to produce professional looking drawings particularly if it's quite intricate.

Thanks for the reply. In order for my head to get around this I decided to separate out the calculations. ExpiresMonthsNZ: Nz([ExpiresMonths]) ExpiryTypeNZ: Nz([expirytype]) CompletedNZ: Nz([completed]) Then I decided to strip back my original calculation to my dateAdd expression...

Hiya, been attempting to avoid #error values in a query when [expirytype] (a numeric field),[expiresmonths] (numeric) and [completed] (date) are blank Step1: IIf([expirytype]=2 And (DateAdd("m",[expiresmonths],[completed])>Now()),(DateAdd("m",[expiresmonths],[completed]))) My research has...

Thank you, developed a listbox containing contents of PositionReqsEmployeeTrainingQuery2 so that a double click and the employee's training records appears in an editable, filtered form :D

Hiya, have attached the database. I'd like to be able to update the 'CompletedDate' in the 'PositionReqsEmployeeTrainingQuery2' if possible. Thank you

Hi Thank you for the advice. I created a query (Query1) based on tables tblEmpOccupiesPosition and tblPositionTrainingRequirements joined on JobpositionID. In order to avoid an ambiguous outer join by adding the EmployeeHasTraining table to Query1, I created Query 2. Query2 contains Query1...

Hello all! Have set up a database as per one jdraw's recommendations in a previous post (see attached), I want to be able to query both 'EmployeeHasTraining' details at the same time as 'PostionTrainingRequirements'. In other words, how to show training completed to date plus what further...