Hi Richard, your videos are by far the best I have watched on Access, I've gone from complete clueless beginner to building my first access database purely on your lessons.
Thanks so much Richard, I have had this question on my mind for several weeks and you nailed it perfectly for me in this video. I certainly appreciate you and all I continue to learn with Access you are my hero.
Are you spying on me? I feel like you’re spying on me! Every time I run into a problem you come out with a video that’s the exact answer to what I need! Loving your content ^^ thank you so much for all you do!
Thanks for this class its great....but I have one headache > how to I collect invoice payments, able to see invoice balances if paid partial etc please if you can assist
hi Richard - thank you for all the video tutorials! My question is this: I created a continuous form with search boxes as you explained in another video. Works GREAT! I was trying to insert that form (ResearchersListF) as a subform into another form but it doesn't connect the search fields in the query (which references the textboxes in the form e.g. Forms!ResearchersListF!FnameSearch). I get pop ups asking for the values for the search fields whenever it runs the query. the query can't find what it needs. Am I not allowed to use a form also as a subform? I preferred embedding the list of researchers and its search functions into this other form rather than popping open another form/window, but I certainly could if I had to. I hope that makes sense. Basically, can I create a form the relies on a query (as its own form) and also use it as an embedded subform in a different form?
I should clarify - it appears it's just the search that doesn't work. Right now, as an embedded subform, it is passing back the ID of the research I choose if I navigate through the list. But the search doesn't work. When I open the main form, it is asking for the values for all the search box fields. And if I try to search, the pop ups come again. The search works fine with when the form is opened on its own. thanks!
Great Content as always. QUESTION: How can I go about showing outside the subform a DetailSummary where I see All Product Quantity + Name? I tried DetailSummary=[Quantity] & " " & [Name] & " + " in subform footer. And then referenced from parent form with =[frmSubSalesOrders_Details].[Form]![DetailSummary]. The footer field comes out perfectly to from the subform to form. But I cant get the Subform footer to concatenate the Name and Quantity further than the first field from the datasheet subform. Can you think of any way to iterate through the subform datasheet entries whilst concatenating? THANKS!
I liked this code to fetch values from the sub-form to the parent form: Dim valor As String 'Get the value of the "Nº série" field in the subform valor = Me.SubComp.Form.Nº_série.Value ' Assign the value to the "SN" field in the parent form Me.SN.Value = valor
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Hi Richard, your videos are by far the best I have watched on Access, I've gone from complete clueless beginner to building my first access database purely on your lessons.
Thanks so much Richard, I have had this question on my mind for several weeks and you nailed it perfectly for me in this video. I certainly appreciate you and all I continue to learn with Access you are my hero.
Fantastic!
@@599CD Thanks again!!!
Are you spying on me? I feel like you’re spying on me! Every time I run into a problem you come out with a video that’s the exact answer to what I need! Loving your content ^^ thank you so much for all you do!
Always watching... always judging...
Thank you that helped me. Craig
Glad it helped
Nice video. Thank you.
Welcome
Thanks for this class its great....but I have one headache > how to I collect invoice payments, able to see invoice balances if paid partial etc please if you can assist
I cover partial payments in 599cd.com/ACD7
hi Richard - thank you for all the video tutorials! My question is this: I created a continuous form with search boxes as you explained in another video. Works GREAT! I was trying to insert that form (ResearchersListF) as a subform into another form but it doesn't connect the search fields in the query (which references the textboxes in the form e.g. Forms!ResearchersListF!FnameSearch). I get pop ups asking for the values for the search fields whenever it runs the query. the query can't find what it needs. Am I not allowed to use a form also as a subform? I preferred embedding the list of researchers and its search functions into this other form rather than popping open another form/window, but I certainly could if I had to. I hope that makes sense. Basically, can I create a form the relies on a query (as its own form) and also use it as an embedded subform in a different form?
I should clarify - it appears it's just the search that doesn't work. Right now, as an embedded subform, it is passing back the ID of the research I choose if I navigate through the list. But the search doesn't work. When I open the main form, it is asking for the values for all the search box fields. And if I try to search, the pop ups come again. The search works fine with when the form is opened on its own. thanks!
599cd.com/ask
Great Content as always. QUESTION: How can I go about showing outside the subform a DetailSummary where I see All Product Quantity + Name? I tried DetailSummary=[Quantity] & " " & [Name] & " + " in subform footer. And then referenced from parent form with =[frmSubSalesOrders_Details].[Form]![DetailSummary]. The footer field comes out perfectly to from the subform to form. But I cant get the Subform footer to concatenate the Name and Quantity further than the first field from the datasheet subform. Can you think of any way to iterate through the subform datasheet entries whilst concatenating? THANKS!
599cd.com/Ask
I liked this code to fetch values from the sub-form to the parent form:
Dim valor As String
'Get the value of the "Nº série" field in the subform
valor = Me.SubComp.Form.Nº_série.Value
' Assign the value to the "SN" field in the parent form
Me.SN.Value = valor
If it works, it works.
=[Ventas02].Formulario![Texto68] in the parent form or =Formularios![Ventas01]![Ventas02].Formulario![Texto68] in eny other open form
Uhm... OK. :)