Search results

Gasman, did not work for me the way I wanted, left it alone while I pursued other projects, Now finally have it working using a complete set of new code found elsewhere and adopted Dim oOutlook As outlook.Application Dim oemailitem As MailItem Dim myAttachments As outlook.Attachments Set...

JHB, brilliant idea, I will run a separate dcount query first to check if any matches, if not then run the query without that parameter. can do this in VBA, just need to work out the details, but like the principle thanks for your help Regards Dean

SQL: SELECT Tbl_Quotes_Details.QuoteNo, Tbl_Quotes_Details.CreatedDate, Tbl_Quotes_Details.CustomerNo, Tbl_Quotes_Details.SiteNo, Tbl_Quotes_Details.SiteName, Tbl_Quotes_Details.EmailedTo, Tbl_Quotes_Details.TotalCost, Tbl_Quotes_Details.documentlink FROM Tbl_Quotes_Details WHERE...

I think I am having a mental block here, I have a select query based on 1 table, and want to filter the data from 2 combo boxes on a form.. so good so far, pretty standard stuff, however both of the combo boxes will always have a value but the column in the table may not (it will be null)...

Gasman, cheers - we give it a try and let you know Dean

BUMP been on other projects for a while, but now back to this :banghead: still stuck with attaching more than one attachment - can anyone help Thanks

Now hit another problem, I need to multiple attachments, previously I have used a loop and used .attachments.add to do this, however using this method I only get the last attachment. I know I need to create an array but I am stuck on how to achieve this - can anyone help Thanks Dean

Sussed it, if anyone wants me to post the full code - just let me know Dean

hi, I want use this code (thanks for posting it) as I have several functions that send emails with attachments and this would allow me to clean up the code by using 1 function, but.... I need to add a category for some emails at the point of sending and I cant suss out where I would insert...

Cheers, bit of tweaking and that worked Dean

Sue, I have had the same barrier as you, however i found using a wizard when needed then converting the macro to VBA pretty painless to be honest Regards Dean

Bob, thanks for your help - tried that, kept crashing the app when used with the runtime. Solved it though - Knew it would be something simple Just changed the install path when creating a runtime package to C: drive then did the same for the backend loaction on the PC I am using for...

Can I put my 2 penny worth' in bit of topic I know - but bear with me I set up a small network using a switch, cat 5e cable, a HP microserver (£250 with a£100 cashback) and a copy of windows home server 2011 (a very underated product) @ £39, - total final cost with 2 extra 1tb HD = around...

Hi, I may be missing something simple here I am finishing off a access app that I am hoping to sell using the 2010 runtime if the end user does not have access installed. Now my problem - I have split the DB so if I need to perfom upgrades I do not wipe out existing data. I have done this...

I think apple produce some lovely kit ( at a stupid premimum price though) - I don't own any though. What really gets my goat is the media love-in with apple, the stunts they get up to, if microsoft attempted would be up in front of EU as quick as anything (Itunes anyone)

Not been near this project for a few weeks - I have carried on regardless with the rest of it - noticed something whilst doing this, if I open the report in preview using VB - no errors come up - stranger and stranger still :banghead:

Hi guys, weird one this - always is with me :confused: I am using Access 2010 to build a apllication that produces a report with a unlinked (ie now child/parent fields) sub report. If I open the report in any view except print preview the report opens fine (will even export as a PDF). BUT...

Don't know if I am doing something stupid here I have a combo box populated by a select distinct query that list all the current used suppliers, first column = refno, second column = supplier name. a text box is then populated with the value in the first column this combo box is then on a...

I had an amiga 1200 (God I loved that computer - heart broken when it died) it was at the time years ahead of the IBM PC and windows, I went to the local computer shop and bought 1 meg of RAM for an expension/accelerator card I had got mail order, it cost £100, the guy gave me a 4 meg stick by...

My experience is very much like beetles, I am an ex Truck driver, I decided to change careers and went to work in an office for less pay 20 odd years ago. I always had a intrest in computers but never any money ( you cannot belive how expensive they where back then) asked to create a...