Feedback by UserVoice

Rob Koelmans

My feedback

  1. 193 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    We have presented in a recent user group session about an investment we are making in building a CDS Connector within the Access application, to successfully move your data to and from CDS; which will power a variety of Power App and MS Flow applications.
    Check out the presentation here https://www.youtube.com/watch?v=x_o3F89EcBI, and scroll to the latter half of this video to hear more about CDS/Power Apps.

    An error occurred while saving the comment
    Rob Koelmans commented  · 

    If you have a Power Automation Connector that Desktop Access, Word and Excel can connect to at its behind side you could easily provide a VBA function caller to anything in PowerAutomate. Access FE versions (that are cleaned out of code and data that should run behind a wall) can use the http action initiator to use their BE-versions to generate JSON on behalf of the WebAPI that Power Automation effectively provides. This way developers can have the BE deployed in an Azure Virtual Machine and thus have a structure to get their application 3-tier and GDPR-compliant. The VBA-code would would of course also become available automatically to PowerApps en other front-end environments. This is simular to how a Power Automate MySQL-connector from Microsoft or some third party works. Call it the 'Desktop Office Automation Connector' :-)

    An error occurred while saving the comment
    Rob Koelmans commented  · 

    I think not a single MS-Access programmer is waiting to move access or sql data to CDS to get their access applications not working anymore. You can only afford to extend with PowerApps/Flow, not replace years of Access development. A MySQL like Flow connector would also make a huge benefit (a connector that builds up a gateway to Flow/Automation from premises to Flow). We extended the reverse proxy as described in my suggestion above with VBA code that uses the Jscript COM Add-In to handle incoming and outgoing JSON. Incoming JSON fills a manually created ADO object which is being assigned as record source in form OnOpen events. Works like a charm. We plan to make that Odata V4 compatible, not just for data but als actions/methods that call vba functions/procedures.

    An error occurred while saving the comment
    Rob Koelmans commented  · 

    Hi Anders,
    Essentially I'm asking for a webservice optionally installed along with MS-Access that enables a webservice client to do everything a human could do with an Access Application (so, start MS-Access instance, load adm/accdb, use user-defined-functions/procedures/macros, open forms/reports, read/write form/report controls, trigger events or effectively equivalent).

    An error occurred while saving the comment
    Rob Koelmans commented  · 

    This would also enable Flow to perform scheduled jobs in a MS-Access application. A MS-Word/Excel like macro recorder would top it off.

    Rob Koelmans shared this idea  · 
  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Rob Koelmans shared this idea  · 
  3. 77 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Rob Koelmans supported this idea  · 
  4. 50 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Access (Desktop Application) » Forms  ·  Flag idea as inappropriate…  ·  Admin →
    Rob Koelmans supported this idea  · 
  5. 37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Rob Koelmans supported this idea  · 

Feedback and Knowledge Base