Subform issue
in [Forms]
|
From: TT on 12 Jan 2006 17:20 Hi there... I've tried to set a filter on a sub form by clicking a calendar button on my main form. I even copied my old version so I knew I had the text correctly, but now, I seem to be getting an error as follows: Run-time error '-2146500594 (800f00e)': Method 'Form' of Object' _SubForm' Failed I've had this work in the past, but for some reason (which I can't figure out) it's giving me an error. The coding on the OnClick of the calendar control I'm using is as follows: Forms!frmMainMenu!frmReadings.Form.Filter = "Date=#" & Me.AcXCalendar.Value & "#" Any help would be wonderful. Thanks in advance!! -- TT
From: Ken Snell (MVP) on 12 Jan 2006 17:49 I assume that frmReadings is the name of the form that is the Source Object for the subform control. You must use the name of the subform control in place of frmReadings. The name of the subform control is found by opening the main form in design view, clicking on the top boundary of the subform control, opening the Properties window, and clicking on the Other tab to read the Name property. -- Ken Snell <MS ACCESS MVP> "TT" <TT(a)discussions.microsoft.com> wrote in message news:EF70AF8E-2283-4E23-AE5A-863D20577198(a)microsoft.com... > Hi there... > > I've tried to set a filter on a sub form by clicking a calendar button on > my > main form. I even copied my old version so I knew I had the text > correctly, > but now, I seem to be getting an error as follows: > > Run-time error '-2146500594 (800f00e)': > Method 'Form' of Object' _SubForm' Failed > > I've had this work in the past, but for some reason (which I can't figure > out) it's giving me an error. The coding on the OnClick of the calendar > control I'm using is as follows: > > Forms!frmMainMenu!frmReadings.Form.Filter = "Date=#" & > Me.AcXCalendar.Value > & "#" > > Any help would be wonderful. > > Thanks in advance!! > -- > TT
From: TT on 12 Jan 2006 18:01 I checked that out as well. It happens to be the same name. Do I need to change that? Sorry...I should have clarified before as well: frmMainMenu is my main form with the calendar control on it frmReadings is my subform which I am trying to apply the filter to. I tried to change the name of the subform but I still got the same error. Sorry to be a bother! -- TT "Ken Snell (MVP)" wrote: > I assume that frmReadings is the name of the form that is the Source Object > for the subform control. > > You must use the name of the subform control in place of frmReadings. The > name of the subform control is found by opening the main form in design > view, clicking on the top boundary of the subform control, opening the > Properties window, and clicking on the Other tab to read the Name property. > > -- > > Ken Snell > <MS ACCESS MVP> > > "TT" <TT(a)discussions.microsoft.com> wrote in message > news:EF70AF8E-2283-4E23-AE5A-863D20577198(a)microsoft.com... > > Hi there... > > > > I've tried to set a filter on a sub form by clicking a calendar button on > > my > > main form. I even copied my old version so I knew I had the text > > correctly, > > but now, I seem to be getting an error as follows: > > > > Run-time error '-2146500594 (800f00e)': > > Method 'Form' of Object' _SubForm' Failed > > > > I've had this work in the past, but for some reason (which I can't figure > > out) it's giving me an error. The coding on the OnClick of the calendar > > control I'm using is as follows: > > > > Forms!frmMainMenu!frmReadings.Form.Filter = "Date=#" & > > Me.AcXCalendar.Value > > & "#" > > > > Any help would be wonderful. > > > > Thanks in advance!! > > -- > > TT > > >
From: Ken Snell (MVP) on 13 Jan 2006 00:04 Does your code also set the ApplyFilter property to True after you set the Filter property? It's a two-step operation -- Filter sets the string to use as the Filter, ApplyFilter turns the filter on and off (True and False). -- Ken Snell <MS ACCESS MVP> "TT" <TT(a)discussions.microsoft.com> wrote in message news:ACB09A48-4453-465C-B4CB-A20BDF9E3EF5(a)microsoft.com... >I checked that out as well. It happens to be the same name. Do I need to > change that? > > Sorry...I should have clarified before as well: > frmMainMenu is my main form with the calendar control on it > frmReadings is my subform which I am trying to apply the filter to. > > I tried to change the name of the subform but I still got the same error. > > Sorry to be a bother! > -- > TT > > > "Ken Snell (MVP)" wrote: > >> I assume that frmReadings is the name of the form that is the Source >> Object >> for the subform control. >> >> You must use the name of the subform control in place of frmReadings. The >> name of the subform control is found by opening the main form in design >> view, clicking on the top boundary of the subform control, opening the >> Properties window, and clicking on the Other tab to read the Name >> property. >> >> -- >> >> Ken Snell >> <MS ACCESS MVP> >> >> "TT" <TT(a)discussions.microsoft.com> wrote in message >> news:EF70AF8E-2283-4E23-AE5A-863D20577198(a)microsoft.com... >> > Hi there... >> > >> > I've tried to set a filter on a sub form by clicking a calendar button >> > on >> > my >> > main form. I even copied my old version so I knew I had the text >> > correctly, >> > but now, I seem to be getting an error as follows: >> > >> > Run-time error '-2146500594 (800f00e)': >> > Method 'Form' of Object' _SubForm' Failed >> > >> > I've had this work in the past, but for some reason (which I can't >> > figure >> > out) it's giving me an error. The coding on the OnClick of the >> > calendar >> > control I'm using is as follows: >> > >> > Forms!frmMainMenu!frmReadings.Form.Filter = "Date=#" & >> > Me.AcXCalendar.Value >> > & "#" >> > >> > Any help would be wonderful. >> > >> > Thanks in advance!! >> > -- >> > TT >> >> >>
From: TT on 13 Jan 2006 09:44 Thanks for your on-going support Ken!! Yes, the second portion of my code turns the filter value using the same string: Forms!frmMainMenu!frmReadings.Form.FilterOn = True However, the code never gets to that point as it fails on the line before it. I'm sure it's something simple that I'm not doing correctly, I just can't figure out what it is!! Thanks again! -- TT "Ken Snell (MVP)" wrote: > Does your code also set the ApplyFilter property to True after you set the > Filter property? It's a two-step operation -- Filter sets the string to use > as the Filter, ApplyFilter turns the filter on and off (True and False). > > -- > > Ken Snell > <MS ACCESS MVP> > > > "TT" <TT(a)discussions.microsoft.com> wrote in message > news:ACB09A48-4453-465C-B4CB-A20BDF9E3EF5(a)microsoft.com... > >I checked that out as well. It happens to be the same name. Do I need to > > change that? > > > > Sorry...I should have clarified before as well: > > frmMainMenu is my main form with the calendar control on it > > frmReadings is my subform which I am trying to apply the filter to. > > > > I tried to change the name of the subform but I still got the same error. > > > > Sorry to be a bother! > > -- > > TT > > > > > > "Ken Snell (MVP)" wrote: > > > >> I assume that frmReadings is the name of the form that is the Source > >> Object > >> for the subform control. > >> > >> You must use the name of the subform control in place of frmReadings. The > >> name of the subform control is found by opening the main form in design > >> view, clicking on the top boundary of the subform control, opening the > >> Properties window, and clicking on the Other tab to read the Name > >> property. > >> > >> -- > >> > >> Ken Snell > >> <MS ACCESS MVP> > >> > >> "TT" <TT(a)discussions.microsoft.com> wrote in message > >> news:EF70AF8E-2283-4E23-AE5A-863D20577198(a)microsoft.com... > >> > Hi there... > >> > > >> > I've tried to set a filter on a sub form by clicking a calendar button > >> > on > >> > my > >> > main form. I even copied my old version so I knew I had the text > >> > correctly, > >> > but now, I seem to be getting an error as follows: > >> > > >> > Run-time error '-2146500594 (800f00e)': > >> > Method 'Form' of Object' _SubForm' Failed > >> > > >> > I've had this work in the past, but for some reason (which I can't > >> > figure > >> > out) it's giving me an error. The coding on the OnClick of the > >> > calendar > >> > control I'm using is as follows: > >> > > >> > Forms!frmMainMenu!frmReadings.Form.Filter = "Date=#" & > >> > Me.AcXCalendar.Value > >> > & "#" > >> > > >> > Any help would be wonderful. > >> > > >> > Thanks in advance!! > >> > -- > >> > TT > >> > >> > >> > > >
|
Next
|
Last
Pages: 1 2 Prev: Runtime error 3086:Could not delete specified tables Next: DoCmd GoToRecord |