Recent content by DNewman

Thank you for your reply. No - I have actually got the users to check that very thing today - if Word is open another instance does not open, so for the minimal inconvenience of having Word open the problem is "solved". The reason I have linked to a Word document is that the report (which is a...

I have an Access 2016 application that is being run on some PC's with Access Runtime and some on PC's with full Access. The application contains a report with an unbound object frame linked to a word document. When the report is opened on a machine using Runtime Access an instance of MS Word...

Many thanks Yes, you are right, the Dir() throws the error I think my problem is that I have: Dir("\\UNKNOWN_NETWORK_LOCATION\path\notfound.accdb") - I am installing an update developed on my system to a client whose network has different nomenclature. I wonder if Windows is giving the...

I guess this tread is long dead! BUT anyway: I use Access 2010 on windows 7 and 10 I use the following to check if the backend is linked: 'get path of linked DATA database Set Db = CurrentDb Set App = Db.TableDefs("Appointments") BE_Path = App.Connect Equal = InStr(BE_Path...

Many thanks. I have solved the problem by reinstalling add-ins which include the Package Wizard and the option I have been using has now returned!

Um, I am now floating in uncharted waters! When I select the package and sign it simply tells me that no digital signature is available. There is then no option to continue with packaging. What puzzles me is that I was using the publish and distribute option a few weeks ago and have not...

Access 2010, Windows 10 I have been regularly using 'Publish and Distribute' to create a runtime instillation to distribute. Suddenly that option is no longer available in 'Save and Publish'!! I have tried re-downloading AccessRuntime.exe and reinstalling but I still only have the option to...

Access 2010 on Windows 10 Can I use vba in one Access database to create a duplicate of another database?

Thank you for responses: Minty: I am using DoCmd.OutputTo acOutputReport, "BOOKING_LETTER_EMAIL", acFormatPDF, strFullFilePath, , , , acExportQualityPrint I have tried previewing the report but it always shows all the controls filled in correctly so I assume the problem is with the OutputTo...

I am using Access 2010 runtime on both Windows XP and Windows 7 to create a .PDF from a report using the OutputTo function in VBA. The back end database is on a nas drive. I am finding that the result is unreliable - text fields are sometimes left blank and (very infrequently) a particular field...

Access 2010 on Windows10 I am using vba to save a report to pdf and then send it as an email attachment in outlook. My problem is that the pdf is not fully created before the e-mail is sent. Is there a neat way to make sure the pdf creation is completed before the code continues to execute. On...

Access 2010 on Windows 10 Using VBA my application creates a Cross-Tab Query to display the total number of Appointments booked by Site and Month. I have manipulated the column headers and the column widths to give an aesthetic display. When the displayed query is closed a dialog box pops up...

Thank you for your helpful reply James. One question: Can I use: Set objMesg = objOutlook.CreateItemFromTemplate(DLookup("[TemplatesDirectory]", "MSystMySettings") & "ConfirmationLetterTemplate.oft") in place of your: Set objMsg = objOutlook.CreateItem(olMailItem) Since I don't use Outlook...

End User: Access 2010 Runtime on Windows XP Automated emails using an Outlook Template I am trying to avoid referencing the Outlook Object Library as the PC's don't all have the same version of Outlook and I need my my runtime package to be installed at will on new/renovated PC's ... - so I am...

Many thanks for the suggestions. In fact the problem seemed tohave come from my using dlookup() in the Report Load event - I have now created a query to pull all the fields together into one recordset and that seems to have solved the problem.