Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easiest Way to have access functionality in Excel or vice-versa? | Excel Worksheet Functions | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
Calendar Style Report in Access 2002 | Excel Discussion (Misc queries) | |||
get access form in excel | Excel Discussion (Misc queries) |