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 Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Form In An Access Report (SubForm) Question



 
 
Thread Tools Display Modes
  #1  
Old January 27th, 2006, 05:54 AM posted to microsoft.public.excel.links
external usenet poster
 
Posts: n/a
Default Access Form In An Access Report (SubForm) Question

I want to cycle through an excel with multiple worksheets, and showing the
first cell of each worksheet (which has drawings in that cell) on a report.
I must change the source path with VBA Code.

So I use a Form with an Unbound Object Frame (OLEUnbound4) Linked to an
excel worksheet, there is a link source path to the excel file and a image
on that Unbound Object Frame (OLEUnbound4).

I put that Form inside a Access Report, the report display the image on the
Form. During run-time, I update the Form to a different Link path, and the
image on the Form changes, but the Report (when open after the form updated)
still shows the original image of the Form.

Can someone tell me how to correct this problem where I can get the current
image on the Form???? I have been trying for a week and can't figure it
out. I also studies knowledge articles #311147, #202174, and #209990.

The reason for using the Form was to update the link with VBA code because
it has the Enabled and Locked property available to VBA coding.

Thanks!

G
 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form, Subform, Tab key 2nd_Stage_User Using Forms 17 August 25th, 2006 12:30 AM
Date range on reports Mark_Milly Setting Up & Running Reports 10 January 19th, 2006 03:49 PM
Need Help In Printing Current Record in Specific Report RNUSZ@OKDPS Setting Up & Running Reports 1 May 16th, 2005 09:06 PM
Help!! I'm running around in circles! CathyA New Users 19 December 12th, 2004 07:50 PM
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM


All times are GMT +1. The time now is 10:48 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.