Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Validation rule based on a query
Hey, I have a form with a few fields. The form is designed for entering patients' lab results into a table. In another table (tb_parameters) I have fields for parameter, unit_type (mg, dL etc.) min (minimal acceptable value) and max. I use a combo box based on this table in order to chose the...- ejoffe
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Nested queries and Forms
The query is with grouping - You gave me my asnwer. Any ideas how to overcome it ? Thanks a million EJ- ejoffe
- Post #7
- Forum: Microsoft: Access Forms
-
Nested queries and Forms
Hi Lameid, I almost done (thanks to you). The querry problem, however, remains or maybe I did not understand you. I am trying to use a subform as the source of an update querry but the problem is that this subform is actually bound to a different querry all together. I am doing it because the...- ejoffe
- Post #5
- Forum: Microsoft: Access Forms
-
Nested queries and Forms
Hey Lameid, First, sorry for double posting - won't happen again. Second, I am really greatful for your reply - it is very kind of you. I am afraid I cannot use reports as my assignment is to create an interface for the user which allows entering, querrying and displaying the data. It probbaly...- ejoffe
- Post #3
- Forum: Microsoft: Access Forms
-
Nested queries and Forms
Hey, I am working on my first access project (please be patient and try to explain like to a child). My problems however are past the basic level so please bear with me .... I am working on a datbase which deals with laboratory data from patients which have different date stamps - ie. each...- ejoffe
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
