Multiple Forms to sort differently one continuous subform and to remember the settings

[aonsu209]

Dear all,

I'm having a problem figuring how to do following example.
Each employee has individual hours form, and each hours form consist same subform. Now each of them wants different sorting or no sorting of the subform.

What I did so far is used simple command button of:
Me.OrderByOn = True
Me.OrderBy = "Projects for eaxample"
I try this once from the subform once from the form, but what i found out is that the subform keeps the last settings.
What I want is each employee to see the subform how he left it.


Is it possible each one to have his sorting settings without making for each one separate subform and how?

[June7]

The answer is basically no.

Sounds like this is not a split db. Multi-user db should be split.

Regardless, only way to accomplish what you want is to save the user preferences into a table and then apply them when they open form.

Why does each employee have their own hours form?

[ranman256]

They all should use the same 1 form for hrs, but each should only see their own hours.
They can sort it the way they like by clicking in the field then click sort.

[aonsu209]

They all should use the same 1 form for hrs, but each should only see their own hours.
They can sort it the way they like by clicking in the field then click sort.

Thank you guys. Yes it could been done easier, but my manager wants like that, that each employee has a shortcut of his hours and with more privacy.

[June7]

How is it accomplishing 'more privacy' - all data in tables is available to all users. If they want to see other employee info, what's to stop them? All having multiple forms really does is complicate db maintenance.

[aonsu209]

All the users use the runtime viewer and they can see only the form that they use. It is small company of 70 people , to created the first time take a bit longer. So far everything work fine so there are not so much maintenance required.

PS: Im structural engineer not IT

[June7]

There are 70 identical forms!!? Yuck! So every time there is a new hire, have to modify db? One form could be filtered to show only the user's records.

[aonsu209]

Yes for each new employee there is procedure that all the "IT" can create a new form. I know that can be filtered, but there are no user accounts in the database furthermore my manager wanted everyone to has own shortcut on his desktop. Anyway, thank you for the help.

[June7]

Why couldn't user still have shortcut if the db has only one form instead of 70 forms? Why not have a Users table and manage one form? If there is no Users table, how does the db know which form to present to the user - each db copy is set with user's form as default when db opens? And the nightmare gets worse! Oh well, if it works ...

[aonsu209]

Because that's the wishes, and the people should do as less as possible. How you can see the picture below the initials and standard rate are setup by employee ID so for each one is individual form. Previously we had excel sheet and was same system for each one separate excel in the end we combined them with Matlab. And the table that you can see below is the one that I want each user to sort by his claims.

[June7]

None of that prevents developing a single form to serve all users. But my face is turning blue so I accept that you are committed to this schema and wish you the best.