ACCESS FEED: RE: [MS_AccessPros] combo box Access bug?

Rabu, 10 Juli 2013

RE: [MS_AccessPros] combo box Access bug?

Good idea Bill.

Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, July 10, 2013 10:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] combo box Access bug?

Liz

No need to back out. Just use the columns that you need and add one more column with the concatenated fields.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> I did not know that. I just figured that the combo box was a collection of sorts that maintained an index behind the scenes with which to determine the bound value.
>
> To combine would also mean I would have to separate back out since I use the 2 columns for 2 different arguments.
>
> But thanks Duane.
>
> Respectfully,
> Liz Ravenwood
> Programmer / Analyst
> B/E Aerospace | Super First Class Environments
>
> 1851 S Pantano Road | Tucson, Arizona 85710 Office +1.520.239.4808 |
> beaerospace.com Passion to Innovate. Power to Deliver
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
> Sent: Wednesday, July 10, 2013 10:22 AM
> To: Access Professionals Yahoo Group
> Subject: RE: [MS_AccessPros] combo box Access bug?
>
> I'm not sure I understand but if your combo box is bound to the first column, every one of the values in the first column should be unique. If not, you will not get consistent results. You have multiple items in the combo that would have the same value.
>
> I would minimally combine the two columns into a single expression (column width of 0) and use this unique combination as the bound column.
>
> Duane Hookom MVP
> MS Access
>
>
> ----------------------------------------
> > From: liz_ravenwood@...
> >
> > Pros, I think I found an Access bug but I still need to work around it.
> >
> > I have a combo box with this query at the data:
> >
> > SELECT ReportCode as Selection, "Program" as Selected FROM
> > ProgCodesActive UNION SELECT AffectedArea as Selection, "Area" as
> > Selected FROM AffectedAreasAndEmailsNogales;
> >
> > And yields results like this:
> >
> > Selection
> > Selected
> >
> > Asiana
> > Area
> >
> > Asiana
> > Program
> >
> > BA
> > Area
> >
> > BA
> > Program
> >
> > Emirates
> > Area
> >
> > Emirates
> > Program
> >
> > Etihad
> > Area
> >
> > Etihad
> > Program
> >
> > Etihad A380
> > Program
> >
> > Etihad B787
> > Program
> >
> > Garuda
> > Area
> >
> > Garuda
> > Program
> >
> > JAL
> > Area
> >
> > Japan B777
> > Program
> >
> > However, I can IMMEDIATELY check what was selected and if I select the Emirates/Program, I can see that it is reset to Emirates/Area. My subsequent code doesn't work by calling column 1 as an argument because it isn't set.
> >
> > Call SetQueryDef("All", Nz(Me.cboType, ""),
> > Nz(Me.cboReportCode.Column(1), ""), Nz(Me.cboReportCode, ""))
> > DoCmd.OpenQuery "forReports" & strWho, acViewNormal, acReadOnly
> >
> >
> > Respectfully,
> > Liz Ravenwood
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.