LoginSignup
@frswataru (本石 渉)

Are you sure you want to delete the question?

If your question is resolved, you may close it.

Leaving a resolved question undeleted may help others!

We hope you find it useful!

Accesss VBA クエリ実行 トランザクション実装

Q&A

VBAaccess

解決したいこと

AccessVBAでのクエリを実行に加えてトランザクション処理を実装したいです
解決方法を教えて下さい。

該当するソースコード

Sub Query1()

DoCmd.SetWarnings False
    DoCmd.OpenQuery "Q_step04_T_山積み時間Delete", acViewNormal, acEdit

    DoCmd.OpenQuery "Q_step05_T_山積み時間Create", acViewNormal, acEdit

    DoCmd.OpenQuery "Q_step15_T_作業指示Delete", acViewNormal, acEdit

    DoCmd.OpenQuery "Q_step16_T_作業指示Create", acViewNormal, acEdit
DoCmd.SetWarnings True

End Sub
0 likes

No Answers yet.

Your answer might help someone💌

LoginSign Up