Export Report Design

  • Thread starter Thread starter Sarah Kingswell
  • Start date Start date
S

Sarah Kingswell

Is it possible to export a report design and import it into another
database. (both have identical schemas)
 
Yes, to do it manually, on the database window menu of the database where
you want it, File | Get External Data | Import. You can import any object
from another database (to which you have appropriate security
permissions/rights).

To do this via VBA code, look for CopyObject in Help.

Larry Linson
Microsoft Access MVP
 
Sarah,
open your vba editor
in the immediate window, type
Application.SaveAsText, AcReport, "yourreportnameinquotes",
"C:\your\path\reportname.txt"

similarly, in the other database
Application.LoadFromText, AcReport, "yourreportnameinquotes",
"C:\your\path\reportname.txt"

HS
 
Back
Top