[AccessD] FW: Query SQL

yep, i tried it already

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Saturday, June 28, 2003 2:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: Query SQL


Hi John

Are you sure about this? Or are you thinking of opening the other db
by shell'ing it?
I never use the switchboard thing but I can't imagine it will open as
a standalone app just by opening it in a workspace.

/gustav


> I would like to do that but the FE has a switchboard that opens when the
FE
> opens.  I need a way to open the FE without the switchboard opening.

> John W. Colby
> www.colbyconsulting.com

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Saturday, June 28, 2003 1:41 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: Query SQL


> Hi John

> You could temporary open 'X:\DISNEW\DISCO_FE.mdb' in a separate
> Workspace.
> Then you have direct access to all objects as in a frontend.

> /gustav

>> I have figured out how to get the query names from an external database
>> using something like:

>> SELECT MSysObjects.Name FROM MSysObjects IN 'X:\DISNEW\DISCO_FE.mdb'
WHERE
>> (((Left$([name],3)='qmm')=True) AND ((MSysObjects.Type)=5));

>> Which returns only stored queries where the name begins with QMM (mail
>> merge
>> queries in my system).  I can place this sql (built up on-the-fly) into a
>> rowsource of a combo box and voila, my user can select a query out in an
>> external db.

>> Now I need to get the field names from this same query to populate
another
>> combo.  If the query were local to the database I could just place the
>> query
>> name itself into the combo row source and set the rowsource type to Field
>> list, which is indeed what I was doing in the past.  Since the query is
>> now
>> not local to the mail merge database (I'm turning it into a wizard) I
have
>> to figure out another way.  The SQL thing above is cool because I don't
>> have
>> to use automation to get the query names.  Does anyone know how to view
>> the
>> fields in a querydef using sql?  I kind of figured it would be in one of
>> the msys tables but no joy there.

>> Eventually I will also have to actually execute the query out in the
>> external db to get a dataset with which to do the mail merge but if I can
>> get the sql I can also splice in the IN clause to do this without
>> automation.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com