Recent content by Chateauk

Thank you Pat. Your solution works great.

Your option seems to be working but it's pulling all IPID in the database to the subform. I want the subform to have only the records for the corresponding IPID to appear. Is it doable?

I need help figuring out what I'm doing wrong here. I've created a form called frmAnalystsReviews( Main form on the right) and added a subform called qryMonthlyReviewsSUBFORM (on the left). The subform is just a continuous form of the frmAnalystReviews form. Users will use the single form for...

I do agree with your approach. Thank you

How do I update the vba code to export the query in excel?

My team wants the button to generate an excel spreadsheet instead of them copying and pasting in excel

I've created a button on a form that calls this procedure. How do I update the procedure to open the query in Excel xlsx instead of MS Access datasheet view? Private Sub RunMonthlyReportBtn_Click() DoCmd.OpenQuery "qryMonthlyReport", acViewNormal, acReadOnly End Sub