Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    UK
    Posts
    68

    Unanswered: Access Default Directory

    Hello. I am using Access 2002 on the Citrix Environment and wonder if there is any way via code to set Access's default directory. It would just save time when users save reports to open up file save in there own respective folder area on the network. Any help is gratefuly received.

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    do you mean save a snapsot of a report to a folder?

  3. #3
    Join Date
    Jun 2003
    Location
    UK
    Posts
    68
    Yes thats exactly what I wish to do. Many different departments will be using the application saving there own reports as snapshots. I was hoping to pick up via there login details which department they are and then alter the appliations default folder to there own departmental directory at runtime.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    this is a snipet of code I use for a client (among alot more I took out) that export a report to snp format based on the currentuser and their default directory stored in a table


    Dim strfldrloc As String

    Dim zipdb As Database
    Dim ziprst As Recordset
    Set ziprst = zipdb.OpenRecordset("tblFolders") 'folder locations

    'find the folder location for user

    ziprst.MoveFirst

    Do Until ziprst.EOF
    If ziprst!userid = currentuser then ' id match
    strfldrloc = ziprst!FldrLoc
    Exit Do
    Else
    ziprst.MoveNext
    End If
    Loop

    'export the report to snp format and to desired folder

    DoCmd.OutputTo acOutputReport, "mysnapshotreport", _
    acFormatSNP, strfldrloc & "\" & "whateverNameYouWant" & ".snp"

  5. #5
    Join Date
    Jun 2003
    Location
    UK
    Posts
    68
    Thank you very much for your help it works like a charm.

Posting Permissions

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