Update Queries

[razchip]

I have a couple of update queries that I have to run against a table. If I run them manually, they work fine, if I put them in an Event Procedure, they run, but they don't update the information. What am I missing?

Thanks for any help.

Thanks for the help.
Greg

 

[SiJP]

What code are you using to fire them...

------------------------
Hit any User to continue

 

[razchip]

I use a simple docmd string: DoCmd.OpenQuery "88A Add $ to GWEMP", acNormal, acEdit

Thanks for the help.
Greg

 

[SiJP]

Give it a whirl by excluding all but DoCmd.OpenQuery "88A Add $ to GWEMP"

...alternatively, use the Docmd.RunSQL command and dump the physical SQL statement into code


------------------------
Hit any User to continue

 

[razchip]

I converted them to SQL and they seemed to work. Thanks for the input.

Thanks for the help.
Greg