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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Design 1
Report exporting different data from what is on the report 1
cannot export to excel mso 2007 SP2 2
Export Report to Word Document 1
Exporting a report to Word 4
how to export the value of checkbox on a report in to excel 2
export report to Excel results in 2 rows of column headers 3
Export a reprot to Excel 15

Back
Top