How to automatically update a report on access with a linked dataset?

Question

I have one conclusion from the paradox table that is imported into Access. Now I created the report and performed data binding in the report to the data set from Paradox. When the work is done in Paradox, the output of one record changes ... How to open access and get values ​​from the report automatically, without using the reimport table manually?

The goal is that when you open access, the report is immediately opened for printing before printing.

Answer 1

(, , s ).

Answer 2

Paradox . , , , - DoCmd.TransferDatabase autoexec, OnLoad . , reset .

Answer 3

Paradox GetData. , db . . Paradox Access. db , .

Answer 4

"". On Load elipsis. " ", " Builder". VBA Report_Load. , :

Sub Report_Load()

DoCmd.TransferDatabase acImport, "Paradox 7.x", "c:\yourdata\yourfile.tbl", acTable, "SourceTable", "YourAccessTable"

Sub

Paradox, .. ( Paradox ). intellisense TransferData F1, TransferDatabase .

TrasferDatabase - :

CurrentDb.Execute "DELETE FROM TableName"

Paradox.