By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

file browse button on a form

jaccess
P: 26
Hello,

I have been working on a project in Access 2003, that requires an excel file to be selected (via browsing through folders, then selecting a file), the selected file name will then appear in a text box.

This will all take place on a form.

I had no idea browsing to a file would be so complicated. After many hours of searching I think I have found the information I need but unsure as to how to make it actually work. http://www.mvps.org/access/api/api0001.htm

Being fairly new to Access still I have no clue as to how to implement this code, or how to connect it to a button on a form etc.

I would guess that a module will need to be created then a specific function in the code be called but that is just guesswork.

Any help would be appreciated.
Jul 24 '07 #1
Share this Question
Share on Google+
21 Replies


puppydogbuddy
Expert 100+
P: 1,923
Hello,

I have been working on a project in Access 2003, that requires an excel file to be selected (via browsing through folders, then selecting a file), the selected file name will then appear in a text box.

This will all take place on a form.

I had no idea browsing to a file would be so complicated. After many hours of searching I think I have found the information I need but unsure as to how to make it actually work. http://www.mvps.org/access/api/api0001.htm

Being fairly new to Access still I have no clue as to how to implement this code, or how to connect it to a button on a form etc.

I would guess that a module will need to be created then a specific function in the code be called but that is just guesswork.

Any help would be appreciated.
Without actually implementing the code that is posted on the web site, I could not tell you what to do for sure. The links I am providing below have working mdb files with the browse function that you can download. The source code is provided with the download and is much easier to implement.

Browse and Open Files Database
http://www.utterangel.com/utterangel.aspx#8

File Open Dialog Boxes without ActiveX
http://www.fabalou.com/Access/Module...pen_dialog.asp


Let me know if you have any problems.
Jul 24 '07 #2

jaccess
P: 26
Thanks!

I'll check them out and get back to you.
Jul 24 '07 #3

jaccess
P: 26
So I think the second example you sent me will work nicely

File Open Dialog Boxes without ActiveX
http://www.fabalou.com/Access/Modul...open_dialog.asp

but I ran into a small problem.

If I click on the "Please Select an Excle File" browse button first I get this error:

Invalid use of Null (Error 94)

and the following is what comes up with the Debug:

Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")

The strange thing is that when I select the first button "Please Select a Directory" it works fine and then if I select the "Please Select an Excel File" after, it works like it should.

Any thoughts?
Jul 24 '07 #4

puppydogbuddy
Expert 100+
P: 1,923
So I think the second example you sent me will work nicely

File Open Dialog Boxes without ActiveX
http://www.fabalou.com/Access/Modul...open_dialog.asp

but I ran into a small problem.

If I click on the "Please Select an Excle File" browse button first I get this error:

Invalid use of Null (Error 94)

and the following is what comes up with the Debug:

Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")

The strange thing is that when I select the first button "Please Select a Directory" it works fine and then if I select the "Please Select an Excel File" after, it works like it should.

Any thoughts?
Just a guess....looks like a typo....if this is not it, let me know and I will download the mdb.

change this: >>> Me.txtXLFIle.Value

to this: >>>>>>> Me.txtXLFile.Value
Jul 24 '07 #5

jaccess
P: 26
Just a guess....looks like a typo....if this is not it, let me know and I will download the mdb.

change this: >>> Me.txtXLFIle.Value

to this: >>>>>>> Me.txtXLFile.Value

That would make sense, but it is actually Me.txtXLF(I - this is a capital i that looks exactly like a lower case L in this font )le

In the debug screen when I mouse over this line of code that is highlighted

Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")
there is a little tooltip pop up that says " Me.txtXLFIle.Value = Null "
I don't know if that helps at all.

Please let me know if you get around to checking it out further.

Thanks again!
Jul 25 '07 #6

puppydogbuddy
Expert 100+
P: 1,923
That would make sense, but it is actually Me.txtXLF(I - this is a capital i that looks exactly like a lower case L in this font )le

In the debug screen when I mouse over this line of code that is highlighted

Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")
there is a little tooltip pop up that says " Me.txtXLFIle.Value = Null "
I don't know if that helps at all.

Please let me know if you get around to checking it out further.

