ACCESS FEED: Re: [MS_AccessPros] query criteria from open form

Selasa, 23 April 2013

Re: [MS_AccessPros] query criteria from open form

John,

I feel as if I'm going around in circles by doing all the wrong things
and misinterpreting your advice. Let me give it a go more carefully.

Russ

--- In MS_Access_Professionals@yahoogroups.com, John Viescas wrote:
>
> Russ-
>
>
>
> If RoleID is the Bound Column in the combo box, then all you need is:
>
>
>
> WHERE tblRoleList.RoleID = [Forms]![frmRoleList]![Combo4]
>
>
>
> Adding a fourth part to the parameter in this case is not valid!
>
>
>
> John Viescas, Author
>
> Microsoft Access 2010 Inside Out
>
> Microsoft Access 2007 Inside Out
>
> Microsoft Access 2003 Inside Out
>
> Building Microsoft Access Applications
>
> SQL Queries for Mere Mortals
>
> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
ghsclass65
> Sent: Tuesday, April 23, 2013 6:16 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] query criteria from open form
>
>
>
>
>
> John,
>
> Yes John I realized that and changed it to RoleID. Also the ComboBox
name
> was changed, so my SQL now looks like this:
>
> SELECT tblRoleList.RoleID, Names.LastName, Names.FirstName,
> tblAssignedRoles.[Yes-No], Names.Active
> FROM tblRoleList INNER JOIN ([Names] INNER JOIN tblAssignedRoles ON
> Names.NameID = tblAssignedRoles.AssNameID) ON tblRoleList.RoleID =
> tblAssignedRoles.AssRoleID
> WHERE
(((tblRoleList.RoleID)=[Forms]![frmRoleList]![Combo4]![RoleID]));
>
> However, I still get a zero result from the query after making those
> corrections.
>
> --- In MS_Access_Professionals@yahoogroups.com
> , John Viescas
> JohnV@ wrote:
> >
> > Russ-
> >
> >
> >
> > RoleName in your parameter makes no sense.
> > [Forms]![frmRoleList]![RolesCmbo] references the current value of
the
> combo
> > box Bound Column. If that's RoleID, then that's all you need to use.
> >
> >
> >
> > John Viescas, Author
> >
> > Microsoft Access 2010 Inside Out
> >
> > Microsoft Access 2007 Inside Out
> >
> > Microsoft Access 2003 Inside Out
> >
> > Building Microsoft Access Applications
> >
> > SQL Queries for Mere Mortals
> >
> > http://www.viescas.com/
> >
> > (Paris, France)
> >
> >
> >
> >
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> ] On Behalf Of ghsclass65
> > Sent: Tuesday, April 23, 2013 5:28 PM
> > To: MS_Access_Professionals@yahoogroups.com
>
> > Subject: Re: [MS_AccessPros] query criteria from open form
> >
> >
> >
> >
> >
> > John,
> >
> > SELECT tblRoleList.RoleID, Names.LastName, Names.FirstName,
Names.Active,
> > tblAssignedRoles.[Yes-No]
> > FROM tblRoleList INNER JOIN ([Names] INNER JOIN tblAssignedRoles ON
> > Names.NameID = tblAssignedRoles.AssNameID) ON tblRoleList.RoleID =
> > tblAssignedRoles.AssRoleID
> > WHERE
(((tblRoleList.RoleID)=[Forms]![frmRoleList]![RolesCmbo]![RoleName])
> > AND ((Names.Active)=Yes) AND ((tblAssignedRoles.[Yes-No])=Yes));
> >
> > Russ
> >
> > --- In MS_Access_Professionals@yahoogroups.com
>
> > , John Viescas
> > wrote:
> > >
> > > What is the SQL of your query?
> > >
> > >
> > >
> > > John Viescas, Author
> > >
> > > Microsoft Access 2010 Inside Out
> > >
> > > Microsoft Access 2007 Inside Out
> > >
> > > Microsoft Access 2003 Inside Out
> > >
> > > Building Microsoft Access Applications
> > >
> > > SQL Queries for Mere Mortals
> > >
> > > http://www.viescas.com/
> > >
> > > (Paris, France)
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
>
> >
> > > [mailto:MS_Access_Professionals@yahoogroups.com
>
> > ] On Behalf Of
> ghsclass65
> > > Sent: Tuesday, April 23, 2013 4:58 PM
> > > To: MS_Access_Professionals@yahoogroups.com
>
> >
> > > Subject: [MS_AccessPros] query criteria from open form
> > >
> > >
> > >
> > >
> > >
> > > I'm trying to set up a query that will get it's criteria from an
open
> > form.
> > > I've set the query's criteria to the form's combo box and it's
record
> ID,
> > > but when I run the query I get a dialog box "Enter Parameter
Value". I
> > > thought the query would use the value from the record that was
chosen in
> > the
> > > form. No?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>