Search results

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 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...

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...

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...

I'm new to form design and do not know any VBA (but that won't stop me from messing with the code when need be). I'm creating a form that will serve as the user-interface for viewing, adding, and deleteing data. The product I want is a form with 3 items: a subform that displays data in a table...