docmd.transfertext

[GShen]

Using an ADP. backend stored procedures. have done this million times for a table. Cany you sub. a stored procedure returning the data you want in place of the table. 100 people on the net say yes, 100 say no. The syntax says you can use a query. Does a query mean a sp as well? 1 person said create a query in vb. I could not do that because there was no DIM for querydefs. Do I need another ref. as an add-in ? ....thanks.

Remember when... everything worked and there was a reason for it?

 

[SkipVought]

hi,

MS Access questions are much better addressed in one of the many MS Access forums like forum705.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}