Search results

Thank CJ Can't seem to find a post that relates to actual navigation in google maps hence why I am thinking I may need to somehow launch the app not the web address. I can load maps with my address from form without any problem but only gives me an option to send details to phone for...

I am currently using the following code on a Cmd button to load my next address on google maps for various work locations during the day. The problem is google maps through the website will not allow me to access the navigation option, I think this can only be done through the app. Sometimes I...

Thanks so much exactly what I was trying to achieve. I had been trying to write that bit of code myself but for some reason I wasn't using the form name I assumed for some daft reason it would automatically use the current form. Thanks again for your support

Brilliant, works great. Really helpful! To complete this process I want the pdf to be saved with the file name as detailed in the code "Development Pack" plus the field from the form "Projectname" The PDF file should read something like: Development Pack (Project Name) That way each record...

Hi Sorry little bit lost there. I have replaced that line of code but still saves the pdf report with all the records on not the specific record I am on. was I suppose to do something else? Thanks

Hi Can anyone help with this. I currently use the following code to save a report as a pdf to my desktop. that all works fine but I need to somehow make sure it saves the report for the record I am on in the form. At the moment it just saves the first record. I do have ID fields on form and...

Ok so I have created the Cmd and used the follwoing code again to save the main report which contains the sub reports to a PDF onto desktop. Thats working fine, thanks so much. Now all I need to do is get the report to print based on the record I am in so linked to the ID of each individual...

Thanks So simple. Didn't even realise I could add a sub report. I have just also realised that I have no code that will let me print the report specific to the record in the form I am in. Would this be difficult to add to my existing code I uploaded. I do have an ID field would that help...

Hi I use the following code to save a report as a pdf to my desktop. All works fine. At the moment it save the report: rptDevPackPage1 I want it to also include: rptDevPackPage2 but only create one saved pdf with both pages on. In summary save two reports into one pdf file. Is the...

Hi Thanks I am getting the following error when I try this code: Compile Error: ByRef argument type mismatch With this part of my code highlighted: Private Sub Command351_Click() 'ExecuteFile strFileName, "print" Dim strFilePath As String strFilePath = "Z:\GasCertificates\" &...

Ok maybe a little lost here this is what I now have Have I lost the plot? This is now my Cmd Button: Private Sub Command351_Click() ExecuteFile strFileName, "print" Dim strFilePath As String strFilePath = "Z:\GasCertificates\" & Me.txttwenty & ".PDF" If Dir(strFilePath) > "" Then...

Hi Arnelgp Thanks. Where is this code suppose to go. As a module? or on the click event of a cmd button? Im not very experienced so takes me a little longer to understand what I am looking at.

Hi I have a form with the following code on a Cmd Button to view a scanned or saved document for some fire safety certifciates. The scanned docs are saved in a generic Z:\ witht he file name always equal to the relevant property code. I now want to be able to print that same document from...

Here is the Cmd code: Private Sub Command181_Click() If MsgBox("Warning! You are about to send a LIVE JOB SHEET to a Contractor. Do you wish to continue?", vbYesNo) = vbYes Then 'click the Yes Dim strDocName As String Dim strPath As String strDocName = "Report" ' save report to...

Thanks I have now sorted the message box and read receipt. I am still trying to figure out how to stop my db from displaying the report in the previous code before it sends it. I have commented out the .display code but it still previews the report and leaves it on screen whilst the report...

Thanks Minty Would this be the correct place for the code? In the module? Thanks Public Function CreateEmailWithOutlook( _ MessageTo As String, _ MessageCC As String, _...

In simple terms: I have db local on my machine and several others I work on. All my tables are then linked to Sharepoint site so that the data is a) Secure and B) accessible from all machines with live information. The problem I am having is for example with my tblcontacts and frmcontacts...

Thanks excellent work thats now emailing. Only issue is when it sends it displays a generic report that stays on screen ideally Id rather not see that at all. Couple of other bits of advice. Now that sends using Outlook automated email can I somehow request a readers reciept so I know the...

Hi Uploaded a second copy of db as may find first copy forms record source was incorrect. I have created a test record on the form frmJobSheet hope that helps thanks

Hi I have uploaded a copy of the database due to protection of data it holds I have simply recreated only the relevant forms tables etc Thanks