Need help
- Thread starter Tawcan
- Start date
nightwalker
Registered User.
- Local time
- Yesterday, 16:43
- Joined
- Mar 28, 2003
- Messages
- 17
There is a Pages Collection which has Page as the Object ... and then you can specify the number of the page you actually wanna see ... its same concept as Forms Collection ...
Tawcan said:
- Local time
- Yesterday, 19:43
- Joined
- Feb 19, 2002
- Messages
- 47,604
How would you know ahead of time which page(s) you wanted to display? If you want to limit the output to particular records, use either the filter or where arguement of the OpenReport Method. If you want to print specific page ranges or multiple copies, use the PrintOut Method.
The report can range from 2 - 6 pages.
Ok I found a way to do this by using filter....but I'm not very good with VB coding...please help.
Right now the code is:
Me.FilterOn=True
Me.Filter = " conditions/criterias "
In the table that the report reads, there are fields such as YEAR, REQ COURSES, SESSION, GRADES, etc.
For my condition I want YEAR = 1, YEAR = 2, YEAR = 3, GRADE < 50 % or Grade = " F " and so on...
But when I do
Me.Filter= "YEAR=2"
Access complains about the code.... could someone help me on how I could set the conditions/criterias for the filter using VB code? Also how do I use AND, OR and stuff like that on coding?
How do you use OpenReport/PrintOut methods?
Me.PrintOut= "2" - > page 2 ?
Thanx.
Ok I found a way to do this by using filter....but I'm not very good with VB coding...please help.
Right now the code is:
Me.FilterOn=True
Me.Filter = " conditions/criterias "
In the table that the report reads, there are fields such as YEAR, REQ COURSES, SESSION, GRADES, etc.
For my condition I want YEAR = 1, YEAR = 2, YEAR = 3, GRADE < 50 % or Grade = " F " and so on...
But when I do
Me.Filter= "YEAR=2"
Access complains about the code.... could someone help me on how I could set the conditions/criterias for the filter using VB code? Also how do I use AND, OR and stuff like that on coding?
How do you use OpenReport/PrintOut methods?
Me.PrintOut= "2" - > page 2 ?
Thanx.
- Local time
- Yesterday, 19:43
- Joined
- Feb 19, 2002
- Messages
- 47,604
I think you will have an easier time if you use the where argument of the OpenReport Method rather than using the filter within the report's code module.
You can formulate the where argument depending on what selection you need. BTW, if you really have a field named YEAR, chang it to something else. Year is the name of a function.
strWhere = "(myYEAR = 1 OR myYEAR = 2 OR myYEAR = 3) AND (GRADE < '50' or Grade = 'F')"
You can formulate the where argument depending on what selection you need. BTW, if you really have a field named YEAR, chang it to something else. Year is the name of a function.
strWhere = "(myYEAR = 1 OR myYEAR = 2 OR myYEAR = 3) AND (GRADE < '50' or Grade = 'F')"
Hmmm so if I use OpenReport I can limit to which page I want to view? (not print, view).
Tried using filter again but doesn't seem to work..
I did:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2
Me.Filter = GRADES < "50"
Me.FilterOn = True
End Sub
When I tried running the program Access complained that the Me.Filter line contains no value.
Also tried
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2
Me.Filter = ([Forums![INDIVIDUAL APR]!Box2].GRADES < "50")
Me.FilterOn = True
End Sub
This time it tells me that [ cannot be found... take out the [ ] and it says missing object.
Tried using filter again but doesn't seem to work..
I did:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2
Me.Filter = GRADES < "50"
Me.FilterOn = True
End Sub
When I tried running the program Access complained that the Me.Filter line contains no value.
Also tried
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms![INDIVIDUAL APR]!Box2
Me.Filter = ([Forums![INDIVIDUAL APR]!Box2].GRADES < "50")
Me.FilterOn = True
End Sub
This time it tells me that [ cannot be found... take out the [ ] and it says missing object.
Hmmm filter seems to work with my reports...
But when I use the subreport properties to show these reports on a main report page, Access complains about the filter conditions.... " The setting you entered isn't valid for this property"
Any idea why?
But when I use the subreport properties to show these reports on a main report page, Access complains about the filter conditions.... " The setting you entered isn't valid for this property"
Any idea why?
- Local time
- Yesterday, 19:43
- Joined
- Feb 19, 2002
- Messages
- 47,604
You can't filter subreports or subforms.
