Search results

It works. Thank you very much

DoCmd.RunSQL ("INSERT INTO pivot (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) SELECT RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time FROM svod IN 'Z:\NPS\NPS - Operator - 1.accdb' ")

Thanks for your fast reply. But I've tried it before, same result.

Hi everyone. I'm trying to copy records from another base into existing table in current base by: DoCmd.RunSQL ("INSERT INTO pivot (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) SELECT (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) FROM svod IN 'Z:\NPS\NPS - Operator -...

Up...............

In attach you can see all codes. Public Function GetDBFileNameDlg(HWn As Long, fName As String) As Integer On Error GoTo Err_ Dim l As Long Dim pOpenfilename As OPENFILENAME fName = "" GetDBFileNameDlg = False pOpenfilename.lStructSize = Len(pOpenfilename) pOpenfilename.lpstrFilter =...

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. Public Function GetDbPath(path_name As String) As Integer Dim i As...