A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Event descriptions...



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2010, 02:18 PM posted to microsoft.public.access.reports
Jack Leach
external usenet poster
 
Posts: 33
Default 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  
Old April 25th, 2010, 02:29 PM posted to microsoft.public.access.reports
Jack Leach
external usenet poster
 
Posts: 33
Default 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  
Old April 25th, 2010, 03:59 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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  
Old April 25th, 2010, 04:02 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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  
Old April 25th, 2010, 04:41 PM posted to microsoft.public.access.reports
Jack Leach
external usenet poster
 
Posts: 33
Default 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  
Old April 25th, 2010, 04:42 PM posted to microsoft.public.access.reports
Jack Leach
external usenet poster
 
Posts: 33
Default 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  
Old April 25th, 2010, 06:02 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.