Email report design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I built a database for my brother's business. I have now designed a new
report. Is there a way to email him just that report (report design) that he
can add to the database. If not, we have to try to email the dbase (which is
growing and becoming more difficult to email, even zipping it), during the
evening, when no data is being changed.

Thanks, Kathy
 
You can:
1. Create a new (blank) database:
File | New
2. Import the report you just created:
File | Get External | Import
3. Zip this database that contains just the report, and email it to him.

He can then import it into his database:
File | Get External | Import

For the long term, a better solution would be to split the database. You can
then update the front end and send him the update without overwriting the
data in the back end. If that's a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

It is also possible to export just the report design with the undocumented
SaveAsText, and he can import it with LoadFromText. For example, you would
open the Immediate Window (Ctrl+G) and export Report1 like this:
SaveAsText acReport, "Report1", "C:\Report1.txt"
You then attach this text file to your email.
He can import it with:
LoadFromText acReport, "Report1", "C:\Report1.txt"
This only works if you are both running the same version of Access, so is
less flexible and not as good an interface as the first solution above.
 
Thanks! I love learning new things. One day it may not even seem like I'm
self-taught!
 
Back
Top