|These instructions only apply to RTG Bills and RTG Timer Version 2.16 or below. For Version 2.17 and above, see Fix Bills or Timer Database.|
The error message Invalid use of Null may occur when you try to edit a matter, fee, expense, payment, or adjustment. It also may occur when you try to view or print a bill, a prebill, or a report. When you click OK in response to the error message, RTG Bills exits.
This problem occurs when a record in the database contains bad data. A field in the record contains Null, which in database terminology means that the field was not given any value.
For example, a payment record should contain the amount of the payment that was applied to fees, expenses, late charges, and taxes. If none of the payment was applied to taxes, that field should contain a currency amount of zero. But if this field was not set by the program, it will contain Null instead of zero.
Click here to skip further explanation of this problem and go directly to the solution.
Bugs in older versions of RTG Bills are known to cause this problem:
In addition to these known problems, it is always possible that a previously-unreported programming error can create a Null value. Report the problem to RTG if you don't believe that the above situations apply to you.
You can download a small program that will quickly fix the bad database records. It puts appropriate "default" values in the fields which now contain Null.
This program also fixes the problem of negative zero matter balances by properly rounding currency amounts in the database to two decimal places. (This problem was corrected in RTG Bills Version 1.25, but your database may need to be fixed if you have used an earlier version.)
The correction program works with RTG Bills Version 2.05 and above. There is a separate correction program for RTG Bills Versions 1.22, 1.23, 1.24, and 1.25. If you have an older version of RTG Bills, you must upgrade before you can use the correction program. Upgrades are discussed on the Support page.
You must save this program, fixbd.exe or fix125.exe, in the same folder as the RTG Bills program. For a standalone computer, this is usually C:\Program Files\Rtgbills for Version 2 and C:\Rtgbills for Version 1. The program is very small, so you can copy it to a floppy disk and take it to another computer if RTG Bills is installed elsewhere.
Error opening database:
Could not find file '[path] \RTGBILLS.MDB'.
it is because you didn't put the program in the folder that contains the RTG Bills database. Move the program to the same folder as the database (the file Rtgbills.mdb) and try again.
This should solve the problem.
If you still get the error message, note the exact circumstances under which you see the error message and contact RTG.
The database problem described above for RTG Bills rarely occurs in RTG Timer. However, it can happen and we have a program to fix it. It changes Null values in the Discount Percent field to zero. The detailed instructions which follow are essentially the same as the previous instructions for RTG Bills.
The correction program works with RTG Timer Version 2.01 and above. If you have an older version of RTG Timer, you must upgrade before you can use the correction program. Upgrades are discussed on the Support page.
You must save this program, fixtd.exe, in the same folder as the RTG Timer program. For a standalone computer, this is usually either C:\Program Files\Rtgbills if you first purchased Version 2, or C:\Rtgbills if you upgraded from Version 1. The program is very small, so you can copy it to a floppy disk and take it to another computer if RTG Timer is installed elsewhere.
Error opening database:it is because you didn't put the program in the folder that contains the RTG Timer database. Move the program to the same folder as the database (the file Rtgtimer.mdb) and try again.
Could not find file '[path] \RTGTIMER.MDB'.
This should solve the problem.