Skip to content

Dependency Analysis

Module Dependencies

Form_Action List

  • External: Actdatabase

Form_Change Password

  • External: Actdatabase, RecSet

Form_Opening Dialog

  • External: Actdatabase, RecSet

Form_Principal Project List

  • External: Actdatabase

Form_Principal Project Pillar High Risk Dialog

  • External: Actdatabase, RecSet
  • External: fso, ws, DBEngine, db

Mod Export Excel

  • External: Actdatabase, RecSet

Mod Send Outlook Message

  • External: objOutlook, Attachments, Recipients, Session

Table Usage

Access

  • Module: basRelink

ActionPriorityLookup

  • Module: Form_Action List

CompanyProgrammeYearStatus

  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

CompanyStatus

  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

DatabaseUsers

  • Module: Form_Change Password
  • Module: Form_Opening Dialog

DatabaseUsers Purple Ops Meeting

  • Form: Add and Edit Users

Delivery Locations

  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

DepartmentLookup

  • Module: Form_Action List

Else

  • Module: basRelink

End

  • Module: Form_Principal Project Pillar High Risk Dialog
  • Module: basRelink

Entrepreneur

  • Query: Qry Count Active Allocated Companies by Principal Project Pillar
  • Query: Qry Count Exited Companies by Principal Project Pillar
  • Query: Qry Count Exited Need Replacement by Principal Project Pillar
  • Query: Qry Sum Total Sponsorship by Principal Project Pillar

Entrepreneur Company

  • Query: Qry Count Active Allocated Companies by Principal Project Pillar
  • Query: Qry Count Exited Companies by Principal Project Pillar
  • Query: Qry Count Exited Need Replacement by Principal Project Pillar
  • Query: Qry Count Unallocated Companies by Principal Project Recommended
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

Entrepreneur Company Principal Projects

  • Query: Qry Count Active Allocated Companies by Principal Project Pillar
  • Query: Qry Count Exited Companies by Principal Project Pillar
  • Query: Qry Count Exited Need Replacement by Principal Project Pillar
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies
  • Query: Qry Sum Total Sponsorship by Principal Project Pillar
  • Query: SubQry Sum Total Replaced To Be Billed by Prin Project Pillar

Entrepreneur Company Programme Years

  • Query: Qry Count Active Allocated Companies by Principal Project Pillar
  • Query: Qry Count Exited Companies by Principal Project Pillar
  • Query: Qry Count Exited Need Replacement by Principal Project Pillar
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

Entrepreneurs

  • Query: Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP
  • Query: Qry Get Division Dist Model and Rec Info by Company

MsgBox

  • Module: Form_Change Password

Next

  • Module: basRelink

Principal

  • Module: Form_Principal Project Pillar High Risk Dialog
  • Query: Qry Report Action Log
  • Query: Qry Sum Total Spend by Principal Project

Principal Project Pillars

  • Form: Principal Project Pillar High Risk Dialog
  • Query: Qry Purple Meeting PPP Action List
  • Query: Qry Report Action Log
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies
  • Query: Qry Sum Total Spend by Principal Project
  • Report: Calibri

Principal Projects

  • Query: Qry Purple Meeting PPP Action List
  • Query: Qry Report Action Log
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

PrincipalProjectStatus

  • Query: Qry Report Action Log

Principals

  • Query: Qry Purple Meeting PPP Action List
  • Query: Qry Report Action Log
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

ProcessStatus

  • Query: Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP

ProcessStep

  • Query: Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP
  • Query: Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP

Products

  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

Purple

  • Module: Form_Action List
  • Module: Form_Principal Project List
  • Query: Qry Purple Meeting Action List
  • Query: Qry Purple Meeting PPP Action List

Purple Meeting Actions

  • Form: Add and Edit Purple Ops Meeting Action
  • Query: Qry Purple Meeting Action List
  • Query: Qry Purple Meeting PPP Action List
  • Query: Qry Report Action Log

Qry

  • Module: Form_Action List
  • Module: Form_Principal Project List
  • Query: Qry Count Unallocated Companies by Principal Project Recommended
  • Query: Qry Principal Project Pillar List

Qry Count Entrepreneurs Pipeline Phase 1 by Rec PP

  • Query: Qry Principal Project Pillar List
  • Query: Qry Report Action Log

Qry Count Entrepreneurs Pipeline Phase 2 by Rec PP

  • Query: Qry Principal Project Pillar List
  • Query: Qry Report Action Log

Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP

  • Query: Qry Principal Project Pillar List
  • Query: Qry Report Action Log

Qry Get Division Dist Model and Rec Info by Company

  • Query: Qry Count Unallocated Companies by Principal Project Recommended

Qry Report Principal Project Allocation Audit

  • Report: Calibri

Qry SubRpt Principal Project Allocation Audit Replaced Companies

  • Report: Calibri

Qry Sum Total Replaced To Be Billed by Prin Project Pillar

  • Query: Qry Principal Project Pillar List

Qry Sum Total Spend by Principal Project

  • Query: Qry Report Principal Project Allocation Audit
  • Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

SQL

  • Module: basRelink

SubQry

  • Query: Qry Sum Total Replaced To Be Billed by Prin Project Pillar

SubQry Sum Total Replaced To Be Billed by Prin Project Pillar

  • Query: Qry Sum Total Replaced To Be Billed by Prin Project Pillar

dashboard

  • Module: Mod Utilities

the

  • Module: Mod Export Excel

vwGarnetRptPrincipalProjectAllocationAudit

  • Query: Qry Report Principal Project Allocation Audit

vwPurpleCountActiveAllocatedCompaniesbyPrinProjPillar

  • Query: Qry Report Action Log

vwPurpleCountExitedCompaniesbyPrincipalProjectPillar

  • Query: Qry Report Action Log

vwPurpleCountExitedNeedReplacementbyPrincipalProjectPillar

  • Query: Qry Report Action Log

vwPurpleCountUnallocatedCompaniesbyPrincipalProjectRec

  • Query: Qry Report Action Log

vwPurpleSumTotalReplacedBilledtoDatebyPrinProjectPillar

  • Query: Qry Principal Project Pillar List
  • Query: Qry Report Action Log

vwPurpleSumTotalReplacedSelectionFeebyPrinProjectPillar

  • Query: Qry Principal Project Pillar List
  • Query: Qry Report Action Log

vwPurpleSumTotalSponsorshipbyPrincipalProjectPillar

  • Query: Qry Report Action Log

vwPurpleWeavePrincipalProjectPillarList

  • Query: Qry Principal Project Pillar List

vwPurpleWeaveSumTotalNeedsRepBilledToDatebyPPPCriteria

  • Query: SubQry Sum Total Replaced To Be Billed by Prin Project Pillar

vwPurpleWeaveSumTotalReplacementAllocatedbyPPP

  • Query: Qry Sum Total Replaced To Be Billed by Prin Project Pillar

zstblODBC

  • Module: basRelink

zstblODBC_db

  • Query: qryLinkODBC

zstblODBC_tables

  • Module: basRelink
  • Query: qryLinkODBC