Skip to content

topaz - Implementation Details

VBA Modules

Form_Add and Edit Budget Status (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Budget Status.txt Lines: 72

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Campaign Status (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Campaign Status.txt Lines: 72

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Lead Type (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Lead Type.txt Lines: 31

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Form_Add and Edit Marketing Budget Non Principal Project (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Budget Non Principal Project.txt Lines: 30

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Form_Add and Edit Marketing Campaign Category (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Campaign Category.txt Lines: 61

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Marketing Campaign View Principal Project (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Campaign View Principal Project.txt Lines: 33

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Marketing Campaign (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Campaign.txt Lines: 31

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Form_Add and Edit Marketing Channel (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Channel.txt Lines: 61

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Marketing Sub Campaign (Form)

File: ms_access_files\topaz\Forms\Frm Add and Edit Marketing Sub Campaign.txt Lines: 30

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Form_Change Password (Form)

File: ms_access_files\topaz\Forms\Frm Change Password.txt Lines: 138

Procedures

Private Sub CancelButton_Click()

Private Sub CurrentPassword_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub NewPassword_AfterUpdate()

Private Sub OKButton_Click()

Form_Display Marketing Sub Campaigns Expire 2 Days List (Form)

File: ms_access_files\topaz\Forms\Frm Display Marketing Sub Campaigns Expire 2 Days List.txt Lines: 25

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub PrintReport_Click()

Form_Lead Type List (Form)

File: ms_access_files\topaz\Forms\Frm Lead Type List.txt Lines: 92

Procedures

Public Sub UpdateList()

Private Sub AddLeadType_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub LeadTypeList_DblClick(Cancel As Integer)

Private Sub LeadTypeList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Private Sub StrCriteria1_AfterUpdate()

Form_Lead Type Principal Project Report Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Lead Type Principal Project Report Dialog.txt Lines: 45

Procedures

Private Sub Form_Close()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Maintenance Menu (Form)

File: ms_access_files\topaz\Forms\Frm Maintenance Menu.txt Lines: 40

Procedures

Private Sub BudgetStatus_Click()

Private Sub CampaignCategory_Click()

Private Sub CampaignStatus_Click()

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub LeadTypes_Click()

Private Sub MarketingChannel_Click()

Form_Marketing Campaign List (Form)

File: ms_access_files\topaz\Forms\Frm Marketing Campaign List.txt Lines: 284

Procedures

Public Sub UpdateList() - ⚠️ High branching (9 If statements)

Private Sub AddBudgetItem_Click()

Private Sub AddPrincipalProjectCampaign_Click()

Private Sub AddSubCampaign_Click()

Private Sub AddUnrelatedCampaign_Click()

Private Sub BudgetItemList_DblClick(Cancel As Integer)

Private Sub BudgetItemList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub BudgetStatus_AfterUpdate()

Private Sub CampaignStatus_AfterUpdate()

Private Sub ClearFilters_Click()

Private Sub CloseFOrm_Click()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MaintenanceFunction_Click()

Private Sub MarketingCampaignList_AfterUpdate()

Private Sub MarketingCampaignList_DblClick(Cancel As Integer)

Private Sub MarketingCampaignList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Private Sub MarketingSubCampaignList_DblClick(Cancel As Integer)

Private Sub MarketingSubCampaignList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Marketing Lead Report Date Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Marketing Lead Report Date Dialog.txt Lines: 100

Procedures

Public Sub PopulateTempLeads()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Opening Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Opening Dialog.txt Lines: 103

Procedures

Private Sub CancelButton_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub Password_AfterUpdate()

Private Sub Username_AfterUpdate()

Form_Principal Projects No Marketing Campaign List (Form)

File: ms_access_files\topaz\Forms\Frm Principal Projects No Marketing Campaign List.txt Lines: 83

Procedures

Public Sub UpdateList()

Private Sub Add_Marketing_Campaign_Click()

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub StrCriteria1_AfterUpdate()

Form_Report Menu (Form)

File: ms_access_files\topaz\Forms\Frm Report Menu.txt Lines: 63

Procedures

Private Sub CloseFOrm_Click() - ⚠️ Contains GoTo statements

Private Sub CurrentandPastProjectBudgetSpendFigures_Click()

Private Sub LeadTypePrincipalAllocation_Click()

Private Sub MarketingEOItoPassedPanelReport_Click()

Private Sub MarketingLeadReportVersionTwo_Click()

Private Sub MarketingPreUnqualifiedLeads_Click()

Private Sub SubCampaignsEnding2Days_Click()

Private Sub SubCampaignSpendReport_Click()

Form_Reports Date Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Reports Date Dialog.txt Lines: 54

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Print Export Date Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Reports Print Export Date Dialog.txt Lines: 52

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Print Export Dialog (Form)

File: ms_access_files\topaz\Forms\Frm Reports Print Export Dialog.txt Lines: 44

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Marketing Campaign Commodities (Form)

File: ms_access_files\topaz\Forms\SubFrm Marketing Campaign Commodities.txt Lines: 20

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Marketing Campaign Lead Types (Form)

File: ms_access_files\topaz\Forms\SubFrm Marketing Campaign Lead Types.txt Lines: 20

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Marketing Sub Campaign Lead Types (Form)

File: ms_access_files\topaz\Forms\SubFrm Marketing Sub Campaign Lead Types.txt Lines: 20

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Marketing Sub Campaign Locations (Form)

File: ms_access_files\topaz\Forms\SubFrm Marketing Sub Campaign Locations.txt Lines: 20

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Principal Project Pillar Commodities (Form)

File: ms_access_files\topaz\Forms\SubFrm Principal Project Pillar Commodities.txt Lines: 29

Procedures

Private Sub Commodity_AfterUpdate()

Private Sub DeleteRec_Click()

File: ms_access_files\topaz\Modules\basRelink.bas Lines: 604

Procedures

Public Function RelinkODBC() As Boolean - ⚠️ Contains GoTo statements; High branching (7 If statements); Large procedure (153 lines)

Public Function Update_zstblODBC() As Boolean - ⚠️ Contains GoTo statements

Public Function RelinkTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesMain() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function TableExists(ByVal pstrTableName As String) As Boolean - ⚠️ Uses On Error Resume Next

Public Sub PopulateTableList() - ⚠️ Contains GoTo statements

Mod Export Excel (Standard)

File: ms_access_files\topaz\Modules\Mod Export Excel.bas Lines: 693

Procedures

Public Sub ExportMarketingLeadsVersionTwoToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportMarketingPreUnqualifiedLeadsToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportMarketingEOItoPassedPanelToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportMarketingLeadTypePrincipalAllocationToExcel() - ⚠️ Contains GoTo statements; Large procedure (129 lines)

Public Sub ExportMarketingSubCampaignSpendToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (103 lines)

Public Sub ExportMarketingSpendPastAndFutureProjectsToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (189 lines)

Mod Send Outlook Message (Standard)

File: ms_access_files\topaz\Modules\Mod Send Outlook Message.bas Lines: 53

Procedures

Public Sub SendOutlookMessage(Recip As String, Optional fileName As String, Optional SubText As String, Optional BodyText As String, Optional CCText As String)

Mod Utilities (Standard)

File: ms_access_files\topaz\Modules\Mod Utilities.bas Lines: 140

Procedures

Public Function GetXofY(f As Form) - ⚠️ Uses On Error Resume Next

Public Function IsLoaded(ByVal strFormName As String) As Boolean

Public Function StringsSameCase(x As String, y As String) As Boolean

Public Function CheckForUpper(CheckString As String)

Public Function CheckForSpecial(CheckString As String)

Public Function CheckForNumber(CheckString As String)

Public Sub DeleteImportErrorTables()

Public Sub ObjectCounts()

SQL Queries

Qry Budget Spend Totals by Marketing Campaign

Type: Select

SELECT [Marketing Campaigns].[Marketing Campaign ID], IIf(IsNull([Standard Marketing Budget]),0,[Standard Marketing Budget])+IIf(IsNul, IIf(IsNull([Total Marketing Spend]),0,[Total Marketing Spend]), [Total Project Budget]-[Marketing Spend] FROM [Principal Projects], [Marketing Campaigns], [Qry Sum Marketing Spend by Campaign]

Qry Budget Spend Totals

Type: Select

SELECT [Qry Sum Marketing Budget Non Principal Project].[Total Marketing Budget Non Pri, [Qry Sum Marketing Budget Principal Project].[Total Marketing Budget Principal P, IIf(IsNull([Total Marketing Budget Non Principal Project]),0,[Total Marketing Bu, [Qry Sum Marketing Spend].[Total Marketing Spend], [Total Budget]-IIf(IsNull([Total Marketing Spend]),0,[Total Marketing Spend]) FROM [Qry Sum Marketing Budget Non Principal Project], [Qry Sum Marketing Budget Principal Project], [Qry Sum Marketing Spend]

Qry Get Lead Types for Passed Panel Entrepreneurs

Type: Select

SELECT Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Source], Entrepreneurs.[PP Results] FROM [Entrepreneurs], [Lead Types], [ProcessStatus] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Marketing Lead Report Date Dia

Qry Get Marketing Sub Campaign Expire 2 Days

Type: Select

(((DateDiff(\"d\",Date(),[Marketing Sub Campaign End Date]))>0 And (DateDiff(\"d

Qry Lead Type List

Type: Select

SELECT [Lead Types].[Lead Type ID], [Lead Types].[Lead Type], [Lead Types].[Lead Source], [Principal] & \, [Lead Types].[Lead Format], IndustryLookup.Industry, [Lead Types].[Import Template], [Lead Types].Status FROM [Lead Types], [IndustryLookup], [Principal Projects], [Principals]

Qry Marketing Budget Non Principal Project List

Type: Select

SELECT [Marketing Budget Non Principal Project].[Marketing Budget ID], [Marketing Budget Non Principal Project].[Date Budget Created], [Marketing Budget Non Principal Project].[Marketing Budget Status ID], MarketingBudgetStatus.Status, [Marketing Budget Non Principal Project].[Budget Year], [Marketing Budget Non Principal Project].[Budget Description], [Marketing Budget Non Principal Project].[Budget Amount] FROM [Marketing Budget Non Principal Project], [MarketingBudgetStatus]

Qry Marketing Campaign List Other

Type: Select

SELECT [Marketing Campaigns].[Marketing Campaign ID], [Principal Projects].[Principal Project ID], [Marketing Campaigns].[Marketing Campaign Status ID], [Principal] & \, [Qry Sum Total Spend by Principal Project].[Total Companies Required], [Principal Projects].[Standard Marketing Budget], [Qry Budget Spend Totals by Marketing Campaign].[Marketing Spend], [Qry Budget Spend Totals by Marketing Campaign].Remaining, [Principal Projects].[Additional Marketing Costs], [Marketing Campaigns].[Marketing Campaign], [Marketing Campaigns].[Job Number], MarketingCampaignStatus.Status FROM [Principals], [Principal Projects], [Qry Sum Total Spend by Principal Project], [Marketing Campaigns], [MarketingCampaignStatus], [Qry Budget Spend Totals by Marketing Campaign]

Qry Marketing Campaign List

Type: Select

SELECT [Marketing Campaigns].[Marketing Campaign ID], [Principal Projects].[Principal Project ID], [Marketing Campaigns].[Marketing Campaign Status ID], IIf(IsNull([Project Name]),[Marketing Campaign],[Principal] & \, [Qry Sum Total Spend by Principal Project].[Total Companies Required], [Principal Projects].[Standard Marketing Budget], [Qry Budget Spend Totals by Marketing Campaign].[Marketing Spend], [Qry Budget Spend Totals by Marketing Campaign].Remaining, [Principal Projects].[Additional Marketing Costs], [Marketing Campaigns].[Marketing Campaign], [Marketing Campaigns].[Job Number], MarketingCampaignStatus.Status FROM [Principals], [Principal Projects], [Qry Sum Total Spend by Principal Project], [Marketing Campaigns], [MarketingCampaignStatus], [Qry Budget Spend Totals by Marketing Campaign]

Qry Marketing Sub Campaign List

Type: Select

SELECT [Marketing Sub Campaigns].[Marketing Sub Campaign ID], [Marketing Sub Campaigns].[Marketing Campaign ID], [Marketing Sub Campaigns].[Marketing Channel], [Marketing Sub Campaigns].[Marketing Sub Campaign Start Date] FROM [Marketing Sub Campaigns]

Qry Principal Projects No Marketing Campaign

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal Projects].[Sales Brief ID], [Principal Projects].[Sales Brief Number], [Principal] & \, [Principal Projects].[Solutions Architect], [Principal Projects].[Brief Date], [Principal Projects].[Version Number] FROM [Principal Projects], [Marketing Campaigns], [Principals] WHERE ((([Principal Projects].[Sales Brief Number]) Is Not Null) AND (([Marketing Camp

Qry Report Lead Type to Principal Allocation

Type: Select

SELECT [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type Principal Pro, [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type], [SubQry Rpt Lead Type to Principal Allocation Criteria].[Allocated Same as Lead , Count([SubQry Rpt Lead Type to Principal Allocation Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Type to Principal Allocation Criteria]

Qry Report Marketing EOI to Passed Panel

Type: Select

SELECT [Temp Lead Type for Lead Report].[Lead Type ID], [Lead Types].[Lead Type], [SubQry Rpt Marketing EOI to Passed Panel Count EOI].[Number of EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified].[Number Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel].[Number Passed Pan, [Number Passed Panel]/[Number Qualified] FROM [Temp Lead Type for Lead Report], [Lead Types], [SubQry Rpt Marketing EOI to Passed Panel Count EOI], [SubQry Rpt Marketing EOI to Passed Panel Count Qualified], [SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel]

Qry Report Marketing Leads Version Two

Type: Select

SELECT [SubQry Rpt Count Total Leads Generated].[Lead Type], [SubQry Rpt Count Total Leads Generated].[Total Leads Generated], IIf(IsNull([Qualified Leads]),0,[Qualified Leads]), IIf(IsNull([Unqualified Leads]),0,[Unqualified Leads]), IIf(IsNull([Uncontacted Leads]),0,[Uncontacted Leads]), IIf(IsNull([To Be Followed Up Leads]),0,[To Be Followed Up Leads]), IIf(IsNull([Terminated Leads]),0,[Terminated Leads]), IIf(IsNull([On Hold Leads]),0,[On Hold Leads]) FROM [SubQry Rpt Count Total Leads Generated], [SubQry Rpt Count Qualified Leads], [SubQry Rpt Count Unqualified Leads], [SubQry Rpt Count Uncontacted Leads], [SubQry Rpt Count Followed Up Leads], [SubQry Rpt Count Terminated Leads], [SubQry Rpt Count On Hold Leads]

Qry Report Marketing Pre-Unqualified Leads

Type: Select

SELECT Entrepreneurs.[Date Record Created], Entrepreneurs.[Reference Number], [Lead Types].[Lead Type], [First Name] & \, Entrepreneurs.[EOI Business Name], Entrepreneurs.[Email Address], ProcessStatus.Status, UnqualifiedReason.[Unqualified Reason], ProcessStatus.[Process Status ID], UnqualifiedReason.[Unqualified Reason ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [UnqualifiedReason] WHERE (((Entrepreneurs.[Date Record Created])>=[Forms]![Frm Marketing Lead Report Date

Qry Report Marketing Spend Current Principal Projects

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal] & \, [Principal Projects].[Contract Start Date] FROM [Principals], [Principal Projects], [Marketing Campaigns], [Qry Budget Spend Totals by Marketing Campaign], [MarketingCampaignStatus] WHERE ((([Principal Projects].[Contract End Date])>=Date()))

Qry Report Marketing Spend Past Principal Projects

Type: Select

SELECT [Principal Projects].[Principal Project ID], [Principal] & \, [Principal Projects].[Contract Start Date] FROM [Principals], [Principal Projects], [Marketing Campaigns], [Qry Budget Spend Totals by Marketing Campaign], [MarketingCampaignStatus] WHERE ((([Principal Projects].[Contract End Date])<Date()))

Qry Report Marketing Sub Campaign Expire 2 Days

Type: Select

SELECT [Marketing Sub Campaigns].[Marketing Sub Campaign ID] FROM [Marketing Campaigns], [Marketing Sub Campaigns], [Principal Projects], [Principals] WHERE (((DateDiff(\"d\",Date(),[Marketing Sub Campaign End Date]))>0 And (DateDiff(\"d

Qry Report Marketing Sub Campaign Spend

Type: Select

SELECT IIf(IsNull([Project Name]),[Marketing Campaign],[Principal] & \, [Marketing Sub Campaigns].[Marketing Sub Campaign Start Date] FROM [Marketing Sub Campaigns], [Marketing Campaigns], [Principal Projects], [Principals] WHERE ((([Marketing Sub Campaigns].[Marketing Sub Campaign Start Date])>=[Forms]![Frm

Qry SubFrm Principal Project Pillar Supporting Documents

Type: Select

SELECT [Principal Project Pillars].[Principal Project Pillar ID], IIf([Supporting Doc Affidavit (EME)]=True,\ FROM [Principal Project Pillars]

Qry SubRpt Marketing Sub Campaign Lead Types

Type: Select

SELECT [Marketing Sub Campaign Lead Types].[Marketing Sub Campaign ID], [Lead Types].[Lead Type] FROM [Marketing Sub Campaign Lead Types], [Lead Types]

Qry Sum Marketing Budget Non Principal Project

Type: Select

SELECT Sum([Marketing Budget Non Principal Project].[Budget Amount]) FROM [Marketing Budget Non Principal Project] WHERE ((([Marketing Budget Non Principal Project].[Marketing Budget Status ID])=1))

Qry Sum Marketing Budget Principal Project

Type: Select

SELECT Sum(IIf(IsNull([Standard Marketing Budget]),0,[Standard Marketing Budget])+IIf(I FROM [Marketing Campaigns], [Principal Projects] WHERE ((([Marketing Campaigns].[Marketing Campaign Status ID])=1))

Qry Sum Marketing Spend by Campaign

Type: Select

SELECT [Marketing Sub Campaigns].[Marketing Campaign ID], Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend]) FROM [Marketing Sub Campaigns]

Qry Sum Marketing Spend

Type: Select

SELECT Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend]) FROM [Marketing Sub Campaigns], [Marketing Campaigns] WHERE ((([Marketing Campaigns].[Marketing Campaign Status ID])=1))

Qry Sum Total Spend by Principal Project

Type: Select

SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillars].[Amount Sponsored]), Sum([Principal Project Pillars].[Number of Companies Required]) FROM [Principal Project Pillars]

qryLinkODBC

Type: Select

SELECT zstblODBC_db.Driver, zstblODBC_db.ServerName, zstblODBC_db.DBName, zstblODBC_db.Authentication, zstblODBC_db.UID, zstblODBC_db.PWD, zstblODBC_tables.Hidden, zstblODBC_tables.TableName, zstblODBC_tables.SourceTableName, zstblODBC_tables.AfterDDL FROM [zstblODBC_db], [zstblODBC_tables] WHERE (((zstblODBC_db.SelectDB)=True) AND ((zstblODBC_tables.Link)=True))

SubQry Rpt Count Followed Up Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=1))

SubQry Rpt Count On Hold Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=64))

SubQry Rpt Count Qualified Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Step Number])>=2 And ([SubQry Rpt Mark

SubQry Rpt Count Terminated Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=41))

SubQry Rpt Count Total Leads Generated

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria]

SubQry Rpt Count Uncontacted Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=4))

SubQry Rpt Count Unqualified Leads

Type: Select

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria] WHERE ((([SubQry Rpt Marketing Leads Criteria].[Process Status ID])=59))

SubQry Rpt Lead Type to Principal Allocation Criteria

Type: Select

SELECT vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project ID, vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type], IIf(IsNull([Allocated Principal Project ID]),\, IIf(IsNull([Company Status]),[Process Status],[Company Status]), vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Entrepreneur ID], vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Company Name], [First Name] & \, [Lead Principal] & \, [Allocated Principal] & \ FROM [vwPurpleRptLeadTypetoPrincipalAllocationCriteria] WHERE (((vwPurpleRptLeadTypetoPrincipalAllocationCriteria.[Lead Type Principal Project

SubQry Rpt Marketing EOI to Passed Panel Count EOI

Type: Select

SELECT Entrepreneurs.[Lead Type ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Temp Lead Type for Lead Report], [Entrepreneurs]

SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel

Type: Select

SELECT Entrepreneurs.[Lead Type ID], Entrepreneurs.[PP Results], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Temp Lead Type for Lead Report], [Entrepreneurs]

SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit

Type: Select

SELECT Entrepreneurs.[Lead Type ID], Entrepreneurs.[Entrepreneur ID] FROM [Temp Lead Type for Lead Report], [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))

SubQry Rpt Marketing EOI to Passed Panel Count Qualified

Type: Select

SELECT [SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit].[Lead Type ID], Count([SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit].[Entrepren FROM [SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit]

SubQry Rpt Marketing Leads Criteria

Type: Select

SELECT Entrepreneurs.[Date Record Created], [Lead Types].[Lead Source], Entrepreneurs.[Lead Type ID], [Lead Types].[Lead Type], Entrepreneurs.[Process Status ID], ProcessStatus.[Step Number], Entrepreneurs.[Entrepreneur ID], [Entrepreneur Company].[Company Status ID] FROM [Entrepreneurs], [Lead Types], [ProcessStatus], [Entrepreneur Company] WHERE (((Entrepreneurs.[Date Record Created])>=Forms![Frm Marketing Lead Report Date D