Skip to content

Dependency Analysis

Module Dependencies

Form_Add and Edit Budget Status

  • External: Actdatabase

Form_Add and Edit Campaign Status

  • External: Actdatabase

Form_Change Password

  • External: Actdatabase, RecSet

Form_Lead Type List

  • External: Actdatabase

Form_Marketing Campaign List

  • External: Actdatabase, RecSet

Form_Marketing Lead Report Date Dialog

  • External: Actdatabase, QryDef, TblRecSet, RecSet

Form_Opening Dialog

  • External: Actdatabase, RecSet

Form_Principal Projects No Marketing Campaign List

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

Mod Export Excel

  • External: Actdatabase, QryDef, RecSet

Mod Send Outlook Message

  • External: Attachments, Recipients, objOutlook, Session

Table Usage

Access

  • Module: basRelink

DatabaseUsers

  • Module: Form_Change Password
  • Module: Form_Opening Dialog

DoCmd

  • Module: Form_Principal Projects No Marketing Campaign List

Else

  • Module: basRelink

End

  • Module: basRelink

Entrepreneur Company

  • Query: SubQry Rpt Marketing Leads Criteria

Entrepreneur Status History

  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit

Entrepreneurs

  • Module: Form_Lead Type List
  • Query: Qry Get Lead Types for Passed Panel Entrepreneurs
  • Query: Qry Report Marketing Pre-Unqualified Leads
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count EOI
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit
  • Query: SubQry Rpt Marketing Leads Criteria

IndustryLookup

  • Query: Qry Lead Type List

Lead

  • Module: Form_Lead Type List
  • Query: Qry Lead Type List

Lead Types

  • Form: Add and Edit Lead Type
  • Query: Qry Get Lead Types for Passed Panel Entrepreneurs
  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry Lead Type List
  • Query: Qry Report Marketing EOI to Passed Panel
  • Query: Qry Report Marketing Pre-Unqualified Leads
  • Query: Qry SubRpt Marketing Sub Campaign Lead Types
  • Query: SubQry Rpt Marketing Leads Criteria

Marketing

  • Module: Form_Add and Edit Budget Status
  • Module: Form_Add and Edit Campaign Status
  • Module: Form_Add and Edit Marketing Campaign Category
  • Module: Form_Add and Edit Marketing Channel
  • Module: Form_Marketing Campaign List
  • Module: Form_SubFrm Marketing Campaign Commodities
  • Module: Form_SubFrm Marketing Campaign Lead Types
  • Module: Form_SubFrm Marketing Sub Campaign Lead Types
  • Module: Form_SubFrm Marketing Sub Campaign Locations
  • Query: Qry Marketing Budget Non Principal Project List
  • Query: Qry Marketing Sub Campaign List
  • Query: Qry Report Marketing Sub Campaign Expire 2 Days
  • Query: Qry Report Marketing Sub Campaign Spend
  • Query: Qry SubRpt Marketing Sub Campaign Lead Types
  • Query: Qry Sum Marketing Budget Non Principal Project
  • Query: Qry Sum Marketing Budget Principal Project
  • Query: Qry Sum Marketing Spend by Campaign
  • Query: Qry Sum Marketing Spend

Marketing Budget Non Principal Project

  • Form: Add and Edit Marketing Budget Non Principal Project
  • Query: Qry Marketing Budget Non Principal Project List
  • Query: Qry Sum Marketing Budget Non Principal Project

Marketing Campaign Category LookUp

  • Form: Add and Edit Marketing Campaign Category

Marketing Campaign Commodities

  • Form: SubFrm Marketing Campaign Commodities

Marketing Campaign Lead Types

  • Form: SubFrm Marketing Campaign Lead Types

Marketing Campaigns

  • Form: Add and Edit Marketing Campaign
  • Form: SubFrm Principal Project Marketing Campaign
  • Query: Qry Budget Spend Totals by Marketing Campaign
  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List
  • Query: Qry Principal Projects No Marketing Campaign
  • Query: Qry Report Marketing Spend Current Principal Projects
  • Query: Qry Report Marketing Spend Past Principal Projects
  • Query: Qry Report Marketing Sub Campaign Expire 2 Days
  • Query: Qry Report Marketing Sub Campaign Spend
  • Query: Qry Sum Marketing Budget Principal Project
  • Query: Qry Sum Marketing Spend

