Search results

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...

Yes - thank you the DBguy, But I would like to know what this feature in Access is called? Is it simply called an "AutoLookup" query? Based upon the fact that the lookup created the link? I've not read anything in any Access documentation that refers to the system auto-populating fields. I'm...

Here it is: SELECT tblOrders.CustomerID, tblCustomers.FirstName, tblCustomers.LastName FROM tblCustomers INNER JOIN tblOrders ON tblCustomers.CustomerID = tblOrders.CustomerID;

I won't be using the lookup feature - as we've discussed. However I was experimenting and did establish a lookup. Then I happened to notice when I created this query - and was in datasheet mode the system would auto populate the FirstName and LastName fields, when I select the CustomerID

OK - I have another question about the AUTOLOOK UP query feature Which I believe is a derivative of the lookup feature. I have 2 tables. tblCustomer tblOrders The tblOrders table has the field tblOrders.CustomerID - which is linked via lookup to the tblCustomer.CustomerID So in datasheet view...

Thanks theDBguy It would be nice to at least look at one of these to check out the look/feel etc.