Wierdest thing! 1

[jimmythegeek]

I have never had this happen before, and maybe one of you fine folks have, and found out what to do.

The grouping and sorting window in design view of my reports, is gone. When I click on the button, it stays down as if the window should be showing, but it is nowhere to be found.

Let's see, I have minimized, restored, closed and reopened report, moved all the toolbars and menu bars to see if it was hiding behind something, closed and reopened Access, and re-booted my computer. None of which helped. It is the same thing no matter what report I have open, and no matter which database I have opened.

Any comments, questions, suggestions, answers, tongue lashings for oversights, or a gentle response to why this would happen. I need that Sorting and Grouping window very badly.

Thanks in advance. Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[ghubbell]

Wow! More gremlins in the gears! Never seen that before but I'd guess it's time for a reinstall/repair of Access. I'd bet the stall is while it's trying to find something it can't...Virus scan too? Ah, never mind. Most virus tools can't catch the Access gremlins... ;-) Gord
ghubbell@total.net

 

[MichaelRed]

Try "Arrange Icons".

"Doufus" Bill set it out to 'never-never' land with Dorthy, but that is really just somewhere w/ a negative position. Arranging icons (or sometimes tiling windows) brings these gremlins back!


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[RickSpr]

Hey Jim, I don't think Arrange Icons (or Tile or Cascade) will work in this case, because this is a popup window, not an MDI child window.

If you haven't already gotten it back, hack the registry. For Access 97, it's:
HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings\SGST
For Access 2000, change "8.0" to "9.0"
Close Access, then just delete this registry key; the next time you open the Sorting and Grouping box, it will be in the default position.

If you prefer, you can just change it to: 0;150;140;580;370

The first number is 0 if you left the dialog closed, 1 if open. The other 4 numbers are the left, top, right, and bottom twip coordinates of the dialog window. Rick Sprague

 

[jimmythegeek]

Thanks Rick, the registry trick did it.

This is the value that was in the SGST setting:
1;-1074314854;105668;105668;0;

Nice tip, YOU DA MAN! Jim Lunde
compugeeks@hotmail.com
Custom Application Development