Search results

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...

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 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...

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)...

Hello I have some code that I kindly found online that creates a batch file which closes the current file, deletes the current file and downloads another one from a location and reopens. All works great, however it leaves the batch file on the place were you run this code, my case the desktop...

Hello, I have a form that you populate, once done, the user clicks on the send report button, It sends it as a PDF. Once the outlook email box comes up with your attachment and you send it, you have no issues. If however you click on the send report button and the outlook email box comes up...

Hello the dream team :) I have a database that has over 600k records and will not append but I can export the data into a spreadsheet put in new records from a report that is ran into this spreadsheet and upload it back into the table for analysis using the wizard. I have got the code to...

Hi my name is Mark and have a good understanding of Access and learn new things all the time and feel quite confident in creating databases. I hope you can help me. I have a table called tblUploaddata and one field is called Week set as text, it has data like Week 1 P1W1 and Week 10 P10W4...