Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SourceObject Property (2003)

    SourceObject Property [Access 2003 VBA Language Reference] says:
    "You can also use this property for linked unbound object frames"
    I guess it's not an oxymoron so what's a linked unbound object frame?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SourceObject Property (2003)

    The distinction here is between linked and embedded. If an OLE object is embedded, the item is stored in the database itself, and if it is linked, the database merely contains a pointer to a file on disk. This is controlled by the OLE Type property of the object frame. If this is set to Linked, the Source Object property contains the full path and filename of the linked file.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SourceObject Property (2003)

    Thank you Hans,
    I've dragged an unbound object frame from the form design toolbox onto the OLEForm form in the attached mdb but why can't the OLE Type property be changed to [Linked]?
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SourceObject Property (2003)

    You have specified an embedded Excel object. Access has no information about its source any more, so it is impossible to change the OLE Type to Linked. You can either delete the control and create it anew, or do the following:
    - Set the Enabled property of the control to Yes.
    - Set the Locked property of the control to No.
    - Switch to Form view.
    - Right-click the control and select 'Insert Object...' from the popup menu.

    In the dialog that appears, select 'Create from file'. Specify a file and tick the 'Link' check box, then click OK.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SourceObject Property (2003)

    Thank you Hans,
    When you link an Excel file does the SourceObject get changed into the SourceDoc property?
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SourceObject Property (2003)

    It takes less time to verify that yourself than to ask it here, doesn't it?

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SourceObject Property (2003)

    Well, since we've been talking about the SourceObject property all along and I couldn't find it in the property sheet for the unbound object frame linked to the Excel file, I thought I'd better ask <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •