[AccessD] FW: Query SQL

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