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 --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To reply to this message, go to:
http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17931
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/
