Bill,
Thank you. I have also encountered difficulties even just typing a message on the yahoo site.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
From: "'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, February 8, 2018 7:19 PM
Subject: RE: [MS_AccessPros] Filtering a continous form with multiple combo boxes
The Files section of our group has suffered some Yahoo problem. It will eventually be restored...or so they tell me.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 08, 2018 12:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Filtering a continous form with multiple combo boxes
Sent: Thursday, February 08, 2018 12:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Filtering a continous form with multiple combo boxes
I can seem to added my file to the Needs_Assistance folder...
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Valar Dohaeris"
From: "dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, February 8, 2018 2:38 PM
Subject: [MS_AccessPros] Filtering a continous form with multiple combo boxes
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, February 8, 2018 2:38 PM
Subject: [MS_AccessPros] Filtering a continous form with multiple combo boxes
I have a from called frmDocumentDashboard on it I have 3 comboboxes:
cmbChooseCabinet - Select cabinetID, cabinetname from tblCabinets
cmbChooseFolder - Me.cmbChooseFolder.RowSource = "SELECT tblFldrs.FolderID, tblFldrs.FolderName FROM tblFldrs " & _
" WHERE CabinetID = " & Nz(Me.cmbChooseCabinet) & _
" ORDER BY FolderName"
cmbChooseSubfolders - Me.cmbChooseSubfolder..RowSource = "SELECT tblSubfolders.SubfolderID, tblSubfolders.SubfolderName FROM tblSubfolders " & _
" WHERE CabinetID = " & Nz(Me.cmbChooseCabinet) & _
" ORDER BY SubfolderName"
Below these I have subform called sfrmDocumentListing which is a continuous form. Recordsource is
SELECT tblDocuments.DocumentID, tblDocuments.DocumentName, tblDocuments.DocumentLocation, tblDocuments.DocumentFileType, tblDocuments.DocumentFileKBSize, tblDocuments.DocumentMemo, tblDocuments.CreatedDate, tblDocuments.CreatedTime, tblDocuments.FolderID, tblDocuments.SubFolderID
FROM tblDocuments;
I would like to be able filter sfrmDocumentList based on the selection made in the combo boxes. Please advise.
Thank you,
Art Lorenzini
SD
__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar