Display selected reports in a listbox

[biganthony]

Hello,

Is it possible to show only selected reports in a listbox? I can get all
reports listed there but I only want to display a selected list for my users.

Thanks - any help appreciated.

Regards
Anthony

 

[Duane Hookom]

I would never display a list of my report names to users since I use a naming
convention like "rptEmpPayroll" or "rptProduction" or "srptCompanyHeader". I
create a simple table of reports like:
ztblReports
rptObjectName
rptTitle (displayed in list box)
rptAuthor
rptStatus (is it ready?)
rptComments
I then base my list box on ztblReports.

 

[biganthony]

Duane,

Thanks for replying. How do I go about creating this table? Have you listed
the fields for the table? What if I only want to show selected reports in the
table that I have created with user-friendly names, rather than the ones I
called rptXXXXX etc?

Regards
Anthony

I would never display a list of my report names to users since I use a naming
convention like "rptEmpPayroll" or "rptProduction" or "srptCompanyHeader". I
create a simple table of reports like:
ztblReports
rptObjectName
rptTitle (displayed in list box)
rptAuthor
rptStatus (is it ready?)
rptComments
I then base my list box on ztblReports.

Hello,

[quoted text clipped - 5 lines]

Regards
Anthony

 

[Duane Hookom]

1) How do I go about creating this table?
a the same way you create any table
2) Have you listed the fields for the table?
a Yes
3) What if I only want to show selected reports ...?
a You set the list box properties to display the title field rather than
the report name
--
Duane Hookom
Microsoft Access MVP

Duane,

Thanks for replying. How do I go about creating this table? Have you listed
the fields for the table? What if I only want to show selected reports in the
table that I have created with user-friendly names, rather than the ones I
called rptXXXXX etc?

Regards
Anthony

I would never display a list of my report names to users since I use a naming
convention like "rptEmpPayroll" or "rptProduction" or "srptCompanyHeader". I
create a simple table of reports like:
ztblReports
rptObjectName
rptTitle (displayed in list box)
rptAuthor
rptStatus (is it ready?)
rptComments
I then base my list box on ztblReports.

Hello,

[quoted text clipped - 5 lines]

Regards
Anthony

 

[biganthony via AccessMonster.com]

Duane.

I have created a listbox that lists all my reports by using this code in the
source row:

SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY [Name];

I have read and understand what the code above does. But, how can I get the
listbox to list only a selected group of reports - I am totally stuck. I
thought I could put something in the description field for the reports I want
listed and then get the above query to display only those where the
description matches the criteria in the description field but that did not
work.

Regards
Anthony

1) How do I go about creating this table?
a the same way you create any table
2) Have you listed the fields for the table?
a Yes
3) What if I only want to show selected reports ...?
a You set the list box properties to display the title field rather than
the report name

Duane,

[quoted text clipped - 22 lines]

 

[Duane Hookom]

So, you are not accepting my advice and not telling me why? What's wrong with
maintaining a small table of report names, titles, and descriptions? This
should take about 5 minutes to implement.

--
Duane Hookom
Microsoft Access MVP

Duane.

I have created a listbox that lists all my reports by using this code in the
source row:

SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY [Name];

I have read and understand what the code above does. But, how can I get the
listbox to list only a selected group of reports - I am totally stuck. I
thought I could put something in the description field for the reports I want
listed and then get the above query to display only those where the
description matches the criteria in the description field but that did not
work.

Regards
Anthony

1) How do I go about creating this table?
a the same way you create any table
2) Have you listed the fields for the table?
a Yes
3) What if I only want to show selected reports ...?
a You set the list box properties to display the title field rather than
the report name

Duane,

[quoted text clipped - 22 lines]

Regards
Anthony