Limit List Form

[PARSO]

I have a form, which lists all reports i have available in my dateabase.
But there is 1 report which i dont want visable to users, how do i restrict access to this 1 form, either by it not showing on the list or password protecting it.
users have to double click the report name to open it from the list.

TY in advance

 

[KenHigg]

Where is the list box getting the rowsource?

 

[RoyVidar]

Depends on how you've populated that list, I guess.

If you're using MSysObjects, add a criterion to to it where name <> "yourreporttoexclude"..., similarly if you're populating through the allreports collection, I think.

My preference is to create a table (or two, or three) for all reports, with the additional information I wish to use, for instance, in which part of the program the different reports should be available etc.

This has a couple of other advantages too
* the users wont see the real names of reports (typically rptCustOrdersFiltered...)
* when you use the same report with different conditions/filters... you can display it to the users as separate reports, making it easier to customize reporting

 

[KenHigg]

If you're using a sys table, can't you just do a query based on the sys table that excludes the report?

 

[dopedealer]

If you're using a sys table, can't you just do a query based on the sys table that excludes the report?

Yes you can.
PARSO, It depends what you want,is there a query based on the selected value of the Listbox?
Chris

 

[KenHigg]

Chris, Just curious - Is there some kind of underlying, significant reason for a uername like dopedealer?

 

[dopedealer]

i work for the government

 

[KenHigg]

Hum... That wasn't my first guess but that would explain a lot about the gov.

 

[dopedealer]

what do you expect? most of them are over worked under paid, stressed...do the maths... ...jokes apart, i dunno why i chose that particular username i ve just used it in another forum and couldnt be bothered changing ids or passwords. On that note i d like to add, No private messages with anything relating to illegal activites will be answered.

 

[PARSO]

the list box is being populated by the following
Row Source:

SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>"~") And ([MSysObjects].[Type])=-32764 ORDER BY [MSysObjects].[Name];

I got the code off a forum, prob this 1. but i dont really understand it i just know it populates the list box with ALL reports saved on the DB, but i need a report called 'Audits' to NOT be shown.
if that helps??

 

[PARSO]

sorted it.
I simply added Not"Audits" to the query