Réponses céées sur le Forum

  • Youssef

    Membre
    2 décembre 2024 à 15h53 en réponse à: Modifier LISTE SHAREPOINT depuis MS ACCEESS

    I have received the solution in another forum:
    https://learn.microsoft.com/en-us/answers/questions/2124600/sharepoint-and-ms-access-2019

    Hi,

    Yes, that’s a problem with linked Sharepoint lists. The good news is that when you automate the queries with macros or VBA code you can avoid the confirmation messages. In VBA you can use the DAO execute method e.g.

    CurrentDb.Execute “YourActionQuery”, dbFailOnError

    which doesn’t raise the (Access) confirmation messages.

    The other method is to explicitely suppress the warnings:

    DoCmd.SetWarnings False DoCmd.OpenQuery “YourActionQuery” DoCmd.SetWarnings True

    This is also available as a macro action (in fact VBA calls the macro action here).

    Servus Karl