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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 |