Thanks again!
Good write-up. I don't think I need to download the file. Try this:

Change this:
Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")

To This:

If Not IsNull(Me.txtXLFIle) Then
Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")
End If

Let me know what happens.
Jul 25 '07 #7

jaccess
P: 26
I changed out the existing code with your code and there was no error but not browse either.

Right when I changed out the code this line was highlighted

If Not IsNull(Me.txtXLFIle) Then
Jul 25 '07 #8

jaccess
P: 26
Once again even with your new code if I click on the "Please Select A Directory" button first then hit cancel then press the "Please Select An Excel File" button the browse function works.

Pretty strange.

FYI

On the form there is 3 buttons and 3 text boxes one for browsing a directory one to select a database and one to select an excel file.

I will make a new form with just the browse to select an excel file and see what happens.
Jul 25 '07 #9

jaccess
P: 26
So I made a new form (in the same db as the example) with the a browse button and text box both named the same as in the example form then copied the same onclick function to the new form and got this error.

Compile Error Method or data member not found (Error 461)

Me.txtXLFIle.Value = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")

with this part highlighted txtDir.

I did the exact same steps but for the browse to a directory button/function and it worked fine.
Jul 25 '07 #10

jaccess
P: 26
So.... I think I was able to figure out a way to have a file browse button on a form select a file and put the file path into a text box by doing the following (for anyone else who may run into this problem.)

Thanks for all the assistance puppydogbuddy I really do appreciate your help.

1. Create a new Module in Access name it what ever you want and paste the following code from http://www.mvps.org/access/api/api0001.htm

