Recent content by racer25

Hi Everyone, I have had a good search and can only find the complex questions/solutions whereas I think I am looking for something quite simple ( I hope ). With the help of members of this site - I successfully put together An Access DB that pulls data from our Oracle DB, produces reports and...

Many thanks madefemere - works a treat!

Hi All, I am looking for the smart way of doing this rather than the laborious. Within my table 'Contacts' I have the field 'City' which as you would expect contains the city. The data in the City field which is sourced from the web can often merge two regional municipalities into 1 and I...

Hi All, I have the following script which creates between 2000 and 3000 statements. I have another part that attach's this to an email and sends the message. Its a single page PDF with relatively plain text is there away of reducing the size of the PDF from around 500KB to something at least...

Hi jdraw, Thanks for taking a look at this. Am I correct in thinking that this would only tell me that a message had failed but not tell me which message nor log the error's. I like the idea of being able to log the error's and thus hand someone a list and say "fix this". I could run the...

Hi All, I have a rather nice (if I do say so myself) DB that pulls data from our Oracle DB, runs various queries via VBA buttons and emails out using Outlook 4,000 + statements to our customers. I would love to take credit but several bits of the code is recycled from here.... The challenge...

Thanks a million - spent too much time on this today so will have a 'play' tomorrow.

Thanks for reading - however the solution is one that I had working which assumes I have multiple accounts. In Exchange, I have only 1 account and I think 'namespace' gets involved.....

Hi All, Historically we were able to send an email using multiple accounts in Outlook and I have the VBA below that would pick the account to send the email from. .SendUsingAccount = OutApp.Session.Accounts.Item(1) We have now moved to an Exchange Environment and I have 1 Account, but within...

But thats exactly what I have done.... Sub Report woks fine moment I drop it onto main report.... curtains.

Re: Sub Report with a Top (and bottom) 10 Thanks for the prompt response. And Forgive me if I have the process wrong. 1. Create Primary Table - all data - Done 2. Create Query Qry_Top10 - Done 3. Create Query Qry_Low10 - Done 4. Create Sub-Report - Top10 - Done 5. Create Report -...

Hi I am trying to create an Exec Summary of our earnings data Each report is grouped by Servicer. The Report needs to show overall totals etc budget client and then I was looking at two sub-reports; 1. Top 10 better than budget. 2. Top 10 worse than budget. I have a query that displays...

James - Thanks All seems too easy is their anything weird and wonderful about passing a date/time through this method. I would imagine delay is the eas(ier) part. Cheers, Rob

Hi I am trying to make something that I have cobbled together run a little more efficiently. I have coded a deferred send time - what I would like to do is pass this from the form. So I would like 2 boxes date/time to start delivering and a seconds delay box. I have tried a couple of...

Hi All, Forgive me I have tried (and tried) to resolve this.... My coding skills extend to taking other peoples work and customising to fit my own requirements which so far as served me well. The process I have a problem with is we send our client statements out by email if their is an email...