467,877 Members | 1,304 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

How to attach an SQL statement to an unbound control????

Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #1
  • viewed: 1986
Share:
2 Replies
Try using the DCount function

=DCount("Node", "b321b1", "stdverifyby='test'")

You can replace the field name, Node, with * depending on the count you
need.

--
Wayne Morgan
MS Access MVP
"Richard Holliingsworth" <wi*******************@boeing.com> wrote in message
news:Ht********@news.boeing.com...
Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #2
Apply the SQL to the controls ControlSource property. For combos and
listboxes use the RowSource property.

Mike Storr
www.veraccess.com

"Richard Holliingsworth" <wi*******************@boeing.com> wrote in message
news:Ht********@news.boeing.com...
Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dos Lil | last post: by
3 posts views Thread by Trevor Hughes | last post: by
2 posts views Thread by hmiller | last post: by
3 posts views Thread by hmiller | last post: by
5 posts views Thread by SBC News Groups | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.