|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 1st, 2009, 04:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Categorize Reports
Hi All
does anyone know how to categorize a bunch of reports by Subject? So far, I have created a form, created a list box that display 3 categories for example Brian's reports, Keith's reports, Mike's reports. When a user makes a selection, he would pick a report from a combo box associated with that category, let's say Brian's reports. I'm having a hard time to do that. Does anyone know how to do that? I would greatly appreciate any help. thanks a lot. Sylvie 
|
|
#2
May 1st, 2009, 05:44 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Categorize Reports
Sounds like you want a Switchboard.
"SylvieB" wrote: Hi All does anyone know how to categorize a bunch of reports by Subject? So far, I have created a form, created a list box that display 3 categories for example Brian's reports, Keith's reports, Mike's reports. When a user makes a selection, he would pick a report from a combo box associated with that category, let's say Brian's reports. I'm having a hard time to do that. Does anyone know how to do that? I would greatly appreciate any help. thanks a lot. Sylvie
|
|
#3
May 1st, 2009, 05:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Categorize Reports
I generally create a couple application tables for this:
ztblReports =============== rptRptID autonumber primary key rptRCaID link to ztblReportCategories.rcaRCaID rptName actual name of the report object like rptTimeSheet rptTitle friendly name to display rptStatus active, inprogress, inactive rptAuthor etc ztblReportCategories ================= rcaRCaID autonumber primary key rcaTitle friendly name to display If a report can be in two categories, remove rptRCaID from ztblReports and create a junction table. -- Duane Hookom Microsoft Access MVP "SylvieB" wrote: Hi All does anyone know how to categorize a bunch of reports by Subject? So far, I have created a form, created a list box that display 3 categories for example Brian's reports, Keith's reports, Mike's reports. When a user makes a selection, he would pick a report from a combo box associated with that category, let's say Brian's reports. I'm having a hard time to do that. Does anyone know how to do that? I would greatly appreciate any help. thanks a lot. Sylvie
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
