How do I make a list of Links to my Reports? (1 Viewer)

[comptechbranden]

I am using 97 and have been running into problems with tutorials from microsoft since they are in 2000 format. Its not a big difference so maybe I just cant figure it out...

Anyways, I wanted to make a list of the reports I had for the user to click on one and have it pop up. Anyone know how I can make this list?

My idea is to somehow create the names in the list box using a query or something and have them be links to the report somehow...

Please help...Thanks

 

[lessthanme5]

I Think This Should Work.

I think that this should work.... what it does is lists the "Reports " from the SysObject Table.



Make A List Box And Call It Something like "ReportList"
Enter This Code Into The Row Source:

SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

To select the report you would have to put something like:

Me.[ReportList].Value

In the "OnClick Event"

I Hope This Helps.

 

[lessthanme5]

I Think This Should Work.

I think that this should work.... what it does is lists the "Reports " from the SysObject Table.



Make A List Box And Call It Something like "ReportList"
Enter This Code Into The Row Source:

SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

To select the report you would have to put something like:

Me.[ReportList].Value

In the "OnClick Event"

I Hope This Helps.

 

[lessthanme5]

I Think This Should Work.

I think that this should work.... what it does is lists the "Reports " from the SysObject Table.



Make A List Box And Call It Something like "ReportList"
Enter This Code Into The Row Source:

SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

To select the report you would have to put something like:

Me.[ReportList].Value

In the "OnClick Event"

I Hope This Helps.

 

[lessthanme5]

I Think This Should Work.

I think that this should work.... what it does is lists the "Reports " from the SysObject Table.



Make A List Box And Call It Something like "ReportList"
Enter This Code Into The Row Source:

SELECT Name FROM msysobjects WHERE (((msysobjects.Type)=-32764));

To select the report you would have to put something like:

Me.[ReportList].Value

In the "OnClick Event"

I Hope This Helps.

 

[lessthanme5]

I Think The Server Just Had A microsoft Moment...

 

[lessthanme5]

I Think The Server Just Had A Microsoft Moment...

 

[lessthanme5]

Ahhhhhh........

 

[lessthanme5]

Ahhhhhh........

 

[comptechbranden]

Tosses an error on a macro. There is no "Me" Macro... I have tried this one before and I think you left out a bunch of information I would need to do it right with 97

On top of the error, the object table is unhidden but there is no list of reports in my list box when I view it...

 

[lessthanme5]

Ahhhhhh........

 

[lessthanme5]

Ahhhhhh........

 

[lessthanme5]

Ahhhhhh........

 

[lessthanme5]

Ahhhhhh........

 

[lessthanme5]

Have A Look at http://www.fabalou.com/Access/Forms/reportslist.asp

 

[comptechbranden]

Tosses an error on a macro. There is no "Me" Macro... I have tried this one before and I think you left out a bunch of information I would need to do it right with 97

On top of the error, the object table is unhidden but there is no list of reports in my list box when I view it...

 

[comptechbranden]

This forum is acting funny...seems to lag and when you press the reply button again it reposts ...

Anyways, none of the code works for me...

 

[lessthanme5]

The Answer... Hopefully

I have dug this out of my archive of old databases.... This Works 100% For Me....