Nov 04 2022 06:46 AM
I have a very simply VBScript that clones a record taken almost step-by-step from an Access Macro. Here's the copy:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
MsgBox ("Go on")
DoCmd.RunCommand acCmdPasteAppend
Without the MsgBox, I get an error that says the Append command isn't available now. However, if I have the MsgBox and click OK the script runs fine. What do I need to do so that I don't need the MsgBox? I can't figure out why it's throwing the error without the message box. Ideas?
Nov 04 2022 07:57 AM
Nov 04 2022 08:15 AM
@Tom_van_Stiphout Great Idea! I hadn't thought of that.
Nov 04 2022 08:17 AM
SolutionNov 04 2022 08:17 AM
Solution