Search results for query: *

AceMan, very nice indeed, thank you so much. Works like a charm! Gretsch

Thnx Bubba100, but still defaults to 'My Computer', I'm passing a path, but seems to be being ignored. strFolderName = BFolder("T:\Afolder\Bfolder\CFolder") but to no avail. Gretsch

OK got rid of the reference error. But how do I start the folder browse off from a specific directory/folder? D.

Very cool, thank you. Although I am getting an error 'User-defined type not defined' its stopping on Dim fso As FileSystemObject Not sure what reference I need to add for this to be recognized. D.

From an Access form (Access 2000), I need a user to be able to browse for a windows folder, then have that same folder with any files it contains, copy to the users desktop. Any examples any one has would be greatly appreciated. thnx D.

Bravo Sir! splendid work, go to the top of the class. Gretsch

I am a VB programmer with very limited access reports experiance, how can i make this same IIF statement a nested one? =IIf([IndPTP]>1.25,"Y","N") eg: if the Val is between 1.25 and 1.50 make the result A if the Val is between 1.51 and 1.75 make the result B if the Val...

OK great its wrking with the 1.25... next question: I am a VB programmer with very limited access reports experiance, how can i make this same IIF statement a nested one? eg: if the Val is between 1.25 and 1.50 make the result A if the Val is between 1.51 and 1.75 make the result B if the Val is...

It is a calculated field, numeric (percent), I tried the Val made no diff, always comes out as Not True... Gretsch

Im using this statement in the Control Source of a report field =IIf([IndPTP]>125,"YES","NO") [IndPTP] is a field on the report not in the underlying query. It always results in "NO" when I run the report, HELP Gretsch