Need to make a report list! Nothing seems to work...

[comptechbranden]

Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.

http://www.fabalou.com/Access/Reports/filterreport.asp
http://www.fgcu.edu/support/office2000/access/
http://www.access-programmers.co.uk/forums/showthread.php?t=110337

I think the code just isnt working in 97...

Any Ideas? Maybe I just need more help or the code needs edited!?!?!

Thanks.

 

[KeithG]

You could try to query the MSysObjects table. Put the be SQL statement into a query and save it. Then use the query for the listbox data. I'm using Access 2003 but I beleive this should work for you

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

 

[comptechbranden]

Ill try that again...Im just at a loss here lol. This is like what the hold up is to get this project into implementation...

Ill try that in a few after a meeting here.

 

[comptechbranden]

That did give me a nice usable list of all the reports but I need to have a listbox of all the table fields to do a group by assending on one of them per users request. Then I need to do a filter on all the data so it only shows data that they type in like company name, site name, etc...

So in the end I will have a report that is sorted by either a project number or company name per users request then it would only show projects from a specific client or from a specific site or project type or whatever. The lists would depend on what fields I have in my table.