Well it seems that part of my problem that is related to the title of this thread is very simple,,
I tried to change the Record Source of the Subform to the Query (and not the table as before), it worked fine and it responds directly to the Sort option of the query,,..
pyotr
Last Activity: Jan 7 '08, 11:09 AM
Joined: Dec 23 '07
Location:
-
Need Help With Sorting/Ordering Data in Subform (Order By isn't working)
Hello,,,,
I have a form with its subform that is filtered through the combination of two
independent comboboxes to facilitate administration.
However, I want to arrange/sort the viewed results according to one Field
which is the Start (date).
Also I need to find a way to restrict the shown data in the subform (Start , End )
according to two fields in the form... -
All I can Say is
THANK YOU FISHVAL
For Your Great Help,
And Honestly you were replying FASTER THAN I COULD IMAGINE,
So THANK YOU once again,
And I wonder If I would be greedy to ask some simple questions more.
Anyway I will post them in new thread, as they are not related to the title
of this thread.
Thank You FishValLeave a comment:
-
Ok,
I have a problem.
I have put the code exactly like you said.
and just after entering the two dates it gives me the following message.
Run-time error '3075'
Syntax error ( missing operator ) in query expression
detailed with the dates I have entered for Start and End and the IDLeave a comment:
-
Well, First I want to thank you FishVal for your help that I really appreciate.
My database structure for this part is:
Table: tblscheduling
Fields:
Department , Text
Employee_ID, Number
Last_Name, Text
Start, Date
End, Date
The Department Field is in Many - One relationship ( another table containing only a field called Departments.
...Leave a comment:
-
I've got an idea, that can turn to be good
I have made a query and added an expression in a new field to compare the proposed date. I have made to the Start Date so far.
Expr1: [Forms]![schedulingsub]![Start] Between [Start] And ([End]-1)
when I return to the normal view of the query it asks for the Start Date and when then I find the query compared all the intervals with the entered date and if it meets...Leave a comment:
-
There are some similarities between both problems, but there is main difference according to what I understood. In my problem:
I have form and its subform
The subform is filtered according to the Department Name that is in Form
and then in the subform you enter the name of the employee and enter his start and end date.
And SO I want only to validate the new dates entered to the previously...Leave a comment:
-
Need Urgent Help With Validation Rules ( Date Intervals Overlap)
Simply my problem is:
I need to validate the StartDate and EndDate when entered for an employee through subform. the purpose is to avoid entering a date that violate or overlap date intervalS that are previously assigned to a specific employee.
employees are assigned throughout the departments in advance.
So I need to avoid the overlap in intervals so that an employee is not assigned to two departments at the same time...
No activity results to display
Leave a comment: