AgShow
Help
Trouble Shooting

Problem:

AgShow does not work under my 64-bit version of Access.

Reason:

AgShow does not run under 64-bit versions of Access.

Solution:

Install a 32-bit version of the Access Runtime then reinstall AgShow and select that version in the setup program.
Ensure that you install a different version (year) to that of your 64-bit version.
Access Runtime versions can be downloaded from the links on the Access Runtime Downloads page at www.softshow.com.au
Having 2 different versions of Access on your computer may generate the problem immediately below.


Problem:

One of the following message may be displayed each time you start AgShow:
"Windows Installer", and/or
“Setup is configuring Access”, or
"Please wait while windows configures Microsoft Office Professional yyyy" (or similar message).

Reason:

There are 2 different versions of Access (or Office) installed on your computer and Microsoft have confirmed that can lead to this problem. (As it has done for years!)

Solution:

Microsoft have provided a solution that requires modification to the registry, so it certainly is not a simple fix.
Go to https://support.microsoft.com/en-us/help/2184729 and follow Microsoft's instructions.
Good luck! If the above does not work then google the error message and you will see that you are not the only one experiencing this problem. Maybe one of the suggested solutions will work for you.


Problem:

Using the Page Setup button on the Print Preview Toolbar, I change the margins of a report but AgShow does not remember the changes for next time.

Reason:

You exited Print Preview using the Close button on the Print Preview Toolbar. By design, this button is a quick exit and does not save changes.

Solution:

Exit Print Preview using the File->Close option in the top Menu Bar. This will save any Page Setup changes.


Problem:

Entered names and other details disappear. Normally sorted lists are no longer correctly sorted and some records appear to be missing.
This may occur immediately after an abnormal termination to AgShow, such as the power to the computer being interrupted whilst AgShow is running.

Reason:

Don’t worry – well not just yet. AgShow uses Microsoft Access as a base which immediately saves any data as it is entered, but does not save indexes until AgShow is normally exited. (Indexes are similar to the index at the back of a book that Access uses to locate data and are used internally by Access.) So when there is an abnormal termination the indexes are not saved at all, so now the data on disk is current but the indexes are old and do not match the data. This is most noticeable if the problem arises after you have spent time entering a lot of data in one session and the session is terminated abnormally.

Solution:

Fortunately there is a simple solution. The indexes can always be rebuilt from the data and this is accomplished via the Repair and Compact Data File option in the AgShow Utilities program. So:
(i) Close AgShow.
(ii) Load AgShow Utilities.
(iii) Select Repair and Compact Data File
(iv) Select your show data file from the Open File window
(v) Close AgShow Utilities and run the AgShow program again.
     Hopefully, your problem is solved.


Problem:

After deleting all entries, say for the start of a new year, the automatically assigned entry number still follows on from the previous entry numbers instead of being reset back to number 1.

Reason:

The entry number is a counter value, so it is automatically assigned as the next number by AgShow each time a new entry is entered. Deleting data does not reset counter values.

Solution:

To reset counter values you need to Repair and Compact the data file. This can be performed from within the AgShow Utilities program. It is most important to Repair and Compact a data file after mass deletions, such as deleting all entries, BEFORE any new data is entered. For example, for a show data file with 2345 entries as the entry number is a counter value, so the next entry number will be automatically assigned 2346, which cannot be over-written. Now if all entries are deleted, say for the start of a new year, the counter value is not automatically reset on deletion. So even though there are no longer any entries in the data file the next entry number will still be 2346. Repair and Compacting the data file BEFORE adding any new entries will reset the counter value, in this case to zero, so the next entry number will be number 1.
Note that AgShow automatically performs a Repair and Compact immediately after the Roll Over Files for a New Year is performed, so resetting entry numbers etc. for the new year's file.


Problem:

Error returned when Print Preview or Printing

Reason:

Maybe, you do not have a printer installed.
NOTE: You must have a default printer other than the Generic Printers: "FILE: Print to File" or "Generic / Text Only" in order to properly preview formatted reports.

Solution:

Install a printer and select it as the Default Printer.


Problem:

Every second page of a report is blank

Reason:

Different printers give slightly different results, particularly in font sizes. Although the reports print onto each page properly on SoftShow’s printer, the font size may be slightly larger on your printer so each line extends slightly past the right margin. This small bit of overhang is printed on the next page which appears blank.

Solution:

Make the left and right margins of the report smaller. To do this, view the report in Print Preview mode and select the Page Setup (or Print Setup) icon or menu option. The margin settings are located along the bottom of the window and can be easily altered. Some trial and error may be required to find the best value.


Problem:

When printing labels the bottom line(s) on the bottom labels on each page are cut off.

Reason:

Even though you may have the bottom margin set to 0.00 cm, that is no margin at all, some printers simply will not print right down to the bottom of the page.

Solution:

In the Printing Preferences select "Borderless Printing".
Otherwise, view your labels in Print Preview and select the Page Setup (or Print Setup) selected from the toolbar or File menu. Change the bottom margin to a little bit less than the height of the label. That is to 2 cm for 2.54 cm labels, or to 3 cm for 3.7 cm labels. Now, having to allow for that margin, AgShow will realise the bottom label will not fit on the newly sized page, so it will be printed on the top of the next page. Unfortunately, this means the bottom labels on every page are wasted, but that is probably cheaper than buying a new printer that will print to the very bottom of a page.


Problem:

AgShow seems to take longer to load and is slower whilst working.

Reason:

The data files are large and get larger as you enter more data. AgShow uses Microsoft Access as the database. When data is deleted Access does not free up the space the deleted data used. A file full of such wasted space also causes AgShow to slow down.

Solution:

Data files can be Compacted thus freeing up wasted disk space and reorganising the data for faster access via the Repair and Compact Data File option in the AgShow Utilities program. So:
(i) Close AgShow.
(ii) Load AgShow Utilities.
(iii) Select Repair and Compact Data File
(iv) Select your show datafile from the Open File window
(v) Close AgShow Utilities and run the AgShow program again.

Solution 2: Buy a new faster computer:-). It does make a difference!


Problem:

In Windows Vista, after installing AgShow it starts, tries to connect to the Word Object Library, then complains of a permissions problem trying to write to a file.

Reason:

The installation was perfomed under "Administrator" privileges. Now that you are just an ordinary user you do not have write permission to the C:\Agshow folder created in installation. Ignore the warning that AgShow cannot load the Word Object Library. If you have Microsoft Word installed the Word Mail Merge connection will probably work just fine.

Solution:

1. Open My Computer (or Windows Explorer )
2. click the Folders icon in the top toolbar
3. click the "+" against My Computer in the left folders tree to open it up
4. click the "+" against C: drive to open it up
5. right-mouse click on the Agshow folder just underneath the C: and select Properties
6. click on the Security tab
7. select your logged in User Account Name(or “Everyone” will really do the trick!)
8. ensure the “Allow” box in "Full Control" is ticked


Problem:

In the schedule I have entered many pages of text within the Notes but only 2 pages print.

Reason:

Notes fields do have a limit in Microsoft Access, which is 22 inches, or 55.87 cm, equivalent to about two A4 pages. This comes into effect when in Print Preview or printing directly from AgShow.

Solution:

If you print the Schedule or Entry Catalogue directly to Word using AgShow's 'W' button then that limitation is avoided, so the notes can be as long as you want.