VB Select Statment Help needed.

[Alc]

I'm stumped, I'm afraid

As Pbaldy suggests, perhaps something would stand out from the Db?

 

[gold007eye]

I will try and get a sample together. It wouldn't be affected by linked tables would it?

 

[pbaldy]

Wait, what version are you using? You might try disambiguating this:

Dim rsTo As Recordset

to this:
Dim rsTo As DAO.Recordset

after making sure the DAO library is checked in Tools/References.

 

[gold007eye]

I am using Access 2003

So you are saying I should use the As DAO.Recordset? insted of just "As Recordset"? What is the difference?

 

[gold007eye]

Wait, what version are you using? You might try disambiguating this:

Dim rsTo As Recordset

to this:
Dim rsTo As DAO.Recordset

after making sure the DAO library is checked in Tools/References.

Holy [Explicit]! I am now making some progress.. That seems to now be taking care of the syntax error message when I hard code the value for [AR Group] Now to just get it to work programatically.

THANKs so much Everyone! I'm sure I will still need some help, but let me see where I can go with this.

 

[pbaldy]

The difference is that there is also an ADO recordset, which has different syntax. Access didn't know which one you wanted, and made the wrong assumption (based on which was higher on the list).

 

[gold007eye]

Wow! Thanks again I can't believe all this because Access didn't have it's ADO Powerbar. lol. I have it sending e-mails and doing exactly what I needed it to do now..

I was about to go bonkers having 1 line of code hold up my project. hehe.

 

[pbaldy]

Great! Glad to hear you got it going.