plus_stick
New member
- Local time
- Today, 21:30
- Joined
- Jul 10, 2013
- Messages
- 7
Hi.
I have a code for linking tables. It works on Access 32 bit.
I modify the code for 64 bit (include PtrSafe after all Declares, etc...)
But it doesn't work.
When I try to chose database in dialog window, my program closed.
Closed on second DoCmd.Quit block (see attached file).
Please, help me to solve this trouble.
Thanks in advance.
PS. sorry for my english, hope everything is clear
I have a code for linking tables. It works on Access 32 bit.
I modify the code for 64 bit (include PtrSafe after all Declares, etc...)
But it doesn't work.
When I try to chose database in dialog window, my program closed.
Code:
Public Function GetDbPath(path_name As String) As Integer
Dim i As Long
i = MsgBox("The path to database is incorrect" _
& Chr(13) & "Chose new path?", vbOKCancel + vbExclamation)
If i <> vbOK Then
DoCmd.Quit
Exit Function
End If
i = GetDBFileNameDlg(0, path_name)
If i = 0 Then
GetDbPath = False
DoCmd.Quit
Exit Function
End If
GetDbPath = True
End Function
Please, help me to solve this trouble.
Thanks in advance.
PS. sorry for my english, hope everything is clear