Really dumb question...

[DUX]

I learned most of my database knowledge (what little there is) via Oracle and SQL....if I wanted to just simply hard code an SQL insert statement in Access 97, where would I go to do this. I know this must seem like a really stupid question, but it just doesn't seem as obvious to me as I would have thought.

Thanks,
Dux

 

[ColinEssex]

I think you may need to be a bit more forthcoming with what you are exactly after.

You could be referring to writing a Function() in Modules or writing a sub-function attached to a button or a form or something.

Col

 

[Pat Hartman]

If you are familiar with techniques used by the "big" guys then you should understand binding. ONLY stored querydefs are bound so SQL coded in modules is less efficient.