2 results in 0.0039 seconds.
-
Has anyone had an issue with Access 2007 losing it's filter when sorted?
We have an application where users use an Access form to return a filtered recordset. The backend database can be either SQL or Oracle. In Access 2007 we have experienced an intermittent issue where the original filter is lost when using either the drop-down sorting from the datasheet headers or our right click menu that uses Access built-in sorting. 100% of the records are then returned and the filtered icon that was displayed is gone. This presents... -
Give a value to an unbound text box on an access 2007 report at runtime
I have an access 2007 report that I an executing from a form, The report is based on a query that i change when it is execuded using me.recordsource =, There is a text box in the heading that i want to give a value to when the report is executed. The following line of vba code is what i tried but i get an error stateing "the control can't be referenced unless it has focus". when i try to set focus i get the error "ms office doesn't...
