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