If the main and subform's record sources are the same, try rethinking your design so you can work without the subreport. Add subreports to replace multiple expressions that call domain functions such as DLookup
aaronmire99 There are two different problems here. Let's address the table design problem first. In a relational database application we do NOT store calculated values like inventory balance. It's a design choice that seems okay until you try to use it in practice. Don't do it, in othe...
First off apologies very new to access and databases in general, but I am having an issue where users can just grab my queries/tables out of my access database with excel. I'd like to know how I can prevent it. Current things I have tried. Shift bypass disabled Forced into runtime ...
When opening a form in order to add a new record (DoCmd.OpenForm newForm, , , , acFormAdd), I am trying to set a value to a field not visible to the user, so that the header of the form is displayed correctly. (The header contains a subform)....
However, the records don’t show this date at all—not in the form, and not in the table, either. THE FIX: Remember that default values are applied only when a record is created. This means that defaults will not be applied to records that already existed when you set them up. If ...
A parameter query is not a separate kind of query; rather, it extends the flexibility of a query. partial replica A database that contains only a subset of the records in a full replica. With a partial replica, you can set filters and identify relationships that define which subset of ...
If the main and subform's record sources are the same, try rethinking your design so you can work without the subreport. Add subreports to replace multiple expressions that call domain functions such as DLookup or DSum. By using a subreport, you can often get the same functionalit...
Hi All! I'm suffering a strange quirk with my Access forms/subforms. Whenever I set up a form / subform combo the form does not show all the records it...
I DO want the user to be able to sort and filter a list on a form - 'continuous form', but I DO NOT want that filter or sort to be saved. As CList pointed out in his first post this problem only happens when a form is a subform of a navigation form. That is, if you open ...
I DO want the user to be able to sort and filter a list on a form - 'continuous form', but I DO NOT want that filter or sort to be saved. As CList pointed out in his first post this problem only happens when a form is a subform of a navigation form. That is, if you open ...