[AccessD] Strange Filter By Form Problem.

Yeah, Access has so many ways to do a thing, when I have a problem that
takes more than a couple minutes to solve I often bail right out to an
alternate - saves time, saves hair, saves TUMs.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Monday, May 07, 2012 9:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Strange Filter By Form Problem.

I've done it via a button click that displays the current filter:

It looks OK to me ... something like:
((Lookup_CustID.Company="CompanyNameHere") AND
(Lookup_FacID.FacName="FacNameHere"))


I inherited this from another developer ... thinking that I will simply code
the filters manually ... they certainly work fine that way.

On Mon, May 7, 2012 at 11:41 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> "Could this be an issue?"
>
> Probably not - we share the same transgression - naming the control 
> the same as the control source - I do that because sometimes you need 
> to refer to the control source and sometimes the name.  I have been 
> advised to make them different.  I've ignored the advice at my peril.
>
> It was a shot in the dark.
>
> I don't use FBF - prefer to set the filter property through code.  Is 
> there someway to display the FBF filter so you can actually see how 
> it's filtering?
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence 
> Mrazek
> Sent: Monday, May 07, 2012 9:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Strange Filter By Form Problem.
>
> Hi Rocky:
>
> No, they are simply bound comboboxes ... they display the text from 
> the related table, but the ID from the related table is bound. Hmmm 
> ... but the name of the controlsource is the same as the field (EX: 
> field=facid, combobox name= facid).
>
> Could this be an issue?
>
> Thanks!
>
> On Mon, May 7, 2012 at 11:16 AM, Rocky Smolin <rockysmolin at bchacc.com
> >wrote:
>
> > Is FacID in a bound text box on the form? If so, is the name as well 
> > as the controlsource of the text box FacID?
> >
> > Rocky
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence 
> > Mrazek
> > Sent: Monday, May 07, 2012 9:01 AM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Strange Filter By Form Problem.
> >
> > Hi Folks:
> >
> > We have a couple of users that like to use the built-in filter by 
> > form functionality in Access 2007.
> >
> > We have a form that has a 3 combo boxes on it, plus a number of 
> > textboxes and a subform.
> >
> > If the user does a filter-by-form and chooses only one of the 
> > comboboxes, the filter works fine. However, if you try to filter 
> > multiple combo boxes, the system throws an error message saying the 
> > "The Microsoft Office Access database engine does not recognize 
> > "FacID" as a valid field name or expression". (FacID) is on the main
> form's recordsource.
> >
> > Has anyone seen this sort of behavior?
> >
> > Thanks in advance.
> >
> > Larry Mrazek
> > lmrazek at lmrazek@lcm-res.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com