BayConsulting
Programmer
I've converted an Access 97 database to Access 2000. The 97 interface allows the user to export data to Excel. When the user chooses 'export' we open the typical common dialog box that allows you to browse through your directories and specify a file name. This was accomplished by using two calls to the API:
DECLARE Function ms_accOfficeGetFileName Lib "msaccess.exe" Alias "#56" (gfni As ws_accOfficeGetFileNameInfo, ByVal fOpen as Long) as Long
DECLARE Function ms_accSplitPath Lib "msaccess.exe" Alias "#59" (ByVal strPath as String, ByVal strDrive as string, ByVal strDir As String, ByVal strFName as String, ByVal strExt as String)
This code does not work after the conversion. Does anyone know how to create the equivalent functionality in Access 2000?
DECLARE Function ms_accOfficeGetFileName Lib "msaccess.exe" Alias "#56" (gfni As ws_accOfficeGetFileNameInfo, ByVal fOpen as Long) as Long
DECLARE Function ms_accSplitPath Lib "msaccess.exe" Alias "#59" (ByVal strPath as String, ByVal strDrive as string, ByVal strDir As String, ByVal strFName as String, ByVal strExt as String)
This code does not work after the conversion. Does anyone know how to create the equivalent functionality in Access 2000?
