Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gretsch

    Copy a windows folder to users desktop

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

    Copy a windows folder to users desktop

    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
  3. gretsch

    Copy a windows folder to users desktop

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

    Copy a windows folder to users desktop

    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.
  5. gretsch

    Copy a windows folder to users desktop

    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.
  6. gretsch

    Nested IIF Help

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

    Nested IIF Help

    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...
  8. gretsch

    IIF statement in Detail not working

    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...
  9. gretsch

    IIF statement in Detail not working

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

    IIF statement in Detail not working

    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

Part and Inventory Search

Back
Top