Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing path location (2002)

    I am not sure if this can be done. I have a database that I am using as a menu. Users click on what they need and access opens the file. There are database, excel spreadsheets, and word links. I can get this all to work very well. My problem is that my boss would like to put in a specific year and have those files brought up. We file everything according to development year - i.e. we have a document listing due dates in each development year from 99 to 04. The only thing different is in the middle of the path. For example, this year's file is located in ... /Budget/FY04/Book,TargetDates.doc...
    Last year's file is ... /Budget/FY03/Book,TargetDates.doc...
    My boss would like to select the year he wants to see (like 04 or 03) and then be directed to the correct file. I'm not sure how to do this, and I'm worried that if there is a solution it is beyond my current capabilities. First step is determining the possiblity.
    Can anyone let me know if this can be done?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: changing path location (2002)

    You could have a combo box or list box to select the year, and a combo box or list box to select the document. For example:

    Dim strYear As String
    Dim strDoc As String
    Dim strFullPath As String

    strYear = Me.cmbYear ' value of a combo box, sat "03" or "04".
    strDoc = Me.lstDocuments ' value of a list box, say "TargetDates.doc".
    strFullPath = "...BudgetFY" & strYear & "Book" & strDoc

    Followed by code to open document specified by strFullPath.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing path location (2002)

    Thank you SO much..
    I'm going to give it a shot.

Posting Permissions

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