The main form has a button to find a record. I have a subform on the main form that has vba code to open a recordset and show a list of records. I would like that to happen when I click on the button on the main form.
I just need the code to be able to reference the vba in the subform from the main form so it will run.
Main form name: frmMain
Subform name: frmFCDBHeader
The code that needs to be called n the subform is: Public Sub FCDB()
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…