Reports_AddIn_2 |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 17 Mar 2009 at 8:21pm |
Reports_AddIn_2 General: For a given report selected in left list box, the user can select an appropriate query in right list box. The selected report will open, using selected query as its record source. Version: Access 2000 File format Reference Required: DAO 3.6 Installation: Open any database in Access and click on Tools > Add-Ins > Add-In Manager. Use: For a practical demonstration, import table TA_Books and queries QA_Books_1 to 3 from Add-In to host db. Rename the imported queries as desired, say Q_Books_1 to 3. Now, run the Add-In and open the report RA_Books (belonging to the Add-In) with different queries of host db (Q_Books_1 to 3, one by one) as its record source. Technical Notes: 1 - For code contained in modules belonging to the AddIn: 2 - For code contained in modules belonging to the host db:
(a) CurrentProject / CurrentDb are identical to CodeProject / CodeDb respectively, always referring to the host db, irrespective of the fact whether the AddIn is in activated state or not. (b) Whereas code in the AddIn can access all tables / queries / forms / reports, whether belonging to AddIn or the host db (see para 1 (e) above), code in host db can directly access only the objects belonging to host db itself. Download File >>: uploads/37/Reports_AddIn_2.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |