error '438' Object doesn't support this property or method when deploy access applicatioon on client machine
Posted on 2003-12-11
I have developed an access application. This application consists of form, queries, table, modules (VBA).
The access application run well in my machine (windows XP profesional). However when I deploy this access application to client machine (windows 2000 profesional), i found this error when user try to click on the 'browse' button.
"error '438' Object doesn't support this property or method"
This is the code for the browse event:
Private Sub cmdBrowse_Click()
Dim strNewFile As String
On Error GoTo Browse_Err
InitDir = "C:\MyDocuments\"
.CancelError = True
.Filter = "Excel Files (*.xls)|*.xls|" 'Can change (i.e. "Word Files (*.doc)|*.doc|") or ("All Files (*.*)|*.*|") see help for other examples
.ShowOpen ' Can use showSave for saving file, same principle
strNewFile = .Filename
txtFilePath.value = strNewFile
If Err.Number = 32755 Then
MsgBox Err.Number & ": " & Err.Description
How can I solve this problem? thanks!