Error in VBA from DoCmd.RunCommand acCmdSaveRecord

Question

We have moved to Access 2016 but are using databases created in Access 2003.  We get an error when the VBA gets to the command:

DoCmd.RunCommand acCmdSaveRecord

So far, everything else seems to work okay.

Note: some of our computers are running Windows 7,  Others are running Windows 10.  

Why won't this command work?  Is there a rational work-around?

Thanks

Answer 1

What is the error you get? Did you confirm that acCmdSaveRecord is a valid constant?

Answer 2

Is there any chance that you can indicate what error you are getting when the command is run?

Answer 3

The error simply says that the command is not available.

My thought right now is to try to figure a work-around that will accomplish the same purpose without using that command.  Any better idea?

Answer 4

Sorry, I did not find time to create a small database that could illustrate the problem.  I have two thoughts:

1. I can probably to come up with a work-around.  the command that won't work simply saves changes to the record without moving off of the record.  I suspect that I can make note of the record, move off of it, then move back to it and it will have been saved.
2. Failing that, I'll be back to trying to make the command work.

If my work around works would you still like me to create the small database to illustrate it?  I don't think it'll be that hard to do and shouldn't take too much time.  I've just been busy with bigger problems this past couple of weeks and didn't get to it.

Thanks for your help

Answer 5

The workaround is:

Me.Dirty = False