Search results

They are all DCount's. Fortunately the dataset is relatively small and will not be growing by leaps and bounds, so there is only a fraction of a second calculation delay. Jonathan, the requery statement worked perfectly. Thank you!

Attached screenshot Forgot to attach the screenshot of the form.

follow-up Thanks to you both, Paul and Mark. DCount worked like a charm. I have a follow-up question regarding how to have the DCount function update as the user enters new data on the form. My guess is that this will be slightly complicated in that the users will be entering data in a...

Thanks for the reply. Unfortunately, I am still stumped. I cannot get Access to display the result in a text box on a form. I've written SQL queries and run them as independent queries with complete success, but when I put the SQL text in the Control Source dialog of a text box, the text box...

That is what I have been attempting with no luck. Here is exacty what I have entered in the ControlSource of the text box: =(SELECT Count([tblAllUnits].[UnitID]) FROM tblAllUnits WHERE [tblAllUnits].[UnitTypeID]="R") If I create an independent query with this select statement, it returns a...

I searched the archives and Access Help and couldn't quite find the answer to this question, which is no doubt simple. I have a form showing Projects with an embedded subform showing all the Buildings associated with a given project. In the form footer section of the subform, I would like to...

Thanks Paul. Not knowing all the correct terms for things has made it a bit tricky to hunt up the proper info.

Thanks in advance for your help. I would like to set up rules/constraints such that the value selected in combo box A determines the available values in combo box B. For example, "Combo box A" is bound to the [PartnerType] field and "Combo box B" is bound to the [PartnerRole] field. Let's say...

Thanks Matt. Is there a way that I can set it up on a form so that when someone selects "LLC" from the partnertype combo box, the PartnerRole combo box automatically updates to show only the permissible values?

Hi all. As always, thanks in advance for the input. I'm building a database of housing developments done by my organization. There are a number of rules that I would like to enforce--many of the rules for data entry in a given field, depend on the value entered in a separate field. For...

I'd like to create a query which will consist of simple SELECT statements as follows: SELECT [table1].[field1], [table2].[field1], [table2].[field2] FROM table1 INNER JOIN table2 ON ([table1].[fieldX] = [table2].[fieldX]); The challenge arises b/c instead of joining on equal values, such as...

Thank you for the insight. Conditional formatting is exactly what I need. I have a follow-up question: Now I have a table with 4 fields: [IndicatorID], [NeighborhoodID], [Year], and [Value]. The [Value] field contains data for "# houses sold" and "value of houses sold" indicated. The first...

This starts as an architecture question and then gets into a form question. I work with a database of neighborhood indicators (health, crime, etc). Basically, I have a series of data tables; each table holds time-series data for a single indicator or a few related indicators. For each...

First of all, I may be thinking about this wrong, so feel free to offer architecture advice. This starts as an architecture question and then gets into the form question. I work with a database of neighborhood indicators (health, crime, etc). Basically, I have a series of data tables; each...

Any ideas why combo boxes that all have their "auto expand" option set to YES are not auto expanding as I type-in text? They were working last week and I have no idea why they're not working now. Strangely, if I type in any of the entries present in the combobox list (text such as "St. Louis...

Brilliant, that works. Thank you!

I have to leave the office for the weekend right now and won't be able to pick back up until Sunday afternoon. THANK YOU for all your help. I'll check in with you and try the code you're about to send me as soon as I have computer access on Sunday. I can't tell you how grateful I am for your...

Got it: "Rpt_bldgprmtsSubform"

Now, instead of first getting the "Are you sure you want to delete selected record?" dialogue first, it goes straight to: Error No: 2465 Description: Microsoft Office Access can't find the field 'l' referred to in your expression.

Hey RG, I finally tried the code you sent me (the last couple days have been mad!). Here's what happens: I click the delete record button and I get the dialogue, as I'm supposed to, asking "Are you sure you want to delete the selected record?" When I click "yes", I get the following error...