In Acc ; Activeview in Report = Activeview in Form |
Post Reply |
Author | |
LeJi
Newbie Joined: 02 May 2008 Status: Offline Points: 1 |
Post Options
Thanks(0)
Posted: 02 May 2008 at 4:53pm |
Dear,
In Access, Is it possible to have on an Report exactly the same activeview that on a form,
I tested the code below, but if I select 3 days in the form I do not find them in the Report ?
Can you help me
In advance Merci
Jacky
Private Sub Report_Open(Cancel As Integer)
Dim ObjCalendarFrms As CalendarControl Dim ObjCalendar As CalendarControl Set ObjCalendarFrms = Forms!PlanningCalendar!CalendarControl1.Object Set ObjCalendar = Me.wndCalendar.Object Call PlanningPopulate(ObjCalendar) ObjCalendar.VisualTheme = xtpCalendarThemeOffice2007 ObjCalendar.ViewType = ObjCalendarFrms.ViewType ObjCalendar.DayView.TimeScale = ObjCalendarFrms.DayView.TimeScale ObjCalendar.PrintOptions.PrintFromToExactly = False ObjCalendar.ActiveView.ShowDay ObjCalendarFrms.ActiveView.Days(0).Date, ObjCalendarFrms.ActiveView.Days(ObjCalendarFrms.ActiveView.DaysCount - 1).Date 'Me.wndCalendar.Object.PrintOptions.PrintDateHeader = False End Sub |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |