Recent content by Waddy

I have used the sendObject function but this does not work for some users (most) but it did not work for a couple. This method works for everyone.

DoCmd.OutputTo acForm, "frmPalletIssueFormWarehouse", acFormatPDF, fileName, False Error on this line, as soon as you take delete function or code out it all works as it should.

I am having a problem :), I think the code works. As you mentioned I have issues with it deleting before it sends as I get an error on the output line of the code. I tried to delay by running a separate function after the ok button on a message box was pressed via marcos after sending. I was...

Thank you, I will give that a shot :)

Hi, I hope someone can help, below is code that pdfs the current form and puts in this in an email using outlook to the users inputted into the code after clicking send on the form. At present this leaves the PDF file in the directory the access file is located. Is there some code I could add...

Gasman, thank you!!!! It all now works!!!! amazing. Now to tidy it all up and do some testing.

Thank you gas man, that works a treat. Now I just need to know how to do a calculation field in the total miles :)

Thank you I will have a go.

That's correct I do need this info to be binded, so can anyone recommend any work rounds? Thank you

I have just tried the following in the control source but it does not work =DMax("EndMileage","tblMileage","VehicleReg='" & [Me].[Combo10] & "'") Sorry

Hi Gasman, Would this go into the control source? I will be doing better control names in the final version, just doing this for testing. Thank you so much for your advice and support in this?

Thanks for letting me know about the table, I have done a new thread with local tables and deleted the last one. I hope you can help :)

I am currently trying to get my form to show the last mileage in the start mileage text box and then you type in the end mileage in the end mileage text box and then calculate. I have got it to put in the site and date etc when you select from the combo box but cant get it to show the last...

Hi All, I have a query that shows what training an employee has, how would I go about showing what training he/she does not have in a query. (Indicates Primary Key On Each Table) I have a list of training courses in a table called tblCourses (CourseID) I have a table called employees...

Hi theDBGuy, Never tried on paper but would imagine it would do the same. I am using the built in macros on click function, selecting report, report name and export as PDF. Hope this helps. Thank you again