Hi .. i got problem with my access.I want to do search and display search report. I want to use the the search button base on the CATAGORIES and DATE.
I got one form, on this form I got
1)2 group option buttons:
a) Private(optctlg for private subform)
b) Public(optcust- public subform)
if te employee click one this option button , the other form is invisible ( and this already work)
2)got 2 text Boxes for Date (Datefrom and DateTo) this text boxes is for the employee enter the date event they want to search.
3)5 command buttons :- 'search button' forsearch event according to the date.( the two text boxes)
- 'view button' for View all the date in the event from one of the subform (all the date display under its type events)
- 'today button' for View only for TODAY events.
- 'report button' for display the report.
- 'Print button' the report
The problem is, all this what i want to do is dose't work! When the employee want to search the events, they must click one of the option button type of event either PRIVATE EVENT or PUBLIC EVENT.
So assume that they choose PRIVATE EVENT on the option button , and the subform for PRIVATE evernt visible.After they choose the event type from the option button, so the second step they must enter the date of PRIVATE event they want to search, and enter the event into the 2 text boxes.
If the employee want to search all the dates in Private event type, they must click the View button, and in the Private subform will display all the dates.
if the employee click the today button, the Private subform event will display only for today event.
and how to display one report according to the type that they search?
i have try this since last to month, and until today i still cant get what i want.and now i only have 8 days to make all this system work.Anyone please ....!!!How will i going to do this process?
I got one form, on this form I got
1)2 group option buttons:
a) Private(optctlg for private subform)
b) Public(optcust- public subform)
if te employee click one this option button , the other form is invisible ( and this already work)
2)got 2 text Boxes for Date (Datefrom and DateTo) this text boxes is for the employee enter the date event they want to search.
3)5 command buttons :- 'search button' forsearch event according to the date.( the two text boxes)
- 'view button' for View all the date in the event from one of the subform (all the date display under its type events)
- 'today button' for View only for TODAY events.
- 'report button' for display the report.
- 'Print button' the report
The problem is, all this what i want to do is dose't work! When the employee want to search the events, they must click one of the option button type of event either PRIVATE EVENT or PUBLIC EVENT.
So assume that they choose PRIVATE EVENT on the option button , and the subform for PRIVATE evernt visible.After they choose the event type from the option button, so the second step they must enter the date of PRIVATE event they want to search, and enter the event into the 2 text boxes.
If the employee want to search all the dates in Private event type, they must click the View button, and in the Private subform will display all the dates.
if the employee click the today button, the Private subform event will display only for today event.
and how to display one report according to the type that they search?
i have try this since last to month, and until today i still cant get what i want.and now i only have 8 days to make all this system work.Anyone please ....!!!How will i going to do this process?
