Everything About Using Parameters from Code - QueryDef 1

[vistor]

Here is a good site that explains how to pull records sets using a query parameter.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00e19.asp

 

[MichaelRed]

... and you feel the discussions within these fora are incomplete or inaccurate in what respect?


MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[vistor]

I don't feel they are inadequate at all. I've seen other posts on tips that site other forumns and web sites. I didn't know you had to have special permission to do so.

 

[slreynolds]

It looks like a useful link which would help someone to come up with their own answers. Thanks

 

[vistor]

slreynolds,

I found it helpfull to me. I had never come across a good explaination of using QueryDef (even in this excellent forumn), and after reading this article, I was able to write a good piece of code to send out emails to everyone from a query pull.

I hope it is helpfull to others.

Vistor

 

[trystanhuwwilliams]

I must say that I agree with visitor, I've been attempting to learn about the recordset & querydef aspects of Access or some time & wheras there are very helpful & simple explanations of the recordset, there are no complete or easy clarifications concerning Querydefs.

I find the Microsoft help files over-complicated & mostly un-helpful & any threads posted on this forum do not fully explain the basic principals of their function.

I don't understand why you can open a recordset from a Table & not a query...

Anyway I'm going to read that article & hopefully things will seem clearer afterwards.

Thank you.