Access 2000 VS 2003

[ZoDra]

Hi everyone,

Recently I received a mdb which works fine with access 2003, but crashes when running in access 2000. Mdb is 2000 format and this piece of code is not working:
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Select Employee Picture"
.Filters.Add "All Files", "*.*"
.Filters.Add "JPEGs", "*.jpg"
.Filters.Add "Bitmaps", "*.bmp"
.FilterIndex = 3
.AllowMultiSelect = False
.InitialFileName = CurrentProject.path
result = .Show
If (result <> 0) Then
fileName = Trim(.SelectedItems.Item(1))
Me![ImagePath].Visible = True
Me![ImagePath].SetFocus
Me![ImagePath].Text = fileName
Me![Naziv].SetFocus
Me![ImagePath].Visible = False
End If
End With
It deals with capability to search and include a file (picture) into access data base data. Compiler error is reported in statement:
Wirh Application.Filedialog ... stating that msoFileDialogFilePicker variable is not defined.

Is there a solution to this problem? I understand that this variable is not declared until version 10 of MSAccess object library.

 

[Remou]

FileDialog in the way you show was added in 2003 version. You need something like

http://www.mvps.org/access/api/api0001.htm

for 2000.