Expand|Select|Wrap|Line Numbers
  1. '***************** Code Start **************
  2. 'This code was originally written by Ken Getz.
  3. 'It is not to be altered or distributed,
  4. 'except as part of an application.
  5. 'You are free to use it in any application,
  6. 'provided the copyright notice is left unchanged.
  7. '
  8. ' Code courtesy of:
  9. ' Microsoft Access 95 How-To
  10. ' Ken Getz and Paul Litwin
  11. ' Waite Group Press, 1996
  12.  
  13. Type tagOPENFILENAME
  14.     lStructSize As Long
  15.     hwndOwner As Long
  16.     hInstance As Long
  17.     strFilter As String
  18.     strCustomFilter As String
  19.     nMaxCustFilter As Long
  20.     nFilterIndex As Long
  21.     strFile As String
  22.     nMaxFile As Long
  23.     strFileTitle As String
  24.     nMaxFileTitle As Long
  25.     strInitialDir As String
  26.     strTitle As String
  27.     Flags As Long
  28.     nFileOffset As Integer
  29.     nFileExtension As Integer
  30.     strDefExt As String
  31.     lCustData As Long
  32.     lpfnHook As Long
  33.     lpTemplateName As String
  34. End Type
  35.  
  36. Declare Function aht_apiGetOpenFileName Lib "comdlg32.dll" _
  37.     Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolean
  38.  
  39. Declare Function aht_apiGetSaveFileName Lib "comdlg32.dll" _
  40.     Alias "GetSaveFileNameA" (OFN As tagOPENFILENAME) As Boolean
  41. Declare Function CommDlgExtendedError Lib "comdlg32.dll" () As Long
  42.  
  43. Global Const ahtOFN_READONLY = &H1
  44. Global Const ahtOFN_OVERWRITEPROMPT = &H2
  45. Global Const ahtOFN_HIDEREADONLY = &H4
  46. Global Const ahtOFN_NOCHANGEDIR = &H8
  47. Global Const ahtOFN_SHOWHELP = &H10
  48. ' You won't use these.
  49. 'Global Const ahtOFN_ENABLEHOOK = &H20
  50. 'Global Const ahtOFN_ENABLETEMPLATE = &H40
  51. 'Global Const ahtOFN_ENABLETEMPLATEHANDLE = &H80
  52. Global Const ahtOFN_NOVALIDATE = &H100
  53. Global Const ahtOFN_ALLOWMULTISELECT = &H200
  54. Global Const ahtOFN_EXTENSIONDIFFERENT = &H400
  55. Global Const ahtOFN_PATHMUSTEXIST = &H800
  56. Global Const ahtOFN_FILEMUSTEXIST = &H1000
  57. Global Const ahtOFN_CREATEPROMPT = &H2000
  58. Global Const ahtOFN_SHAREAWARE = &H4000
  59. Global Const ahtOFN_NOREADONLYRETURN = &H8000
  60. Global Const ahtOFN_NOTESTFILECREATE = &H10000
  61. Global Const ahtOFN_NONETWORKBUTTON = &H20000
  62. Global Const ahtOFN_NOLONGNAMES = &H40000
  63. ' New for Windows 95
  64. Global Const ahtOFN_EXPLORER = &H80000
  65. Global Const ahtOFN_NODEREFERENCELINKS = &H100000
  66. Global Const ahtOFN_LONGNAMES = &H200000
  67.  
  68. Function TestIt()
  69.     Dim strFilter As String
  70.     Dim lngFlags As Long
  71.     strFilter = ahtAddFilterItem(strFilter, "Access Files (*.mda, *.mdb)", _
  72.                     "*.MDA;*.MDB")
  73.     strFilter = ahtAddFilterItem(strFilter, "dBASE Files (*.dbf)", "*.DBF")
  74.     strFilter = ahtAddFilterItem(strFilter, "Text Files (*.txt)", "*.TXT")
  75.     strFilter = ahtAddFilterItem(strFilter, "All Files (*.*)", "*.*")
  76.     MsgBox "You selected: " & ahtCommonFileOpenSave(InitialDir:="C:\", _
  77.         Filter:=strFilter, FilterIndex:=3, Flags:=lngFlags, _
  78.         DialogTitle:="Hello! Open Me!")
  79.     ' Since you passed in a variable for lngFlags,
  80.     ' the function places the output flags value in the variable.
  81.     Debug.Print Hex(lngFlags)
  82. End Function
  83.  
  84. Function GetOpenFile(Optional varDirectory As Variant, _
  85.     Optional varTitleForDialog As Variant) As Variant
  86. ' Here's an example that gets an Access database name.
  87. Dim strFilter As String
  88. Dim lngFlags As Long
  89. Dim varFileName As Variant
  90. ' Specify that the chosen file must already exist,
  91. ' don't change directories when you're done
  92. ' Also, don't bother displaying
  93. ' the read-only box. It'll only confuse people.
  94.     lngFlags = ahtOFN_FILEMUSTEXIST Or _
  95.                 ahtOFN_HIDEREADONLY Or ahtOFN_NOCHANGEDIR
  96.     If IsMissing(varDirectory) Then
  97.         varDirectory = ""
  98.     End If
  99.     If IsMissing(varTitleForDialog) Then
  100.         varTitleForDialog = ""
  101.     End If
  102.  
  103.     ' Define the filter string and allocate space in the "c"
  104.     ' string Duplicate this line with changes as necessary for
  105.     ' more file templates.
  106.     strFilter = ahtAddFilterItem(strFilter, _
  107.                 "Access (*.mdb)", "*.MDB;*.MDA")
  108.     ' Now actually call to get the file name.
  109.     varFileName = ahtCommonFileOpenSave( _
  110.                     OpenFile:=True, _
  111.                     InitialDir:=varDirectory, _
  112.                     Filter:=strFilter, _
  113.                     Flags:=lngFlags, _
  114.                     DialogTitle:=varTitleForDialog)
  115.     If Not IsNull(varFileName) Then
  116.         varFileName = TrimNull(varFileName)
  117.     End If
  118.     GetOpenFile = varFileName
  119. End Function
  120.  
  121. Function ahtCommonFileOpenSave( _
  122.             Optional ByRef Flags As Variant, _
  123.             Optional ByVal InitialDir As Variant, _
  124.             Optional ByVal Filter As Variant, _
  125.             Optional ByVal FilterIndex As Variant, _
  126.             Optional ByVal DefaultExt As Variant, _
  127.             Optional ByVal FileName As Variant, _
  128.             Optional ByVal DialogTitle As Variant, _
  129.             Optional ByVal hwnd As Variant, _
  130.             Optional ByVal OpenFile As Variant) As Variant
  131. ' This is the entry point you'll use to call the common
  132. ' file open/save dialog. The parameters are listed
  133. ' below, and all are optional.
  134. '
  135. ' In:
  136. ' Flags: one or more of the ahtOFN_* constants, OR'd together.
  137. ' InitialDir: the directory in which to first look
  138. ' Filter: a set of file filters, set up by calling
  139. ' AddFilterItem. See examples.
  140. ' FilterIndex: 1-based integer indicating which filter
  141. ' set to use, by default (1 if unspecified)
  142. ' DefaultExt: Extension to use if the user doesn't enter one.
  143. ' Only useful on file saves.
  144. ' FileName: Default value for the file name text box.
  145. ' DialogTitle: Title for the dialog.
  146. ' hWnd: parent window handle
  147. ' OpenFile: Boolean(True=Open File/False=Save As)
  148. ' Out:
  149. ' Return Value: Either Null or the selected filename
  150. Dim OFN As tagOPENFILENAME
  151. Dim strFileName As String
  152. Dim strFileTitle As String
  153. Dim fResult As Boolean
  154.     ' Give the dialog a caption title.
  155.     If IsMissing(InitialDir) Then InitialDir = CurDir
  156.     If IsMissing(Filter) Then Filter = ""
  157.     If IsMissing(FilterIndex) Then FilterIndex = 1
  158.     If IsMissing(Flags) Then Flags = 0&
  159.     If IsMissing(DefaultExt) Then DefaultExt = ""
  160.     If IsMissing(FileName) Then FileName = ""
  161.     If IsMissing(DialogTitle) Then DialogTitle = ""
  162.     If IsMissing(hwnd) Then hwnd = Application.hWndAccessApp
  163.     If IsMissing(OpenFile) Then OpenFile = True
  164.     ' Allocate string space for the returned strings.
  165.     strFileName = Left(FileName & String(256, 0), 256)
  166.     strFileTitle = String(256, 0)
  167.     ' Set up the data structure before you call the function
  168.     With OFN
  169.         .lStructSize = Len(OFN)
  170.         .hwndOwner = hwnd
  171.         .strFilter = Filter
  172.         .nFilterIndex = FilterIndex
  173.         .strFile = strFileName
  174.         .nMaxFile = Len(strFileName)
  175.         .strFileTitle = strFileTitle
  176.         .nMaxFileTitle = Len(strFileTitle)
  177.         .strTitle = DialogTitle
  178.         .Flags = Flags
  179.         .strDefExt = DefaultExt
  180.         .strInitialDir = InitialDir
  181.         ' Didn't think most people would want to deal with
  182.         ' these options.
  183.         .hInstance = 0
  184.         '.strCustomFilter = ""
  185.         '.nMaxCustFilter = 0
  186.         .lpfnHook = 0
  187.         'New for NT 4.0
  188.         .strCustomFilter = String(255, 0)
  189.         .nMaxCustFilter = 255
  190.     End With
  191.     ' This will pass the desired data structure to the
  192.     ' Windows API, which will in turn it uses to display
  193.     ' the Open/Save As Dialog.
  194.     If OpenFile Then
  195.         fResult = aht_apiGetOpenFileName(OFN)
  196.     Else
  197.         fResult = aht_apiGetSaveFileName(OFN)
  198.     End If
  199.  
  200.     ' The function call filled in the strFileTitle member
  201.     ' of the structure. You'll have to write special code
  202.     ' to retrieve that if you're interested.
  203.     If fResult Then
  204.         ' You might care to check the Flags member of the
  205.         ' structure to get information about the chosen file.
  206.         ' In this example, if you bothered to pass in a
  207.         ' value for Flags, we'll fill it in with the outgoing
  208.         ' Flags value.
  209.         If Not IsMissing(Flags) Then Flags = OFN.Flags
  210.         ahtCommonFileOpenSave = TrimNull(OFN.strFile)
  211.     Else
  212.         ahtCommonFileOpenSave = vbNullString
  213.     End If
  214. End Function
  215.  
  216. Function ahtAddFilterItem(strFilter As String, _
  217.     strDescription As String, Optional varItem As Variant) As String
  218. ' Tack a new chunk onto the file filter.
  219. ' That is, take the old value, stick onto it the description,
  220. ' (like "Databases"), a null character, the skeleton
  221. ' (like "*.mdb;*.mda") and a final null character.
  222.  
  223.     If IsMissing(varItem) Then varItem = "*.*"
  224.     ahtAddFilterItem = strFilter & _
  225.                 strDescription & vbNullChar & _
  226.                 varItem & vbNullChar
  227. End Function
  228.  
  229. Private Function TrimNull(ByVal strItem As String) As String
  230. Dim intPos As Integer
  231.     intPos = InStr(strItem, vbNullChar)
  232.     If intPos > 0 Then
  233.         TrimNull = Left(strItem, intPos - 1)
  234.     Else
  235.         TrimNull = strItem
  236.     End If
  237. End Function
  238. '************** Code End *****************
  239.  
