If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Event descriptions...
Could someone please point me to a list of report events and their general
descriptions/usage examples? I can't seem to find anything via google... many thanks, -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) |
#2
|
|||
|
|||
Event descriptions...
More specifically, I have a report with a subreport, and I want to change the
SourceObject of the subreport based on a value in the main report... If Me.fldReleaseType = 1 Then Me.ctlsrptReleases.SourceObject = "rptOrders_sKBRls" End If -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) "Jack Leach" wrote: Could someone please point me to a list of report events and their general descriptions/usage examples? I can't seem to find anything via google... many thanks, -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) |
#3
|
|||
|
|||
Event descriptions...
Jack Leach dymondjack at hot mail dot com wrote:
Could someone please point me to a list of report events and their general descriptions/usage examples? I can't seem to find anything via google... VBA Help is (from the object browser?) is all I have ever seen. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
Event descriptions...
Jack Leach dymondjack at hot mail dot com wrote:
More specifically, I have a report with a subreport, and I want to change the SourceObject of the subreport based on a value in the main report... If Me.fldReleaseType = 1 Then Me.ctlsrptReleases.SourceObject = "rptOrders_sKBRls" End If Up to at least A2003 (and I doubt it's going to change), you can only set a source object property in the main report's Open event. Since that is before any values are available, I don't think it's possible to do what you asked. The usual(?) way to deal with the situation is to add both subreports and change their visibility as needed. -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
Event descriptions...
I found some VBA help on it but it wasn't all that helpful... I'm not that
good with reports to begin with and if I understand correctly, report events have a lot more usage stipulations and forms do. Looks like it'll good old-fashioned trial & error -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) "Marshall Barton" wrote: Jack Leach dymondjack at hot mail dot com wrote: Could someone please point me to a list of report events and their general descriptions/usage examples? I can't seem to find anything via google... VBA Help is (from the object browser?) is all I have ever seen. -- Marsh MVP [MS Access] . |
#6
|
|||
|
|||
Event descriptions...
Thanks Marshall, that'll do.
-- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) "Marshall Barton" wrote: Jack Leach dymondjack at hot mail dot com wrote: More specifically, I have a report with a subreport, and I want to change the SourceObject of the subreport based on a value in the main report... If Me.fldReleaseType = 1 Then Me.ctlsrptReleases.SourceObject = "rptOrders_sKBRls" End If Up to at least A2003 (and I doubt it's going to change), you can only set a source object property in the main report's Open event. Since that is before any values are available, I don't think it's possible to do what you asked. The usual(?) way to deal with the situation is to add both subreports and change their visibility as needed. -- Marsh MVP [MS Access] . |
#7
|
|||
|
|||
Event descriptions...
Jack Leach dymondjack at hot mail dot com wrote:
I found some VBA help on it but it wasn't all that helpful... I'm not that good with reports to begin with and if I understand correctly, report events have a lot more usage stipulations and forms do. Looks like it'll good old-fashioned trial & error I totally agree that help is very thin about report event nuances. Lots and lots of trials and many errors is what I've been doing for years. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|