Search results

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

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?

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

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

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

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

Access 2010 on both Windows XP and Windows 7 I have an application which USED to use a postcode address utility that created an Activex. I have removed all references in vba to the utility but Access runtime gives an error 'cannot create Activex' on my clients PC's (both with Windows XP...

I have an Access 2010 database that uses an Address Utility that requires a reference to pdf.ocx. Things work fine on Windows7 but I need it to run with Access Runtime on XP. The database runs OK but can't pick up the Address Utility - 'unable to create object' - I suspect that the...

Hi, Access 2010, Windows 7 I presume the specification of the start-up form is a property of a database. How can I use vba to set this property?

I am a self-taught Access VBA person. Sometimes I find the 'need' to exit a subroutine from within a control 'loop' e.g. if.. then..else with... while... et al. I suspect this is 'bad form' but is there any 'cost' in doing this? There presumably will be if objects have been set and...

Access 2013 Is it possible to compact a database to a new name? (In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach) I can't see where to do this in...

I am attempting to deploy a split Access 2010 database to an XP PC with service pack 3.(NOT by choice!) There is no Access on the XP machine so this would be a Run-Only version. MS claim this will work. I was hoping to deploy both the front-end and back-end with a single package. Is this...

Hi, I am using Access 2010, Windows 7 I have an unbound form with a combo box and a bound subform on it. I am using the combo box to get a value to filter (and display) records in the subform. My code is: Private Sub cboSessions_AfterUpdate() On Error GoTo...

I have a split database.(Access 2010) Three of the linked tables are Appointments, Appointments_OLD, Appointments_NEW I want to use vba to rename Appointments as Appointments_OLD (replacing the current one) and to rename Appointments_NEW as Appointments (replacing the current one) I have used...

Access 2010 I have created a custom shortcut menu for reports using VBA in the Open Event of my Startup Form. It works fine but: 1. I have to let the code run every time I open the database for it to be available to reports, otherwise I get a message that my menu cannot be found. I...

Is it possible to set the Date Picker in Access 2010 to start the week on Sunday rather than Monday? (Which I believe it did in Access 2007)

I am trying to use VBA to backup the BACK-END of a split database (so I can automatically archive selected data). If I use FileCopy I get a message that the BACK-END database has not been found. Obviously I could 'unlink' the BACK-END, copy it and 're-link' it, but I was hoping for a...