This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have 4-year old Access database that has a number of reports programmed into it. Many of these are opened using VBA via button action and filtered with a pre-defined date range in textboxes associated with the button. After a recent update to Microsoft Office, these reports have quit working, meaning the report opens, but there is no data displayed in the reports as if the applied filter is causing an issue.
What's more frustrating, is the report uses the "onFormat" event to do some fine tuning to objects in the report based on the data fields. For those reports that do open, the onFormat event seems to be causing an "expression has no value" error as VBA tries to read the value of a textbox during the event.
I should note that all of these reports displayed without any issues prior to the update of Office. I've not made any changes to the database and I'm wondering if anyone else has experienced a similar issue in the recent weeks. Any help or input is greatly appreciated.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Yes, did a compile and didn't hit any errors in doing so. I think I originally developed it in Access 2013 back in 2014 and haven't had any trouble recently. Has there been a tightening up since 2016?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Ok, so the app was developed in an older version of Access (which one?). And now that you have updated, they no longer work. Have you compiled your database? made sure there are no code gotchas that have been tightened up in 2016?
If you could make a copy of your front end, and in the copy version that you made, convert the linked tables to local tables by right clicking each table and choose convert to local table that would work. And then save the copy to OneDrive1
But please make sure that you are doing this to the copy and not the original version.
I can, but it is a split version with the backend data on a network server. Will you be able to open it with it linked like that?
Would you be able to save a copy of your database to OneDrive and post the link here? I can then open it up with my Access and take a look at it.