Results 1 to 2 of 2
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Control defaults of Insert Hyperlink Dialog (2000/2002)

    I'm using the following code to allow my users to insert a hyperlink to various image files (instead of storing them in the database).
    <pre>Private Sub InsertHyperlink_Click()
    On Error Resume Next
    RunCommand acCmdInsertHyperlink
    End Sub

    Now, they have come to me asking if the Insert Hyperlink dialog box can be modified to show a default directory and instead of all files, just *.tif, & *.jpg files.
    I'm stumped - does anyone have any suggestions?

    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Control defaults of Insert Hyperlink Dialog (2000/2002)

    I think you will have to display a standard "Open File" dialog, with a filter to display only jpg and tif files, and then set the Hyperlink.Address property of the text box.

    See <post#=297358>post 297358</post#> for an example of an "Open File" dialog. (Access 2002 has a built-in FileDialog, but that doesn't work in Access 2000.)

Posting Permissions

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