Search results

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.

If Dir(strFullFilePath) = "" Then 'Save as pdf if confirmation letter directory exists DoCmd.OutputTo acOutputReport, "BOOKING_LETTER_EMAIL", acFormatPDF, strFullFilePath Else MsgBox "Confirmation Letter already exists", vbExclamation, "ALREADY CONFIRMED" End If

Access 2010 - full version on Windows 7, Runtime on XP I have an application that populates a table, opens a report with that data and saves and stores it as a PDF. The application then uses an Outlook template to create an e-mail, attach the pdf and mail it. Spasmodically, and more so on...

Many thanks vbaInet - I think you have hit the button! I will remove the offending line.

Thank you Spikepl - I did invest time in looking for solutions on the web but did not find any! T he point is not simply that I want to put the whole address into one field but that I want to allow users to, for example, high-light the postal town so I need (at least I think I need) it to be...

I am using Access 2010 on Windows XP/Windows 7 My code converts individual lines of address (strings) into a single RTF Address field. It runs fine in full access but (as MS admits) CreateObject does not work in Runtime. Is there another way of doing this that avoids CreateObject?? 'create...