DoCmd****nSQL

[uncletreetrunk]

Hey all,



I'm trying to add values to a table using a form. On the net I've found multiple examples that use DoCmd****nSQL (strSQL)

but when I type DoCmd****nSQL into VBA editor I get an error. What do I need to bring in so that access recognizes the command?

Thanks in advanced!

[orange]

Without the *** please.

http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

It is helpful and facilitates communication if you tell us what you are trying to do in some detail, preferably with some sample data and any error messages you are currently receiving.

[uncletreetrunk]

Thanks for the quick reply orange!

I know it seems weird... but on multiple posts online they had the *'s

I want to do something similar to this post: http://www.dbforums.com/microsoft-ac...able-help.html

Without the *'s it says sub or function not defined

Maybe it's a Reference issue?

[orange]

How is the form related to the table? Is it a bound form?
Please tell us more detail of what you are trying to do. Sample data etc.

[pbaldy]

Some forums like that one mask the actual code because it looks like a Russian web site. The command is

DoCmd.RunSQL

[uncletreetrunk]

Ohh gotcha... that makes so much more sense xD

It works! Just one quick thing, after I run the code it prompts me that I am appending a table. I can use VBA to hit Yes right?

The actual message is: You are about to append 1 Row(s) Once you hit Yes, you can't use the Undo Command to reverse changes. Are you sure you want to append selected rows?

[pbaldy]

http://www.baldyweb.com/SQLWarnings.htm

[uncletreetrunk]

Ooooo thanks again pbaldy! That article was perfect again haha

[pbaldy]

Happy to help!