Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...The level of expertise is awesome. The nature in which people respond is professional helpful and not the least condescending. I can't say that for most forums..."

Geography

Where in the world do Tek-Tips members come from?
cllander (Programmer)
3 Dec 04 18:59
I want to create a button, that when clicked on, it opens a dialog box so that I can select the FDD I need, then open it.

I have tried this code, but after opening the file, it doesn't display it as open in the "Window Menu"


File = GetOpenFilename ("*.FDD",1,"Open","")
Forms.Open(File)


The form does appear to be open, because if I try to open it through normal means I get then following:

"You cannot open [File] for exclusive use because the
file is currently in use.  Instruct all users to close
the file, and then try again.

Code: [257:1811:560]"

kattikat (Programmer)
7 Jun 05 15:49
Were you able to figure out this problem? I just entered a new thread because I'm trying to use a command line interface. i.e. "fdd -0 myfile"
I'm getting a similar error message saying that the file is open by another user or I don't have sufficient rights.
cllander (Programmer)
13 Jul 05 12:54
No, I still haven't figured it out.  I've moved on to other things right now and haven't given it much thought lately.  I would still appreciate an answer if anyone can help.
Helpful Member!  mole51 (TechnicalUser)
14 Jul 05 11:34
Try using this. Just change the path to where your .FDD files are stored.

Private Sub BTN_LOCALDOC_Click ()
Dim Doc As String

    On Error Goto Bad

    Doc = "file://c:/Documents and Settings"
    
    If (0 = Len(Doc)) Then
        Exit Sub
    End If
        
    Application.Hyperlink(Doc)
    Exit Sub

Bad:    
    MsgBox("Hyperlink Failed: " & Error(), 16)    
    
End Sub
cllander (Programmer)
17 Jul 05 3:32
Thanks, for the help.  Just what I needed!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close