Use the FileSystemObject http://www.vbwm.com/art_1999/whatsnew/filesys.asp Rick Rose -------Original Message------- From: Nuno Fernando Afonso Oliveira Date: 11/11/04 05:24:35 To: [EMAIL PROTECTED] Subject: RE: [Visual Basic 6 programming] dropdowns and MDB Use the DIR function Something like this ' find 1st mdb file strPath = Dir (yourPath, "*.mdb") ' not sure of the sintax Do until strpath = "" combo1.additem strpath strpath = dir ' find next mdb file Loop -----Original Message----- From: Brian E Boothe [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 10 de Novembro de 2004 15:32 To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] dropdowns and MDB How can I loop thru Folders in a certain path and only show MDB files in the dropdown Control >> ??? -----Original Message----- From: Brian E Boothe [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 7:48 AM To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] Connecting to a database Once the directory is written and the MDB is copied into that directory how to I write my Connection string to that database,. ?? How can I use Textbox2.text= path of the database testbox3.text = database name in a connection string ?? As follows ? strMDBPath = "C:\SampleDir\sample.mdb"(Give your new direcotry path) g_constr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strMDBPath & _ "Jet OLEDB:Database " -----Original Message----- From: Rick Rose [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 8:25 PM To: [EMAIL PROTECTED] Subject: Re: [Visual Basic 6 programming] Connecting to a database If you have to update all your databases at the same time, you can use the FileSystemObject and cycle through your directories and update your databases that way. If you only have to update one database, then you should know the name of the database to update. It would be inputed by the user. Go to www.connectionstrings.com to get your connection string. I would recommend using ODBC with ADO. If further help is needed, let me know and I'll write some code for you. Rick Rose -------Original Message------- From: Brian E Boothe Date: 11/05/04 15:03:54 To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] Connecting to a database I make a directory thru code by the name in a textbox and Copy a template MDB to that directory And the MDB is renamed by the text in another field soo How do I connect to that database to update it once all that is done, >? [Non-text portions of this message have been removed] Yahoo! Groups Links .. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129mpu6b8/M=295196.4901138.6071305.3001176/ D=groups/S=1705115364:HM/EXP=1099794416/A=2128215/R=0/SIG=10se96mf6/*htt p:/companion.yahoo.com> click here <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group s/S=:HM/A=2128215/rand=151846192> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=0/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> Get unlimited calls to <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> U.S./Canada <http://us.ard.yahoo.com/SIG=129rkljrk/M=281955.5530326.6602771.3001176/ D=groups/S=1705115364:HM/EXP=1100010641/A=2343726/R=1/SIG=12irrtcqb/*htt p:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=109992424163 2586> <http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1099 924241632586> <http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=group s/S=:HM/A=2343726/rand=950275689> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17935 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