Marketing Channel LookUp

  • Form: Add and Edit Marketing Channel

Marketing Sub Campaign Lead Types

  • Form: SubFrm Marketing Sub Campaign Lead Types
  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry SubRpt Marketing Sub Campaign Lead Types

Marketing Sub Campaign Locations

  • Form: SubFrm Marketing Sub Campaign Locations

Marketing Sub Campaigns

  • Form: Add and Edit Marketing Sub Campaign
  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry Marketing Sub Campaign List
  • Query: Qry Report Marketing Sub Campaign Expire 2 Days
  • Query: Qry Report Marketing Sub Campaign Spend
  • Query: Qry Sum Marketing Spend by Campaign
  • Query: Qry Sum Marketing Spend

MarketingBudgetStatus

  • Module: Form_Add and Edit Budget Status
  • Form: Add and Edit Budget Status
  • Query: Qry Marketing Budget Non Principal Project List

MarketingCampaignStatus

  • Module: Form_Add and Edit Campaign Status
  • Form: Add and Edit Campaign Status
  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List
  • Query: Qry Report Marketing Spend Current Principal Projects
  • Query: Qry Report Marketing Spend Past Principal Projects

MsgBox

  • Module: Form_Change Password

Next

  • Module: basRelink

Principal

  • Query: Qry Budget Spend Totals by Marketing Campaign
  • Query: Qry Principal Projects No Marketing Campaign
  • Query: Qry SubFrm Principal Project Pillar Supporting Documents
  • Query: Qry Sum Total Spend by Principal Project

Principal Project Pillar Commodities

  • Form: SubFrm Principal Project Pillar Commodities

Principal Project Pillar Delivery Location

  • Form: SubFrm Principal Project Pillar Delivery Location

Principal Project Pillars

  • Form: SubFrm Principal Project Pillars
  • Query: Qry SubFrm Principal Project Pillar Supporting Documents
  • Query: Qry Sum Total Spend by Principal Project

Principal Project Products Sold

  • Form: SubFrm Principal Project Products Sold

Principal Projects

  • Form: Add and Edit Marketing Campaign View Principal Project
  • Query: Qry Budget Spend Totals by Marketing Campaign
  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry Lead Type List
  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List
  • Query: Qry Principal Projects No Marketing Campaign
  • Query: Qry Report Marketing Spend Current Principal Projects
  • Query: Qry Report Marketing Spend Past Principal Projects
  • Query: Qry Report Marketing Sub Campaign Expire 2 Days
  • Query: Qry Report Marketing Sub Campaign Spend
  • Query: Qry Sum Marketing Budget Principal Project

Principals

  • Query: Qry Get Marketing Sub Campaign Expire 2 Days
  • Query: Qry Lead Type List
  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List
  • Query: Qry Principal Projects No Marketing Campaign
  • Query: Qry Report Marketing Spend Current Principal Projects
  • Query: Qry Report Marketing Spend Past Principal Projects
  • Query: Qry Report Marketing Sub Campaign Expire 2 Days
  • Query: Qry Report Marketing Sub Campaign Spend

ProcessStatus

  • Query: Qry Get Lead Types for Passed Panel Entrepreneurs
  • Query: Qry Report Marketing Pre-Unqualified Leads
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit
  • Query: SubQry Rpt Marketing Leads Criteria

Qry

  • Module: Form_Lead Type List
  • Module: Form_Marketing Campaign List
  • Module: Form_Principal Projects No Marketing Campaign List
  • Query: Qry Budget Spend Totals

Qry Budget Spend Totals

  • Form: Marketing Campaign List

Qry Budget Spend Totals by Marketing Campaign

  • Form: SubFrm Principal Project Marketing Campaign Budget Data
  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List
  • Query: Qry Report Marketing Spend Current Principal Projects
  • Query: Qry Report Marketing Spend Past Principal Projects

Qry Report Marketing Leads Version Two

  • Report: Calibri

Qry Report Marketing Sub Campaign Expire 2 Days

  • Report: Calibri

Qry Report Marketing Sub Campaign Spend

  • Report: Calibri

Qry SubRpt Marketing Sub Campaign Lead Types

  • Report: Calibri

Qry Sum Marketing Budget Non Principal Project

  • Query: Qry Budget Spend Totals

Qry Sum Marketing Budget Principal Project

  • Query: Qry Budget Spend Totals

