Recent content by TCalvert

My database is split front end and back end and I wondered how best to secure it? I have a password on the front end which is shared with users but how do I secure the back end as this could potentially just be opened with access to all the tables. I know I can convert to an mde but I...

Minty, I have got this working, thank you so much for all your help. I have added an extra bit of code so it moves the pdf once it has been emailed. I am just wondering how easy it would be to include another report or two to automate once this first report has been produced.

that is fantastic, I will give it a go. Thank you so very much, have a wonderful weekend.

that has worked!!!! You are an absolute star. So can we now program automatically emailing the reports?

OMG that is with my glasses on too!! Right that is fixed and it works except it is asking for output each time and I have to select pdf, also when saved on the network drive they are not saving as .pdf it ends after the email address.

Minty I have changed the code to the exact query and report names but the report won't open stating it doesn't exist, what have I done wrong :( Private Sub cmdProduceReport_Click() Dim rs As Recordset Dim strSQL As String Dim strWhere As String Dim strFileName...

Thank you, I will give this a go tomorrow.

Sorry!! It is just this DoCmd.OpenReport "rptDetails", acViewPreview

Minty thank you for taking the time to reply to me and I am opening all 80 reports at once.

Currently they are opened just by using the docmd.openreport function which opens all the reports. The query has the email address in it.

Minty I am creating the reports in the database and have 80 different reports to send to 80 different emails.

I am not sure how they can be saved and identified though as the email address to send is in the database.

I have over 80 pdf reports that I need to email automatically. Do I need to run a program to open each report individually to email, each report is going to a different email address. Thank you in advance.

Thank you, I will try disabling the leasing.

Yes they do, it is stored on their C Drive and the data back end is located on the network drive.