how to get 'select count' sql result into form textbox

  • Thread starter Thread starter don
  • Start date Start date
D

don

I'm trying to jsut get 1 field result from 'Select
Count..' SQL statement into form textbox...i tried setting
the textbox control source property to the sql statement,
but that didntseem to work. Assuming i need to code the
sql in vba, but not sure how to get the sql result
assigned to the textbox..
Thanks for any help!
Don
 
thanks Joe!!! that was the ticket!!!

now i can head out to beach..i appreciate!!!!

Don
-----Original Message-----
Me![txtCount] = DCount("*", "tblName")
--
Joe Fallon
Access MVP



don said:
I'm trying to jsut get 1 field result from 'Select
Count..' SQL statement into form textbox...i tried setting
the textbox control source property to the sql statement,
but that didntseem to work. Assuming i need to code the
sql in vba, but not sure how to get the sql result
assigned to the textbox..
Thanks for any help!
Don
Click to expand...


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL as Textbox Control source 3
TextBox Object Control Source Expresion, trouble with 3
Top N values using textbox 1
Textbox controlsource = SQL statement ? 2
Getting Query Record Count into Text Box 5
Using string from one form to build query on another? 1
Expression Builder basic question on syntax / Or / how to incorporatea SQL query into a textbox cont 16
I'm not sure how to return the value using the SQL statement? 4

Back
Top