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

Mike and Doris Manning mikedorism at ntelos.net
Mon Feb 24 13:27:04 CST 2003


How about just having them pick and then adjusting
CurrentProject.Connection?

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----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 01:52 PM
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