Export Report Design

  • Thread starter Sarah Kingswell
  • Start date
S

Sarah Kingswell

Is it possible to export a report design and import it into another
database. (both have identical schemas)
 
L

Larry Linson

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
 
H

HSalim

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
 

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

Top