Crap. Email did something weird to my table.
The results go like this:
Selection Selected
Emirates Area
Emirates Program
Etc.
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 Liz Ravenwood
Sent: Wednesday, July 10, 2013 8:09 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] combo box Access bug?
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
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
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.
[Non-text portions of this message have been removed]
------------------------------------
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar