I couldn't get it to work...
I didn't set a default extension or filter
i just put
commondialog1.filename="*."
and none of the files showed up.
what am i doing wrong here..
can u explain please ..thanks.
Yes you guessed right. I cannot put an extension to the files.
Regarding using a filelistbox, I don't know if it would be possible.
I am using this common dialog in an activex script in a DTS package to prompt the user to choose a file before performing data transformations on it. I don't think...
one workaround i found is
Do
CommonDialog1.ShowOpen ' show the dialog
Loop Until InStr(1, CommonDialog1.FileTitle, ".") = 0
don't like it though...would have been great if i could simply hide the files without the extensions...
Also any ideas on how can I dynamically change the...
tried that..and many other combinations too...still can't get it to work...
I presume what you mean is
commondialog1.filter="*."
which doesn't work.
Haven't been able to figure this out..a tricky one...
generally we use this
commondialog1.filter="EXCEL files (*.xls)|*.xls"
Commondialog1.showopen
this will just show the files with .xls extension in the directory.
Now I want to see only the files that have no extension and nothing...
thanks LittleSmudge tbf.Connect is exactly what I needed...Cajun ur solution was good too..but I don't want to add any references that would cause dependency problems when I distribute the application. Thanks anyways !!
I have a VBA form with an "Export Table" button on it for exporting the currently linked tables to another database. The user choses the path for the destination database using a Browse button.
The problem is when I use either 'Copyobject' or 'Transferdatabase acExport' commands VBA...
ooops..sorry some confusion in the above post..here's a corrected version.
what Dr.JavaJoe says works as long as you have the Sorted property of the Combobox set to False. If you set the Sorted property to True, it behaves strangely. Meaning that when I press N it goes to items starting with N...
ok what DrJavaJoe said is correct...as long as you don't have the Sorted property set to False. If you set the Sorted property to True, it behaves strangely. Meaning that when I press N it goes to items starting with N.
After that if I press A nothing happens...if I wait 2-3 seconds and then...
not exactly....when I press an "N" key it shows the first choice starting with an "N" ....and subsequent pressing of the "N" key scrolls it fine....BUT after that if I press, lets say "A" key it does not goto choices starting with an "A"...
Hi,
I have a combobox for US states in my code. I want the user to be able to select a state just by pressing keys.
For instance, if the user presses "N" key then the listindex of the combobox changes to "NC" (North Carolina).
Subsequent pressing of the "N" key...
well..thats exactly the point...i could do what you suggested above ...but i don't want to create a messy code that would be hard for a person who takes up my position in future to understand and maintain....
i understand as a programmer that there are a lot of nifty tricks that I could use to...
hi all,
I am developing a front end in VB6 ...I have certain forms that have almost the same controls (text boxes, buttons etc.) but the functionality of the new form will vary. For instance the behavior of a button click will vary..or it may have an extra checkbox etc.
I need expert advise on...
ok it seems the problem is u r not instantiating a new recordset or u r not instantiating a new connection....or..u r not setting the active connection for the recordset to the current connection...
if u r already connected to the database type this line before rs.open...
set...
create a string...like
Dim strsql as String
strsql="Select * From wc WHERE wc=" & Text0.text
then say,
rs.open strsql
Note that you can give all the other options like uid and pwd in separate statements...or u can even merge them together in the same string but make sure u take...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.