|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2006, 05:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Record Count query displayed on a form
I have a Master Form from which I am able call all of my administrative
tasks. Now I have a query that does a number of record counts (about 30). I want to be able to display the query results on the form. How do I do this? 
|
|
#2
May 21st, 2006, 08:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Record Count query displayed on a form
If this query has only one record return, then, in the form create a text
box and in the control source of tis text box write =DlookUp("[FieldName]","[QueryName]") -- Good Luck BS"D " wrote: I have a Master Form from which I am able call all of my administrative tasks. Now I have a query that does a number of record counts (about 30). I want to be able to display the query results on the form. How do I do this?
|
|
#3
May 27th, 2006, 01:39 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Record Count query displayed on a form
The Query has many records. It counts the records across about 24 TBLs.
Would like to simply call the query into the Form, and display all results of the query. Can't figure out which Built-In ActiveX Control I should use. "Ofer Cohen" wrote in message ... If this query has only one record return, then, in the form create a text box and in the control source of tis text box write =DlookUp("[FieldName]","[QueryName]") -- Good Luck BS"D " wrote: I have a Master Form from which I am able call all of my administrative tasks. Now I have a query that does a number of record counts (about 30). I want to be able to display the query results on the form. How do I do this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
| Form has record displayed when open | rg32 | Using Forms | 4 | June 10th, 2005 08:50 PM |
| How to get a field on a form to reflect a certain record of a query? | General Discussion | 0 | December 11th, 2004 12:56 AM | |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Linear Mode
