Article Details
Id:9587
Product:finPOWER Connect
Type:FIX
Version:1.04.04
Opened:20/01/2012
Closed:20/01/2012
Released:01/02/2012
Job: J008841
High Importance

VBA Templates error if record primary key is greater than 32767

The following VBA Templates had primary key variables, e.g., AccountPk declared as Integer data types. This causes a run-time error if a record has a primary key greater than 32767:

Account_Advice.dot
Account_PaymentArrangement.dot
Account_PaymentDishonour.dot
Account_Tax_Number_Invalid_NZ.dot
Client_AddressSanitise.dot
Client_Advice.dot
Disbursement_Remittance.dot
Loan_Contract_AU.dot
Loan_Contract_NZCCCFA.dot
Loan_Contract_NZCCCFA_RC.dot
Loan_CreditCard_Update.dot
Loan_DeclarationOfPurpose_NZCCCFA.dot
Loan_New.dot
Loan_Overdue_PrePossessionNotice.dot
Loan_Overdue_Reminder1.dot
Loan_Overdue_RepossessionAuthority.dot
Loan_Statement.dot
Loan_ThankYou.dot
SecurityStatement_Advice.dot
SecurityStatement_PPSR_DebtorAdvice_NZ.dot
SecurityStatement_PPSR_GrantorAdvice_AU.dot
User_Advice.dot

These Templates now declare primary key variables as the Long data type which is the VBA equivalent of a .NET Integer.