Search results

I'm going to head off to bed I report back tomorrow how I get on :)

oops code now added

right............... this works but I only want it to loop the records in the subform that are link to the main form as at the moment its looping the whole table that is link to the subform Dim olApp As Outlook.Application Dim outMail As Outlook.MailItem Dim objOutlookAttach As...

you are far too quick I submitted the thread then noticed the code tags were missing and then edited it lol:cool:

here's a hardcoded version Sub Mail_workbook_Outlook_1() 'Working in Excel 2000-2013 'This example send the last saved version of the Activeworkbook 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim OutApp As Object Dim OutMail As Object Set OutApp =...

yeah the first bit works perfectly I think you jumped on the thread to quick before I edited it lol.I updated the code as saw an error and I can get it to work on the main form issue I am having is getting it to work with the sub form ok I ll make the code your requesting thanks for the help...

hi , vbaInet this what I have so far my understanding is rschild is the sub form with this code below I get a runtime error 91 object variable block Private Sub sendtest_Click() Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim OutlookAttach As...

how to add attachments to email using a subform field for the attachtment paths hi ,all I m wondering how to add attachments to a email using a sub form were I store the attachment paths e.g I have a main form called frmteaminfomer with various fields and continuous subform called...

thank plog penny has dropped finally bit of dumb moment for everyone else it is find next DateAdd("m",[Months],DMax("[ServiceDate]","[PlantServiceTbl]","([ImpPlantItemID]= " & [PlantItemID] & ")")) cheers again plog shane

hi, all I just wondered is it possible to add my dateadd calculation to my findlast calculation using dmax in one column in my query here's what I hoping to put in one column as at the moment it takes 2 findlast: DMax("[ServiceDate]","[PlantServiceTbl]","([ImpPlantItemID]= " &...

thanks Paul Work's like a Charm yeah see where your coming from makes sense something that I will looking into when I get some more time I rest a sure I will be probably bug you again for some help when I get round to it bound to get stuck. Anyways at leased the code above is now working to...

hi, all hope someone can point me in the right direction I have 2 fields on my form service interval combo box and vehicle mileage text box I m trying to create a pop up message on there values if service interval is 12,000 and the mileage entered in the vehicle mileage is over 12,000 then...

hi , all right I'm hoping someone can point me in the right direction i have db that tracks vehicle mileage and servicing i have created query to show which vehicles are due service by the mileage my issue is some manufacturers set different service intervals e.g car manufacture A =...

yes thank you works better this way so the user can easily see what courses due or overdue for that in employee and does not display ex courses on the new form but the main form show's all the courses the employee has done even ex courses which what I want for course history :D thanks shane

sorry try this :)

hi, VbaInet just update I have solve this issue by a slight redesign by making query to show course due in 30days and courses over due and making ex course =false as criteria then using this to power a new form I don't no why I didn't think of this before if I did have textbox showing the...

I tried that but it still shows 10/04/14 is next due date even if this record is ex course record :confused: and another issue is if there are no ex course records the next course due date text box goes blank thanks shane

I do like a bit of orange lol:p sorry some reason I was having trouble uploading the screen shots as a file so I had to zip them. :confused: but on the over hand I could of made one zip file :banghead: no worries thanks again shane

hi, vbainet as requested I have made screen shots before ex course is true and when ex course is true and I have made a temp base to show you the code in the text box I have added speech bubble to my screen shot to explain more:) thanks again shane screen shots...

right. I put this in my text box control source on sub form =IIf([ExCourse]= False, DMin("Expirydate","tblcourses","[ID]=" & [empID]), Null) it does show the next due date but if I make the next course a excourse and go to another control it still say's the same date doesn't find the next...