I have a query called qryFieldDataList:
SELECT tblFieldNames.FieldNameID, tblFieldNames.CabinetID, tblFieldNames.FIeldName, tblData.DataID, tblData.Data
FROM tblFieldNames INNER JOIN tblData ON tblFieldNames.FieldNameID = tblData.FieldNameID;
I know there should be WHERE in here filtering on CabinetID
I an thinking it should be some like:
WHERE CabinetID = Forms!frmDocumentDashBoard!sfrmCabinetView!cmbChooseCabinet.value
But that does not work.
This query will support a subform called sfrmCabinetView which sits on the main from called frmDocumentDashboard. On frmDocumentDashboard is a combo box called cmbChooseCabinet. When the user selects a cabinet from the list it sets the CabinetID which I a trying to get to filter sfrmCabinetView which is a continuos form.
sfrmCabinetView Ex.
Form header section
lblField1 lblField2 lblField3 lblField4 lblField5……………………………..>lblField11
Details Section
txtField1 txtField2 txtxField3 txtField4 txtField5……………………………..>txtField11
The results of running query qryFieldDataList is as follows:
qryFieldDataList | ||||
FieldNameID | CabinetID | FIeldName | DataID | Data |
8 | 2 | Name | 1 | Abbey Aron |
9 | 2 | City | 2 | Dickinson |
10 | 2 | State | 3 | North Dakota |
11 | 2 | Zip | 4 | 58601 |
12 | 2 | District | 5 | |
13 | 2 | Position | 6 | Laborer |
14 | 2 | BIA Registration | 7 | |
15 | 2 | Tero Registration | 8 | 06-07-2011 |
16 | 2 | Education | 9 | HSD |
8 | 2 | Name | 10 | Adams John |
9 | 2 | City | 11 | Fort Yates |
10 | 2 | State | 12 | North Dakota |
11 | 2 | Zip | 13 | 58538 |
12 | 2 | District | 14 | Long Soldier |
13 | 2 | Position | 15 | Laborer |
14 | 2 | BIA Registration | 16 | |
15 | 2 | Tero Registration | 17 | |
16 | 2 | Education | 18 | HSD |
18 | 3 | Vendor Name | 19 | Bammers Seamless Gutters LLP |
19 | 3 | City | 20 | Flasher |
20 | 3 | State | 21 | North Dakota |
21 | 3 | Zip Code | 22 | 58535 |
22 | 3 | Type of Service | 23 | Other Direct Program Costs |
23 | 3 | PO Number | 24 | |
24 | 3 | Date | 25 | 05-23-2013 |
25 | 3 | Account Number | 26 | 0052-0052-50690-00 |
26 | 3 | Account Name | 27 | Other Direct Program Costs |
So the sfrmCabinetView Should look something like:
Form header section
Name City State Zip District……………………………..>lblField11
Details Section
Abbey Aron Dickinson North Dakota 58601 txtField5……………………………..>txtField11
Adams John Fort Yates North Dakota 58601 Long Soldier
Now if a Data field or Label.Caption is blank I would like to enter "N\A" or suppress it all together.
Thank you ,
This might look better is you copy and paste it to a Word Doc or something.
Posted by: dbalorenzini@yahoo.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar