Drew Wutka
DWUTKA at Marlow.com
Thu Mar 6 15:18:26 CST 2008
Hey, glad to help. Stored queries work faster too, so you'll get better performance the way you plan to go. The method in which I was loading the recordset was just something I whipped up. Honestly, I would very rarely ever build something like this for projects I work on. With most of my systems, I build classes built around data functionality. Because of that, if I had a combo that would list the 50 states, it wouldn't display off of a recordset (directly), it would display off of a Class and collection class (state and states), so it's faster to put a single callback function behind that form, for that class. You mentioned that the form's module is a class, and a callback on the form's class module works, I wonder if you could incorporate the callback function into a global class....hmmmmm.... if you get around to trying that, let me know. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, March 06, 2008 1:30 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] using ADO to populatecombos-wasRE:Error3048Cannotopenany more databases Drew, >On a serious note, do you have anything in specific that you don't understand how it's working? No. It is just complex enough that I had to dig in to what you are doing. The multiple levels of indirection with the sql statement (the table) took a little while to dig through. I wouldn't do it that way but I see what you are doing. I like to use saved queries where the name of the query is the controlname-form name. This allows me to build the queries as normal and then my control class loads the control's query. I can do some nice stuff that way like "only if there is nothing in the rowsource" and "if not found that way look for just the control name". qcboGroup-frmGroupUser qcboUser-frmGroupUser qcboState Things like that allow me flexibility at design time of the FE to load something like a state combo with the same generic query but load a group combo with a query specific to a form etc. and if the combo already has a query in the rowsource don't (re)load any query at all. I think I can still work that kind of logic into what you are doing. Thanks for taking the time to work that demo up. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, March 06, 2008 1:23 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] using ADO to populatecombos-wasRE:Error3048Cannotopen any more databases LOL. Sorry, was trying to get an example to you while putting out fires here at work, didn't have the time to put in comments. ;) Besides, I figured you just needed a point in the right direction! On a serious note, do you have anything in specific that you don't understand how it's working? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, March 06, 2008 12:18 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] using ADO to populate combos-wasRE:Error3048Cannotopen any more databases I think it will work. Of course I had to delete all the comments cause they were getting in the way of my understanding how it worked. ;-) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, March 06, 2008 11:54 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] using ADO to populate combos -wasRE:Error3048Cannotopen any more databases Hey John, did you take a look at my demo? Just curious if it'll work for what you are trying to do. Drew The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.