Print Page | Close Window

ReportInBackEndDatabase.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
Printed Date: 08 Aug 2020 at 1:27am
Software Version: Web Wiz Forums 12.03 -

Topic: ReportInBackEndDatabase.mdb (intermediate)
Posted By: Roger Carlson
Subject: ReportInBackEndDatabase.mdb (intermediate)
Date Posted: 27 Jul 2008 at 11:05pm

Please consider donating $1 per sample downloaded, - find out why here .


This sample illustrates how to run a report that exists in the Back-End database. It requires a report in the Back-End, a code module in the Back-End to run the report, a reference in the Front-End to the Back-End (ReportBE.mdb). For the reference, open any code module and go to Tools | References. Look for ReportBE.

Additionally, this sample has code that re-links the BE table to the FE and re-establishes the reference to the BE each time the database is opened. These would not be necessary in a working application, but allows this sample to work regardless of where it is placed as long as the FE and BE are in the same directory.

Access 97 (29 KB): - uploads/5/
Access 2000 DAO (56 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -