How can I execute DoCmd.RunSQL without confirmation dialog boxes?

Question

I have been working on an inventory system using MS Access, everything is going well. I just want to ask if there is a way to execute DoCmd.RunSQL without these prompts/dialog boxes?

Hi everyone, I have solved this by putting single and double quotes. :) thank you everyone! — Marife C.A., Apr 15 '19 at 01:13

Gustav · Answer 1 · 2019-04-13T13:05:46.477

0

Yes, you can use Replace, after having set YourParameterValue to a value that makes sense:

DoCmd.RunSQL Replace(YourSqlString, "Purchased_4/1/2019", YourParameterValue)

or, if the value is a string:

DoCmd.RunSQL Replace(YourSqlString, "Purchased_4/1/2019", "'" & YourParameterValue & "'")

Though that parameter name seems a bit weird ...

edited Apr 13 '19 at 13:05

answered Apr 13 '19 at 08:21

Gustav

53,498
7
29
55

`DoCmd.RunSQL` doesn't take parameters from `DoCmd.SetParameter`.`DoCmd.OpenQuery` does though. – Erik A Apr 13 '19 at 08:49
@ErikA: You are right. Thanks. I've edited the answer. – Gustav Apr 13 '19 at 13:07

How can I execute DoCmd.RunSQL without confirmation dialog boxes?

1 Answers1