FAQ: Frequently Asked Questions

Frequently asked questions for easy and quick resolution to problems.

Symptoms: Sometimes #Name appears on reports. When it appears, the report is impossible to export to excel.

Fix: Make sure that the DLL MSADO15.DLL is registered. In Windows 7 it resides in “C:\program Files\common Files\System\ado”.

The command to register this file manually is:
regsvr32 “C:\program Files\common Files\System\ado\msado15.dll”

Secondary Fix: Download the following service pack and install
http://tango32.com/downloads/Tango32SP3.exe

It will try to install several different DLL's. 
Warning: If will warn if the installed DLL is newer.  If the installed DLL is newer, it should not be overwritten.

Symptom:Access Runtime Fails to Install for Terminal Services

Fix: You must use an Transform file to install the runtime for terminal services.


You can find the instructions at the following link:
http://support.microsoft.com/kb/244439

You get the error: "regsvr32 invalid access to memory location".

The problem is with Data Execution Prevention

  • Disable DEP: bcdedit.exe /set {current} nx AlwaysOff
  • Register the ocx/dll file with regsvr32
  • Enable DEP: bcdedit.exe /set {current} nx OptIn
  1. Check if there are multiple borrowers.
  2. If there are multiple borrowers then make sure pay by Direct Debit/credit is not ticked on each of the borrowers.
There are two ways to disable ODI on an Account or Set of Accounts.

  1. Disable ODI on the Business Code by selecting the ODI method "None", this will affect every account that uses this business code.

  2. If you wish to disable ODI for a single account. You can disable ODI via the Arrears Tab on the Loan screen.
    To do this open the account and select the arrears tab. Set the value of the ODI Rate to -1.

    This will stop ODI being charged for this account only.

Problem: Getting "Cannot find file" or "DisplayURL (2): Method 'Navigate' of object 'IWebBrowser2' failed".


Cause: This can be caused by a long adhoc query returning output that isn't a dataset.

Fix: Adding "SET NOCOUNT ON" to your query may fix the problem.


  1. Create batch as normal, except tick "Re-do transactions that have already been done to date?".
  2. Click "Create Transactions" to continue.
  3. Select the Transactions -> Loan Transaction Entry menu item to open the "Select a Batch" screen if it is not already open, then select "Export" on the newly created batch.

Warning: Once you have exported the batch, it should be deleted. Do not re-post the batch, or you will have duplicate transactions.
To access the Depreciation Schedule navigate to the following menu item:

Report -> Assets and Leasing -> Asset Register

  1. Open Tango and login.
  2. Click File (Office 2010) or the windows button (Office 2007)
  3. Select Privacy options, this should open Access options.
  4. Select Current Database from the available options in the side bar.
  5. de-select "Allow Built-in Toolbars" and click OK.
  6. Restart Tango.

All of Expert1's products run against a Microsoft SQL server backend.


For instructions on how to restore a backup see the following resources:
Sometimes the Development Window shows when Tango starts up. To fix this navigate to:

Development -> Tools -> Debug Settings


Select the "User Startup Properties" button and then restart Tango. The developer window should now no longer appear.

Note: You must be a Tango Administrator to access the development menu.

How to Rollover an investment account.

Perform the following steps to rollover an investment account

  1. Generate a Payout quote valid to the day of the payout.
  2. Determine if any amount is to be paid to the investor
  3. Generate a batch transaction.
    1. Date - day interest is calculated to. Day before payout date
    2. Type - IV Payout
    3. Amount - amount to be paid to the investor
    4. Narrative and Reference as required.
    5. Save the transaction
  4. Response to prompt to Reinvest funds
    1. Yes to this question will open the refinance form
      1. Check the amounts are correct
      2. Set the start date and maturity date
      3. Select the correct Business code
      4. Set the rate
    2. No will cause the amount entered to be paid out to the investor. Remaining funds will be held in the existing investment account
  5. Post the batch. If you clicked Yes to rollover the existing account will be closed and a new account created with the opening balance being the difference between the Balance of the old account + interest - amount paid to investor.
  6. Check new investment account.
  7. Activate new investment account.

A report does not include active accounts that have run full term and are still in arrears.


Fix: Check the system settings 
Setup -> Parameters -> Loan-1 tab

Under Arrears there are two options:
  • Arrears Balance does not change when account reaches maturity date
  • Number of days in arrears does not change when account reaches maturity date

Tick them and this should fix the problem.

To reverse the Write Off transaction you can either:

  • Enter a Reversal Transaction (Amounts must be equal)
  • or Void the Write Off Transaction

The preferred method is to void the transaction.

Following a security update from Microsoft some users may not be able to run Tango or check for updates using Tango's update facility.


Symptoms:
Window appears with "Status Message" followed by the error "Object or class does not support the set of events".

The following Knowledge Base article from Microsoft addresses this issue.