sorting, grouping; unwanted files

[velma_b]

Good morning. I am using Access 97 and I have two problems. First, I have somehow managed to delete or misplace the sorting and grouping ability in form view. The shortcut is gone and “sorting and grouping” does not appear on the “view” section. “Formatting (Form & Report) is checked under “view”, “toolbars” and the “form design” box is checked in “toolbars”, “customize”. I have tried unchecking, rechecking, and resetting, but sorting & group is still not available.

Second problem is I was attempting to assign permissions for users and realized that I had no idea what I was doing, so I canceled my entries and exited. Now, however, I have a bunch of new “Tables”: “MSysACEs, MSysModules, MsysModules2, MsysObjects, MsysQueries, MsyRelationships. These files appear only on my computer, but are present in all seven of my databases.

I’m sure it’s evident I don’t know what I’m doing and would appreciate any assistance.

Thanks.

Sheila

 

[velma_b]

I resolved the second problem. I just need assistance with restoring the "sorting and grouping" function. Thanks.


Sheila

 

[revans]

I have somehow managed to delete or misplace the sorting and grouping ability in form view.

It's been a while since I've used 97 but I don't believe forms have a sortting and grouping setting. Reports do. Forms do not.

Forms have RecordSource, Filter, FilterOn, Order By, Order By On properties. Using these, sometimes in combination, you can get whatever sorting and grouping you're looking for. Without knowing what you're trying to do I don't think I can help much more than that.

hth,

Rich

 

[velma_b]

Thanks, Rich. I found what I needed in "Help" under toolbars and menu bars. I should have looked there first. I appreciate your response.


Sheila