Results 1 to 3 of 3

Thread: Excel as input 'window' in Access (OLE)

  1. Oct 6th, 2004, 05:03 AM #1
    LucGuldentops
    LucGuldentops is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2001
    Location
    Belgium/Antwerp
    Posts
    275

    Excel as input 'window' in Access (OLE)

    Is it possible to use the Excel OLE bound object for input in an Access application ?

    I am able to link this OLE Excel object to my database table and show the contents of the table, but it doesn't update the records when i change them in this 'Excel-view'

    Any suggestions to let this work ?

    Luc,
    Reply With Quote Reply With Quote
  2. Oct 6th, 2004, 11:35 AM #2
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    First, check the .UpdateOptions property of the OLE object. Also,
    how are you connecting the Access data to the Excel OLE object?
    Using the DataSource or code in the linked Excel file?
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  3. Oct 7th, 2004, 06:50 AM #3
    LucGuldentops
    LucGuldentops is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2001
    Location
    Belgium/Antwerp
    Posts
    275
    I have set the Row Source property via the properties to the Tablename

    Then i have set the updateproperties via Code as following

    OLEUnbound13.UpdateOptions = acOLEUpdateManual
    OLEUnbound13.Action = acOLEUpdate
    OLEUnbound13.Save
    OLEUnbound13.Requery

    Still, there is no update of my table and the Excel view is refreshed to the original values.

    Luc,
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width