Access 97 Reports

[Guest]

I have lost the window "Sorting & Grouping" that can pop up in the Reports -
Design Mode. I select it from the menu but nothing hapens. The problem is
with all access files. I have tried a number. I am reluctant to re-install
the program as I get arround the problem by opening the access files using
another computer, setting the grouping properties as required etc.
Anybody with any suggestions?

 

[John Spencer]

Try the following in order.

ONE
Reset the resolution of your monitor to its highest setting and then see if
you can see the Sorting and Grouping dialog. If so, move it up and in to a
location where it can be seen at lower resolutions.

TWO
Turn on the sorting and grouping button (so it's depressed)

Then
1. Hit Alt+Space, followed by M then use the arrow keys (likely left and
up) until the window appears on screen.

or try
2. Hit Alt+Space, followed by MM then move your mouse ponter and click on
screen and the window will be visible
or try

3. Right-click on the taskbar and tile the open windows. That will bring
it back too, although this is messy if you have a lot of windows open. (and
this one probably doesn't work in most versions of Access if any)

THREE
There is a registry edit method, but hopefully one of the above should work.
Hack the registry (WARNING! DANGER!):

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\SGST
you find 5 values.
Change the values to 1;1;1;1;1;

 

[Guest]

Many thanks John, Options 1,2 or 3 did not work. I will try option 4 tomorrow
once I have backed files and registry.

 

[Guest]

John, the registry changes worked many thanks, James