Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    41

    Unanswered: folder made from field

    im looking for a way that after a user creates a chart number for a patient then it will also make a folder on f: drive or whatever drive with the name of the chartnumber field


    ex: [chartnumber] =rilwil00001 would creat a folder on our server f:\rilwil00001 and then make a hyperlink to it on our form so we can save patient chart info on the server instead of all these paper records everywhere.

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: folder made from field

    Originally posted by opcbriley
    im looking for a way that after a user creates a chart number for a patient then it will also make a folder on f: drive or whatever drive with the name of the chartnumber field


    ex: [chartnumber] =rilwil00001 would creat a folder on our server f:\rilwil00001 and then make a hyperlink to it on our form so we can save patient chart info on the server instead of all these paper records everywhere.
    If you set a reference to the Microsoft Scripting Runtime Library you can use the FileSystemObject to manipulate files and folders pretty easily.

    Dim fso As FileSystemObject, fldr As Folder, strChartNo

    strChartNo = "Path to Folder\" & Me.ChartNo
    Set fso = New FileSystemObject
    fso.CreateFolder strChartNo

    Hope this helps.

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •