Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-17-2019, 02:27 AM   #1
jysharp2003
Newly Registered User
 
Join Date: Feb 2018
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
jysharp2003 is on a distinguished road
insert report within a form access 2007

Hi all,
I have a form below (Emp Scheduling tool) that would really look good if a schedule (currently in report format) could be embedded to the side. I did get a static image of the report but was hoping that it could be displaying current schedule records. Read only and users would click a link to open the report for schedule printing. My attempt with this requires a reference to be added so when users download (not savvy computer users) it requires them to go VB and add Adobe reference......not a good solution for us.
No posts in UTTER and very little on web.
Any ideas experts?
Attached Images
File Type: jpg static_report.jpg (85.1 KB, 15 views)
File Type: jpg static_report1.jpg (90.7 KB, 12 views)

jysharp2003 is offline   Reply With Quote
Old 04-17-2019, 04:14 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 1,446
Thanks: 19
Thanked 362 Times in 354 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: insert report within a form access 2007

Hi. Rather than use an OLE control, try using a subreport control.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old Yesterday, 04:54 AM   #3
jysharp2003
Newly Registered User
 
Join Date: Feb 2018
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
jysharp2003 is on a distinguished road
Re: insert report within a form access 2007

Hi DBguy, Thanks for the time. Can you post the steps for your recommendation above please?

jysharp2003 is offline   Reply With Quote
Old Yesterday, 05:08 AM   #4
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,512
Thanks: 0
Thanked 368 Times in 367 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: insert report within a form access 2007

Same as using a form as subform. Use a subform/subreport container control and set its SourceObject property to the report.

__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Reply

Tags
forms , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 insert into table where source is another table and form Martinus Queries 5 02-04-2015 04:56 AM
Access 2007 Report Form BrucesAccessWorldFor Reports 5 08-29-2012 05:04 AM
delete & insert for access 2007 drstein Queries 6 12-28-2011 09:28 AM
how to insert an if logic in the builder Access 2007 KWHAT Forms 3 12-08-2011 06:53 PM
Insert command in Access 2007 Dick7Access General 7 07-07-2009 11:03 AM




All times are GMT -8. The time now is 01:10 AM.


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