Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-15-2019, 10:44 PM   #1
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 35
Thanks: 15
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
What Report level fields are available to the 'On Print' event

Hi, I have a query with a number of columns that aren't printed on the report line but that I was to save to table for each line on the report. In the 'On Print' event I can successfully pick up this particular field (Me.RaceEventID as it happens) from the drop down that appears so Access VBA knows it's in the collection but when I actually run the report VBA gives an error saying it can't field the field Me.RaceEventID. I'd like to know why this is and so is the only work around to 'print' the field on the line but to hide it for printing to to make it explicitly visible to the 'On Print' event? Thanks as usual for any help.
Stephen

GoodyGoody is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Print event? sja13 Modules & VBA 5 12-15-2017 09:38 AM
Graphics - print event in Access report or Excel max1 Reports 4 08-29-2015 09:18 PM
Close Event to Print Report velcrowe General 1 06-30-2006 09:08 AM
Report Event procedures not firing when directly print GumbyD Reports 3 08-17-2004 10:13 AM
Simple code for 'OnLoad' event to print a report nicktheblue Modules & VBA 2 10-19-2001 05:19 AM




All times are GMT -8. The time now is 07:51 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World