Recent content by got_access:]

Right - understood. I think for me it is a personal choice. I would rather reduce vulnerabilities whenever its easy to do so. And also - as you say - it clears out objects in the nav pane that don't otherwise need to be there.

Hi theDBguy, Yes a form or report can also be compromised. Which would more than likely result in some portion of the form/report not working as originally designed. Assuming a minor change - the form/report would still (for the most part) work. But wouldn't it seem risk adverse to...

Access allows for a developer to create queries to function as record sources for forms and reports. If the developer uses this practice – he will end up with a number of queries sitting in the navigation pane which have no other purpose than to be a record source for forms/reports. In the...

If I understand correctly, [FORMS] represents a collection -while [FORM] represents an object.

Thank you for this link MrHans!

Thanks isladogs - I did search all of my previous posts and didn't see it. But I can continue to search for those keywords.

Hi All, I may have asked this question in a different way a while ago. So I apologize for not remembering the answer. I'm adding a field to a form which essentially points to another field in that form. At first I used the expression builder to create the pointer to the source field. I did this...

Hi all, I've got a friend who has asked me a question about an Access system. I don't have access to this system myself to look at it - so I can only describe. The issue is a form in which there is a control field which either provides a drop-down list or simple data entry. The data value this...

Oh I see - you just make your own customized labels and then name them using the standard avery number system. Interesting! I have a business I visit occasionally and they have a number of Access installs which all include labels which I'm told are according to the avery number/naming system...

Hi All, I've noticed my Access 2016 only appears to have one label template. What I see there now is called "Label1"and its size parameters are 1.00" x 1.50" I'm assuming Microsoft provides a source for downloading and installing Avery labels? Thanks in advance!

Hi All, I'm trying to find Microsoft's official descriptions of the errors one finds with calculated text box controls on a form. The #Name? error - I believe can occur with two possible situations. 1) Where the record source for the form does not contain table/query field that is being called...

Hi, I know there are different ways to make a combination MAIN/SUB form for a one-to-many relationship. One way is to create the subform perhaps in datasheet or tabular mode and then use the sub-form control to import it into the main form. With this method one ends up with the sub-form as a...

Yup! I totally agree! Someone told me that that feature was predicated on the lookup being established. However, I just did my own experiment and built a few new tables with similar data and then tried different variants to fine out which one would be needed for the system to auto-populate...

You've got me convinced about not using lookups. So If that is the reason for extracting data to excel - I understand your thinking and don't need to do that. But I've never heard of this feature where the system will auto-populate fields. And I was curious about what its really called. There...