2. Make a form and name it what ever you want. On the form make a text box and name it txtfilename then make a button on the form and name it TestIt()
On this buttons OnClick event paste the following code

Expand|Select|Wrap|Line Numbers
  1. Private Sub TestIt___Click()
  2. Dim strFilter As String
  3. Dim strInputFileName As String
  4.  
  5. strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")
  6. strInputFileName = ahtCommonFileOpenSave( _
  7.                 Filter:=strFilter, OpenFile:=True, _
  8.                 DialogTitle:="Please select an input file...", _
  9.                 Flags:=ahtOFN_HIDEREADONLY)
  10. Me.txtfilename.Value = ahtCommonFileOpenSave( _
  11.                 Filter:=strFilter, OpenFile:=True, _
  12.                 DialogTitle:="Please select an input file...", _
  13.                 Flags:=ahtOFN_HIDEREADONLY)
  14. End Sub
  15.  
There may be a better way to display the file path/name but I don't know how to do it. If someone else has better code please share.

Hope this helps.
Jul 25 '07 #11

FishVal
Expert 2.5K+
P: 2,653
Sure, there is a simpler way.
If you have Office 2003 you may use the following code.
Expand|Select|Wrap|Line Numbers
  1. Private Sub btnPickFile_Click()
  2.  
  3.     Dim dlgPickFiles As Office.FileDialog
  4.     Dim strList As String
  5.  
  6.     Set dlgPickFiles = Application.FileDialog(msoFileDialogFilePicker)
  7.  
  8.     With dlgPickFiles
  9.         .AllowMultiSelect = False
  10.         With .Filters
  11.             .Clear
  12.             .Add "Excel files (*.xls)", "*.xls"
  13.         End With
  14.         .Show
  15.         Me.txtFileName = .SelectedItems(1)
  16.     End With
  17.  
  18.     Set dlgPickFiles = Nothing
  19.  
  20. End Sub
  21.  
