Search results

I'm building my third Access database and I'm still learning. One thing I wonder about from "real" developers is how much effort do you put into naming conventions and other standards. Do you name every tab, label, and combo box? Do you comment every line of VB code? Do you add only the...

Thanks, that was it.

I have a subform showing a single record from a related table. I want to prevent the user from tabbing through the last control to create a new record. Thanks, DJ

Thanks for the reply, but that doesn't work. There is no option to Remove, it's grayed out. My understanding is that Remove works to stop the label and control from moving together, but they are still associated with one another. What does work is to click the label and cut and paste it and...

OK, so I've come across the "combo box background color" bug in Access 2007 and I'm wondering if there's a quick and easy way to disassociate a label with a control. It seems that solves it. Thanks, DJ

Well that explains it! It works with the full reference. Would you mind explaining why VBA can't be used in a query? Are queries only SQL? What's the difference between VBA and VB? Thanks again.

I have a main form, frmMemberships referencing a subform fsubSearch. The container for the subform is named subSearch. On fsubSearch is a control, txtOrgIDSearch. txtOrgIDSearch is an unbound combo box that users can select a Organization from. I am trying to reference the control in the...