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

Richard Holliingsworth

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

Subscribe Post Reply

2175

Wayne Morgan

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

Mike Storr

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

Similar topics

help with unbound fields

by: Dos Lil | last post by:

I have a unbound field in the subform(for calculating the datediff) which has the control property ==DateDiff("n",,). I have another unbound field in the main form which is for displaying the...

Microsoft Access / VBA

Sum Unbound Control on Continuous Form Footer?

by: Pat | last post by:

Hello, I've used Sum() to total bound fields on a continuous form with no problem. However, I now have a continuous form, on which I use an unbound field to calculate the number of hours between...

Microsoft Access / VBA

Unbound control problem

by: Trevor Hughes | last post by:

I am trying to resolve a problem I'm experiencing in Access 2000. I have an unbound control which is set be code on the open event of a form. However when I try to subsequently run some code...

Microsoft Access / VBA

If Statement Unbound Text Box

by: hmiller | last post by:

Hope I make my case clear!!! I have a table with two bound date/time fields. I want to be able to use an IF statement and DateDiff to return a text message in an unbound text box. I want to do...

Microsoft Access / VBA

Reference If Statement Result

by: hmiller | last post by:

I have created and IIF statement in an unbound text box. The IIF statement produces a text result, ie "On Time", in the unbound text box. What I would like to do is reffence this text box and then...

Microsoft Access / VBA

How to write null value to table using sql statement?

by: TD | last post by:

I have an unbound form that adds and updates records to one table. I use an INSERT sql statment to add a new record and a UPDATE statement to update a record. I created a function named C2F to...

Microsoft Access / VBA

Problems Saving Multiple Unbound Fields to a Table

by: TORQUE | last post by:

Hi, Im wondering if anyone can help me with a problem. I have a form with more than 50 unbound fields. Some of the fields will be blank from time to time. This seems to be where im having...

Microsoft Access / VBA

Unbound Control (if not populated, enter "0")

by: scott_baird | last post by:

Probably something simple, but it's driving me up the wall... In a report, I have an unbound control that is the total of 2 other bound controls (currency) as follows: unbound control =cash1 +...

Microsoft Access / VBA

Assign unbound Controls to Table Coulmns

by: SBC News Groups | last post by:

Using VBA how do I assign columns from a table to controls on an unbound form? Mike

Microsoft Access / VBA

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...

PHP

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General