Be sure "Microsoft Office 11.0 Object Library" is referenced (Tools -> References)

Anyway you've done nice job.
Jul 25 '07 #12

jaccess
P: 26
Sure, there is a simpler way.
If you have Office 2003 you may use the following code.
Expand|Select|Wrap|Line Numbers
  1. Private Sub btnPickFile_Click()
  2.  
  3.     Dim dlgPickFiles As Office.FileDialog
  4.     Dim strList As String
  5.  
  6.     Set dlgPickFiles = Application.FileDialog(msoFileDialogFilePicker)
  7.  
  8.     With dlgPickFiles
  9.         .AllowMultiSelect = False
  10.         With .Filters
  11.             .Clear
  12.             .Add "Excel files (*.xls)", "*.xls"
  13.         End With
  14.         .Show
  15.         Me.txtFileName = .SelectedItems(1)
  16.     End With
  17.  
  18.     Set dlgPickFiles = Nothing
  19.  
  20. End Sub
  21.  
Be sure "Microsoft Office 11.0 Object Library" is referenced (Tools -> References)

Anyway you've done nice job.

Wow.

That is much easier and exactly what I was looking for, thanks!

Is there a way to start off the browse in a specific directory?
Jul 25 '07 #13

FishVal
Expert 2.5K+
P: 2,653
Wow.

That is much easier and exactly what I was looking for, thanks!

