By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,649 Members | 1,572 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,649 IT Pros & Developers. It's quick & easy.

Issues Creating an Access Report Programmatically

P: 63
I am trying to create an Access report programmatically. So far I have been able to accomplish everything except the following:

1) I cannot determine the code to create a Page Footer
Expand|Select|Wrap|Line Numbers
  1. Set TextBox = CreateReportControl(strDynamicFinalReport, acTextBox, acFooter, , strFieldNM, intFieldPos, intFieldLine, intFieldRptWidth, intFieldHeight)
Gave the following Error:
Error Number: 2148 The number you used to refer to the form or report section is invalid

2) I cannot determine the code to create code for the On Close Event
Expand|Select|Wrap|Line Numbers
  1. Reports(strDynamicFinalReport).OnClose = "DoCmd.Restore"
Puts the command DoCmd.Restore into the Close property of the report which errors when the report closes.
Oct 18 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.