Qry Sum Marketing Spend

  • Query: Qry Budget Spend Totals

Qry Sum Marketing Spend by Campaign

  • Query: Qry Budget Spend Totals by Marketing Campaign

Qry Sum Total Spend by Principal Project

  • Query: Qry Marketing Campaign List Other
  • Query: Qry Marketing Campaign List

RecSet

  • Module: Form_Marketing Lead Report Date Dialog

SQL

  • Module: basRelink

Sales

  • Module: Form_SubFrm Principal Project Pillar Commodities

SubQry

  • Query: Qry Report Lead Type to Principal Allocation
  • Query: Qry Report Marketing Leads Version Two
  • Query: SubQry Rpt Count Followed Up Leads
  • Query: SubQry Rpt Count On Hold Leads
  • Query: SubQry Rpt Count Qualified Leads
  • Query: SubQry Rpt Count Terminated Leads
  • Query: SubQry Rpt Count Total Leads Generated
  • Query: SubQry Rpt Count Uncontacted Leads
  • Query: SubQry Rpt Count Unqualified Leads
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified

SubQry Rpt Count Followed Up Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count On Hold Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count Qualified Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count Terminated Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count Total Leads Generated

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count Uncontacted Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Count Unqualified Leads

  • Query: Qry Report Marketing Leads Version Two

SubQry Rpt Lead Type to Principal Allocation Criteria

  • Query: Qry Report Lead Type to Principal Allocation

SubQry Rpt Marketing EOI to Passed Panel Count EOI

  • Query: Qry Report Marketing EOI to Passed Panel

SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel

  • Query: Qry Report Marketing EOI to Passed Panel

SubQry Rpt Marketing EOI to Passed Panel Count Qualified

  • Query: Qry Report Marketing EOI to Passed Panel

SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit

  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified

SubQry Rpt Marketing Leads Criteria

  • Query: SubQry Rpt Count Followed Up Leads
  • Query: SubQry Rpt Count On Hold Leads
  • Query: SubQry Rpt Count Qualified Leads
  • Query: SubQry Rpt Count Terminated Leads
  • Query: SubQry Rpt Count Total Leads Generated
  • Query: SubQry Rpt Count Uncontacted Leads
  • Query: SubQry Rpt Count Unqualified Leads

Temp

  • Module: Form_Marketing Lead Report Date Dialog
  • Query: Qry Report Marketing EOI to Passed Panel
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count EOI
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit

Temp Lead Type for Lead Report

  • Query: Qry Report Marketing EOI to Passed Panel
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count EOI
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel
  • Query: SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit

UnqualifiedReason

  • Query: Qry Report Marketing Pre-Unqualified Leads

dashboard

  • Module: Mod Utilities

the

  • Module: Form_SubFrm Marketing Campaign Commodities
  • Module: Form_SubFrm Marketing Campaign Lead Types
  • Module: Form_SubFrm Marketing Sub Campaign Lead Types
  • Module: Form_SubFrm Marketing Sub Campaign Locations
  • Module: Mod Export Excel

vwPurpleRptLeadTypetoPrincipalAllocationCriteria

  • Query: SubQry Rpt Lead Type to Principal Allocation Criteria

zstblODBC

  • Module: basRelink

zstblODBC_db

  • Query: qryLinkODBC

zstblODBC_tables

  • Module: basRelink
  • Query: qryLinkODBC

Form Usage

Frm

  • Module: Form_Add and Edit Lead Type
  • Module: Form_Add and Edit Marketing Budget Non Principal Project
  • Module: Form_Add and Edit Marketing Campaign View Principal Project
  • Module: Form_Add and Edit Marketing Campaign
  • Module: Form_Add and Edit Marketing Sub Campaign
  • Module: Form_Change Password
  • Module: Form_Lead Type List
  • Module: Form_Lead Type Principal Project Report Dialog
  • Module: Form_Marketing Campaign List
  • Module: Form_Marketing Lead Report Date Dialog
  • Module: Form_Opening Dialog
  • Module: Form_Principal Projects No Marketing Campaign List
  • Module: Form_Report Menu
  • Module: Form_Reports Date Dialog
  • Module: Form_Reports Print Export Date Dialog
  • Module: Form_Reports Print Export Dialog
  • Module: Form_SubFrm Principal Project Pillar Commodities

Macro Actions Summary