Limiting Fields

[mohammadagul]

Hello Everyone,

My Question is about limiting Fields in Access Reports. As i have seen in PeachTree Accounting Software, user can select specific fields to show in his report. I want to allow my user to limit fields in his/her reports a part from the field limitation in Report Wizard. Can it be done in Access Reports.
Thnaks

Muhammad Atif gul

 

[doran_doran]

Choose Report Fields...

This is a wonderful sample for Choose Fields for Report..... This particular sample has a limitation of 6 fields. However you can change the code and not set any limits.

Code for unlimited Fields
=======================================================
All you really need to do is change the query so it DOES NOT alias the
field names (remove the "As Field..." business so it looks like this:
strIN = strIN & "[" & lstLocalAuthority.Column(0, i) & "] ,"

Also, get rid of this part:
For i = k To lstLocalAuthority.ListCount - 1
strIN = strIN & "null as Field" & i & ","
Next i
=======================================================

Good Luck
Dianna Goldsberg

 

[mohammadagul]

Hi

Thanks A lot for you reply but unfortunately the file does not open in Ms Access. When i try to open it gives me an error message as such that microsoftAccess cannot recognise the database

please help thanks

Muhammad Atif Gul

 

[Mile-O]

It works fine for me - it's an Access 97 database. I opened it with Access 2002. What version are you using?

 

[doran_doran]

Try this link....

http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

 

[mohammadagul]

Hi Guys


Thanks A Lot For you contribution. It Works fine...

Thanks A Lot