Is there an option in MS-Access to prevent it from checking the database connections when opening a query for edit. I am working remotely over a VPN connection and it take 5-10 minutes or more to open a query in design view or when saving the query. I am assuming that it is verifying the database connections - may be something else. Any suggestions would be appreciated. I am using MS-Access 2007 running MS-Access 2000 mode.
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…