APPENDIX A:
TROUBLESHOOTING
Scanner not found on Scan/Edit screen
1. Return to main menu
2. Click Setup
3. Change the COM port setting and retry
4. If you have the Palmpilot HotSync software running on this computer, shut it down
Compile Error, can’t find project or library, indicates that you do not have Outlook 98 loaded on your PC. Outlook 98 is required to operate all e-mail functions. However, there is a work around if Outlook 98 is not available to you. Follow these steps. (A setup for no Outlook is now available.)
1. Open SDSI2000mdb.
2. CLICK OK on compile error.
Note: At this time you should be at the Main Menu. If not, CLICK the square End icon to return you to the Main Menu.
3. CLICK Window/SDSI2000Database.
4. CLICK Reports.
5. Highlight any report.
6. CLICK Design.
7. CLICK View/Design View
8. CLICK View/Code
9. CLICK Tools/References
10. Uncheck Microsoft Common Dialog Control …
11. CLICK OK/Tools/References/Browse.
12. Go to C/Windows/System.
13. Go to Files of type. Find and highlight Active X Controls.
14. CLICK Comdlg32.ocx/OK.
15. Scroll to: Missing Outlook 98/Uncheck box/OK.
16. CLICK top right x to exit completely out of the system.
17. Reopen SDSI2000 program.
If you find a Microsoft Common Dialog Error, Right 000000000 (SSN) follow these steps to manually register the Comdlg32.ocx.
1. Open SDSI2000mdb
2. CLICK View/Design View
3. CLICK View/Code
4. CLICK Tools/References
5. Uncheck Microsoft Common Dialog Control …
6. CLICK OK/Tools/References/Browse.
7. Go to C/Windows/System.
8. Go to Files of type. Find and highlight Active X Controls.
9. CLICK Comdlg32.ocx/OK.
10. CLICK top right x to exit completely out of the system.
11. Reopen SDSI2000 program.
Run Time Error, F-… is flagged by something outside the data columns in the spreadsheet. Follow these steps.
1. CLICK and hold inside the top of the first empty column.
2. Drag completely to the right, highlighting all empty columns.
3. CLICK Edit/Delete.
4. Close file.
Run Time Error, Bound or Unbound Object Frame Doesn’t Contain OLE. This error message tells you no card numbers have been assigned. Every record must have a card number assigned before they can be transferred into the database.
Run – Time error ‘3170’
Couldn’t find installable ISAM.
You must manually register the correct dll. This can be done by running
Start: Run: C: \Windows\System\Regsvr32.exe (space)
C: \Windows\System\MSExcl35.dll
If you are currently in Access mdb, you must exit and re-enter
to have the changes take effect.
If you find this message when exporting a file to .txt.
You must manually register the correct dll. This can be done by running
Start: Run: C: \Windows\System\Regsvr32.exe
C: \Windows\System\Mstext35.dll
Import Error, Numeric Field Overflow tells you that there is something in the Excel spread sheet the program does not recognize. Refer to the Data Input Fields list for field descriptions. The following are things to look for:
A. Blank spaces between numbers. Example: 123 7890
B. Letters placed in numeric fields. Example: abc1234567
Note: Empty fields will not cause errors. Sometimes you can not see what is causing the error.
C. If a number in the spreadsheet was created from a formula, the system might be reading the formula. Follow these steps.
1. CLICK inside the top left corner to highlight the entire Spreadsheet.
2. CLICK Edit/Copy.
3. CLICK Edit/Paste Special.
4. CLICK Values/OK.
Tip: To determine which numeric column is causing the error, Import data after deleting one of the columns. Repeat until you successfully import. Remember you must delete test imports in the temporary file before final import.
D. If you can’t see what is causing the error in the isolated column, you must Trim the column. Follow these steps.
1. Highlight the column to be trimmed.
2. CLICK Insert/Columns.
3. CLICK Format/Cells/General/OK.
4. Highlight 1st cell under field names in new column.
5. CLICK inside Formula Bar.
6. Type =Trim(insert step 7)
7. CLICK to the right of the highlighted cell. This will add the cell # to formula.
8. Highlight original column Edit/Copy.
9. Highlight new column Edit/Paste Special/Values/OK.
10. Highlight original column
11. CLICK Edit/Delete. Continue on next page.
12. CLICK inside the top left corner to highlight the entire Spreadsheet.
13. CLICK Format/Cells/Text/OK.
14. CLICK File/Save As… rename your spreadsheet.