Arthur Fuller
artful at rogers.com
Mon Feb 24 15:47:00 CST 2003
Thanks! -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Francisco H Tapia Sent: February 24, 2003 3:45 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com