Search results

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

Hi All, I hope you can help, When I PDF a report using the export with formatting, my report is producing 3 pages first blank send with detail and third blank. How do I remove pages 1 and 3. Is this something to do with Header and Footer? I have removed these on the report but is it a...

The Doc Man, Wanted to do both for practicing my VBA skills and this also work. Thank you all, you really are a massive help!!!

Thanks DBGuy, This did the trick :)

At a stab myself would it be like below. Private Sub Empselectsicklog_BeforeUpdate(Cancel As Integer) On Error GoTo HandleError Me.txtOracle.Value = Me.Empselectsicklog.Column(2) Me.txtEmployeeName.Value = Me.Empselectsicklog.Column(1) Me.txtAccount.Value = Me.Empselectsicklog.Column(3)...

Hello all again :) I have some vba code below and I hope you can help, I want to add an error trap so if there is an error it deletes the current record and closes the window(Form) along with a messagebox. Below is my code: Private Sub Empselectsicklog_BeforeUpdate(Cancel As Integer)...