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

Chris Mackin chris at denverdb.com
Mon Feb 24 13:21:24 CST 2003


You can open the Connection Dialog with the following:

DoCmd.RunCommand acCmdConnection

Chris Mackin
www.denverdb.com
Denver Database Consulting, LLC


-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Monday, February 24, 2003 11:52 AM
To: dba-sqlserver at databaseadvisors.com
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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com







More information about the dba-SQLServer mailing list