747skipper
New member
- Local time
- Today, 12:21
- Joined
- Sep 30, 2019
- Messages
- 16
I fear I may have misunderstood something elementary. Please can someone can tell me what.
Every 6 month I need to print double-sided A4 coversheets. Side one has an individual's details from a database I maintain, side 2 has an order form.
A barely computer literate member of our association produces this order form as an Excel sheet. (I don't know why and I can’t change this.)
I have an unbound Object frame on my Access report and when I create it, I set the Source Doc to the path of the Excel sheet and set OLE Type to linked. It will not let me create one with SourceSoc blank.
This works! But six months later when I replace or update the Excel sheet the Access report does not change, indeed I can delete the Excel sheet and Access will happily continue using the original.
I have definitely NOT set the type to embedded.
I cannot change the sourcedoc in code. (I have tried a couple of examples from Microsoft but they always fail at 'Create linked object.' ' OLE1.Action = acOLECreateLink'
I have tried Bound objects, which logically sound like what I need, but with even less success.
Filling a report field of fixed size and location with data from another source sounds so simple., what am I doing wrong please?
Every 6 month I need to print double-sided A4 coversheets. Side one has an individual's details from a database I maintain, side 2 has an order form.
A barely computer literate member of our association produces this order form as an Excel sheet. (I don't know why and I can’t change this.)
I have an unbound Object frame on my Access report and when I create it, I set the Source Doc to the path of the Excel sheet and set OLE Type to linked. It will not let me create one with SourceSoc blank.
This works! But six months later when I replace or update the Excel sheet the Access report does not change, indeed I can delete the Excel sheet and Access will happily continue using the original.
I have definitely NOT set the type to embedded.
I cannot change the sourcedoc in code. (I have tried a couple of examples from Microsoft but they always fail at 'Create linked object.' ' OLE1.Action = acOLECreateLink'
I have tried Bound objects, which logically sound like what I need, but with even less success.
Filling a report field of fixed size and location with data from another source sounds so simple., what am I doing wrong please?