User Support Forum

I verified that I am getting the screen preview field overflow on 2 different Dell computers running totally different hardware (graphics, monitors, cpus, etc.). Fonts are set to "normal" size through properties for desktop display. I also went back to version 8.5 that is still installed on the comp...

I print a Payroll Item Summary Report each month to use in preparing my 941 tax withholding deposit and quarterly reports. I noticed that after I upgraded to v9 with MR 11-2-04 that on the screen report, the "Employee Number" field is showing "####" for one of the employees that has a 4 digit employ...

Jeff, The duplicate acct number in the faaccts.dbf file was the problem causing the re-indexing error ... After I removed the single duplicate record from the faaccts.dbf file I was able to run re-indexing without any errors. Thanks again for your assistance. Maybe this will be a help to someone els...

Okay, I will work on this tonight.

This SQL query returned 1 account number as a duplicate. I opened the faaccts.dbf file with the index order set to "faaccts" and did a seek for the acct number value returned from the SQL query and did verify that the acct number value has 2 entries in the faaccts.dbf file. Now, will I need to do an...

I was able to identify that the faaccts.dbf / .cdx file is causing the problem somehow ... I took the test subdirectory with the freshly installed and empty data files that would reindex correctly and started copying groups of files from the other test subdirectory that has copies of current "live" ...

I repeated the test again using the rtrim() function rather than the trim() function but still got 0 (Zero) records returned from the SQL Query. I also checked for blank data values by doing a "count for empty(acct)" and "count for empty(majoracct)" after opening each respective file with a "use" st...

I am comfortable working with the SQL Select statments. I tried the 2 statements you suggested prior to my last post ... but I used the trim() function rather than the rtrim() function ... I will try it again with the rtrim() function. The SQL Select statement returned 0 (Zero) records for each test...

Will be waiting on your instructions for which data files you want zipped up for examination.

Thanks,
James E. Jernigan

Please let me know which data file copies you need and I will zip them up for you and email to you. I will try a visual search of copies of the faaccts.dbf and the new famajor.dbf files and look for problems in the data value length using FoxPro len() function to check for missing "0" characters in ...

I have done some additional testing with these results: I installed a fresh copy of v9 into a test subdirectory and chose the option NOT to upgrade a previous version. I verified that reindexing worked correctly. I then installed the MR dated 11-02-04 into this new version that did not have any data...

I am running the workstation with full administrator rights under WinXP Pro SP2 and I am running the Power Church sofware with all rights active for my user account. To recap procedure done to troubleshoot this issue: I installed new version 9 software and updated existing Power Church v8.5 files. I...

After I download and install the new Maintenance Release (dated 11-2-04) for version 9, I get an error when I try to reindex the Accounting Module files. The error indicates that a file is not accessible, possibly because of another user, but the Power Church software is installed on a single standa...