SQL Procedures

13/09/2007, 18h43

Does any body have any VB (inside of Access) examples of creating SQL
produces inside a access form via vb and then executing those procedures and
returning the results to the screen?

Thank you in advance,
Mike

13/09/2007, 18h45

"Michael Kintner" <nospam@nospam.com> wrote in message
news:13eitmadcg0p839@corp.supernews.com...
> Does any body have any VB (inside of Access) examples of creating SQL
> produces inside a access form via vb and then executing those procedures
> and returning the results to the screen?
>
> Thank you in advance,
> Mike
>

Why would you create a procedure from a form? How about using a
parameterised procedure instead?

Lookup the CREATE PROCEDURE statement in SQL Server Books Online.

--
David Portas

13/09/2007, 18h43	#1 (permalink)
Michael Kintner Messages: n/a Hébergeur:	SQL Procedures Does any body have any VB (inside of Access) examples of creating SQL produces inside a access form via vb and then executing those procedures and returning the results to the screen? Thank you in advance, Mike

13/09/2007, 18h45	#2 (permalink)
David Portas Messages: n/a Hébergeur:	Re: SQL Procedures "Michael Kintner" <nospam@nospam.com> wrote in message news:13eitmadcg0p839@corp.supernews.com... > Does any body have any VB (inside of Access) examples of creating SQL > produces inside a access form via vb and then executing those procedures > and returning the results to the screen? > > Thank you in advance, > Mike > Why would you create a procedure from a form? How about using a parameterised procedure instead? Lookup the CREATE PROCEDURE statement in SQL Server Books Online. -- David Portas

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email