[AccessD] using ADO to populatecombos-wasRE:Error3048Cannotopen any more databases

jwcolby jwcolby at colbyconsulting.com
Thu Mar 6 13:30:21 CST 2008


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




More information about the AccessD mailing list