Simple question I would think for all of you but I wanted to understand if it might be suggesting that I'm structuring something wrong.
I've been Compiling fairly often and also running the Performance Analyzer. I am only getting 3 suggestions.
One is to Save app as MDE file. (What does that really mean?)
But the one that is more questioning to me is it wants me to relate 2 of my tables to themselves.
When I look at the Analysis Notes, bot say the optimation will benefit the Query XXXX. When I look at the setup of both those queries I conclude that it must be that I am using Queries of queries of those 2 tables it is suggesting.
Thus my question is should I change something? Should I relate the tables onto themselves or should I add the Query itself to the Relationship table and then relate the table to the query?
Do those suggestions indicate something more problematic in the future?
Trying and trying to understand! Thanks in advance.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
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…