Is there a way to start off the browse in a specific directory?
Of course.

There are many useful properties and methods in Office.FileDialog. You can easily view it in VBA window in Object Browser. Naming is quite intuitive, help available as well, what else ... ah the water is fine :)

The property you need is FileDialog.InitialFileName.

Good luck.
Jul 25 '07 #14

puppydogbuddy
Expert 100+
P: 1,923
Fish,
That is good to know. I have Access 2000 and am not familiar with that particular FileDialog control.

jaccess,
Was out of the office - just got back on-line. Glad you got your problem resolved with a better FileDialog method with more efficient code.
Jul 25 '07 #15

FishVal
Expert 2.5K+
P: 2,653
Fish,
That is good to know. I have Access 2000 and am not familiar with that particular FileDialog control.

jaccess,
Was out of the office - just got back on-line. Glad you got your problem resolved with a better FileDialog method with more efficient code.
Hi, PDB.

I don't remember exactly how and now have no opportunity to check it, but I've once implemented this in Office 2000 after having trouble to move Access 2003 db with FileDialog to computer where Office 2000 was installed. Not sure maybe Office 2000 has a similar class or maybe some Office 2000 application does (maybe Excel).
Jul 25 '07 #16

puppydogbuddy
Expert 100+
P: 1,923
Hi, PDB.

I don't remember exactly how and now have no opportunity to check it, but I've once implemented this in Office 2000 after having trouble to move Access 2003 db with FileDialog to computer where Office 2000 was installed. Not sure maybe Office 2000 has a similar class or maybe some Office 2000 application does (maybe Excel).
Hi Fish,

Thanks for the good info. Now if I could only find the time.......

PDB
Jul 25 '07 #17

FishVal
Expert 2.5K+
P: 2,653
Hi Fish,

Thanks for the good info. Now if I could only find the time.......

PDB
Oh, it seems that I've found it in one of my old dbs.
Expand|Select|Wrap|Line Numbers
  1. varSelectedFile = Excel.Application.GetOpenFilename(Title:="Import New Products", _
  2.                             FileFilter:="Excel workbooks (*.xls),*.xls")
Not so good, too simple one.
Jul 25 '07 #18

P: 2
Very useful thread!
I want to display several images on a form (left side, right side) and each image should be selected through a button.
For the button I used this tread and it works. Made a few changes. I changed the filter to .jpg-files and I cut out this part of the OnClick-event:
Expand|Select|Wrap|Line Numbers
  1. # strInputFileName = ahtCommonFileOpenSave( _
  2. #                 Filter:=strFilter, OpenFile:=True, _
  3. #                 DialogTitle:="Please select an input file...", _
  4. #                 Flags:=ahtOFN_HIDEREADONLY)
I did this because I always had to select a file twice.

To display the image I used the method as found here.

This works but...If I select a path to an image the newly selected image only shows up on the form after I've closed it and reopened the form again.
Also, I can only use the button to select an image once, if I change my mind and want to select another image (before closing and reopening the form) nothing happens when I press the button.

And a third thing, not directly related to this. Can I set the size of the image to display? Haven't looked into that yet but I noticed when I selected a bigger image it displayed it bigger.
Feb 17 '09 #19

P: 2
Forget the last question already found a way. Change the display-options of the imageframe.
Feb 17 '09 #20

P: 1
Is there any way to save the file found in the browse to a specific folder?
Jan 11 '10 #21

P: 3
Sorry to bring up such an old post, but the code that FishVal posted got me 95% of the way through my exercise (thanks for posting, FishVal!). The last piece of the puzzle is that I need the text string that the code places in my text box to be a functioning hyperlink so that clicking it will open the pdf file that the user browses to. In other words, I want to be able to browse to a file and place the path to that file in my field, (which the code from FishVal accomplishes), but then I also want other users who look at the underlying table's data to be able to click on the path and actually open the file that it points to. I set the field property in the table to hyperlink, but the code only populates the hyperlink name, not the underlying hyperlink. Thanks in advance for your help, because this little exercise is driving me crazy!
May 4 '11 #22

Post your reply

Sign in to post your reply or Sign up for a free account.