Click Setup on the Main menu to see the Setup form. Enter your company contact info and ImportFolder. Click on a blue link to open that location. Hover over the link to see what it does. Website browses to your website.

To view any raw table in the system, select it in the Table combo and click View or to export it to CSV, DBF (dBase, FoxPro, Clipper), HTM (for web browsers), MDB (Access), RTF (Word or WordPad), SNP (free Access reader from Microsoft), TXT or XLS (Excel) formats.

While viewing a table, you can drag the column headers into the order you want, highlight several columns together and right click, sort A-Z or Z-A. When you are done viewing, answer NO when asked if you want to save the table layout.

Click TblDoc to create a data dictionary defining all fields in the database application. This HTML file is opened in the user's browser. The description property shown in TblDoc appears as StatusBar text on forms.

The User form lets the Super user add or edit users. Normal users are limited in the data they can edit on themselves, but they can change their password here. After confirming the password, be sure to click Email or UserName instead of pressing the Enter or Tab keys. This allows the encrypted passwords in the MDW file on your c: drive to be copied to the server so you can log in anywhere.

Click Link to change where the data tables are located. If you see the box asking where the data tables are upon opening the database, you may have a network error and should call for support to avoid storing your work in the wrong location.

Backup quickly saves a copy of the data tables to another location such as a flash drive.

Quit lets administrators force all users out of the database within three minutes. Enter a message telling the users when they can log back into the system and click Start. This Quit feature is handy if you need to make programmed table structure changes using Alt-Z at the Main menu.

Within a minute, all users will see all the forms turn red and receive your message. Normal users are forced out of the system a minute later and can't log in until you cancel the quit.

To cancel the quit, the Super user logs onto the database and clicks Cancel.

Compact rebuilds the indexes, repairs and reduces the size of the tables database. This requires exclusive access to the database, so it is best done after work. You can use the Quit function if people are widely distributed. If you change lots of data, you will notice improved performance if you compact weekly.

The Combo form lets you edit tables in your system that only have one or two fields without having to pay to have forms created for each table. Choose the combo you want to edit in the colored area at the top of the form or use the right or left arrow keys to skip through the combos.

Click the blue link Code, Descrip or Sort to sort on that column. It is easy to use comments for special purposes such as help or groups in the Combo form.

The Data Integrity form helps you keep your data complete and accurate without slowing data entry because the data wasn't currently available. In this example, we have a select query qEquipNotInWO that shows equipment not used in a work order and is therefore probably not necessary in the system. It is easy to create dozens of these queries in an hour, so any time you encounter a data entry problem, we can create a DI query to avoid it in the future.

The Note normally contains a line telling exactly how to fix the problem. Click Calc1 to count the records found by this query or Calc to count records found for each data integrity query.

Click the blue SQL link to see the actual SQL of the query.

Click View to see the records found in a read-only format.

Click Sel to Select the records found in the Contact table and open the Contact form with only the problem records selected.

Click Export to export the records found to Excel, CSV, Text, etc.

If it is possible to fix a problem using an SQL Update query, we can create a query qFix query. A Fix button is then visible and the user simply clicks Fix and confirms that they want to run the query to fix the problem.

If all queries show 0 records, there are no problems with your data.

Click Equip to set up equipment to be maintained. Use to Find to find a string in: |EquipNo|Descrip|Location|SubLoc|ModelNo|SerialNo|Notes|SEL|. Use the vertical bars to specify the start or end of a field or to match the contents of a field exactly. Find for |SEL| to find records where Sel is checked. Click the blue link (Equip No, Description, Location, Model No, Sel) to sort on that column. Click the column header again to sort in descending order.

Click Location to edit the Locations where maintenance is to be performed. Use Find to find a string in: |Location|SubLoc1|SubLoc2|SEL|. The vertical bars let you specify the start or end of a field or to match the contents of a field exactly. Find for |SEL| to find records where Sel is checked.

Note: SubLoc1 is required. Use - if there is no sublocation.

Click Task to describe the tasks to be done. Use to Find to find a string in: |EquipNo|Descrip|Location|SubLoc|ModelNo|SerialNo|Notes|SEL|. Use the vertical bars to specify the start or end of a field or to match the contents of a field exactly. Find for |SEL| to find records where Sel is checked. Click the blue link (Task No, Description, Sel) to sort on that column. Click the column header again to sort in descending order.

Give tasks unique numbers. This building uses -Y to show yearly tasks, -M to show monthly, -S for semiannual tasks, -Q for quarterly and -W for weekly. Select the Work Order Type, Craft and Schedule Method. Put specific instructions that will be printed on the work order into the Instructions field.

Close