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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I group an Option Button on a Continuous Form?
lupins46: Thanks for the response. Using a JOIN I can select the relevant fields instead of '*'. Konacq- konacq
- Post #3
- Forum: Microsoft: Access Forms
-
How can I group an Option Button on a Continuous Form?
I have an option button on a continuous subform bound to a field called 'Default'. The subform shows a subset of records based on a SELECT statement using criteria derrived from fields on the master form. The idea is that one (and only one) record within the set of records returned from the...- konacq
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Question
mama16: It depends upon the level of detail you are interested in, but two detailed and well presented books I highly recommend are: Microsft Access Inside Out, published by Microsoft, ISBN 0735615136 Microsoft Access Bible, published by Wiley, ISBN 0764539868 Konacq- konacq
- Post #3
- Forum: Microsoft: Access Forms
-
View duplicate records side-by-side on a form.
rwolff: If you just need two forms side by side, why not create one form with two subforms embedded side by side? Use the controls on the main form to index which records are displayed on the subforms, in effect creating a continuous side-by-side form. Konacq- konacq
- Post #5
- Forum: Microsoft: Access Forms
-
Updating an Age field using the built in date
Viv1: You can recalculate the age each time the form opens, as in: Private Sub Form_Open(Cancel As Integer) Me!Age = DateDiff("yyyy", [DOB], Now()) + Int(Format(Now(), "mmdd") < Format([DOB], "mmdd")) If Me!Age > 40 Then Call My_Function End If End Sub The problem is, you...- konacq
- Post #3
- Forum: Microsoft: Access Forms
-
Can't Find "Link Child" and "Link Master" property fields
Zor, AceMan1: That's got it. You were both right. I now realize that, when I was viewing the properties, I was viewing the properties of the second form as a form - not as a subform. With your assistance, I have discovered how to view the subform properties. Thank you for pointing me in...- konacq
- Post #6
- Forum: Microsoft: Access Forms
-
Can't Find "Link Child" and "Link Master" property fields
Zor: Thanks for the very prompt and helpful reply. Yes, I do have the relationships defined as one-to-many in the relationship building tool (one is the master, many is the subform). When I use the subforms icon on the tools menu as you suggested, I was able to create a subform, and it...- konacq
- Post #3
- Forum: Microsoft: Access Forms
-
Can't Find "Link Child" and "Link Master" property fields
I am new to sub forms. I created one successfully, and I manually entered the Link Child" and "Link Master" fields, but now the "Link Child" and "Link Master" fields on the sub form's properties are not available. When I created a new subform by dragging a form onto another form, I can't see...- konacq
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
