[dba-SQLServer]Invoke Connection Dialog from a Button?

yup you can...check out this post :D

http://databaseadvisors.com/pipermail/dba-sqlserver/2003-February/000093.htm
l

-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Arthur Fuller" <artful at rogers.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Monday, February 24, 2003 10:52 AM
Subject: [dba-SQLServer]Invoke Connection Dialog from a Button?


: Can I do it? I looked around the DoCmd object and didn't find it. I want a
: button that pops open the Connection dialog.
:
: -----Original Message-----
: From: dba-sqlserver-admin at databaseadvisors.com
: [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Arthur
Fuller
: Sent: February 24, 2003 1:35 PM
: To: dba-sqlserver at databaseadvisors.com
: Subject: RE: [dba-SQLServer]Simple way to get databases like myDB* into a
: combo box?
:
: It only took one line of SQL, sorry to bother you with my laziness.
: SELECT Name FROM master.dbo.sysdatabases WHERE CharIndex( 'Arthur', Name )
>
: 0
: ORDER BY Name
: Doh!
:
: -----Original Message-----
: From: dba-sqlserver-admin at databaseadvisors.com
: [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Arthur
Fuller
: Sent: February 24, 2003 1:23 PM
: To: dba-sqlserver at databaseadvisors.com
: Subject: [dba-SQLServer]Simple way to get databases like myDB* into a
combo
: box?
:
: I want to drop a list like that into an Access combo-box. I.e. several dbs
: of similar names may be opened. Grab the selection, modify the connection.
: Anyone got this function in the can?
: Just thought I'd ask before writing it :-)
: TIA,
: Arthur