Thank you for any help in advance.
I have adapted parts of Northwinds along with an old DB. I believe I have included Class Objects, Modules, and class modules in order to do so.
My issue is: I have designed a Sales Report Dialog form much like Northwinds and adapted code for varrious actions. Ex Update, Click etc.
I added two text boxes txtStartDate and txtEndDate. The goal is to run a designed report where records BETWEEN txtStartDate and txtEndDate will be returned.
It appears as though the code sets a value for month, quarter, year = to a number. It also transfers [SalesGroupingField] to the report as orders, suppliers/principals etc. It appears to set values for month, quarter, year based on Combo boxes by Case. Can the same be done with Text Boxes (2)? I have tired for days to work this out based on actual field names, by naming me.txtStartDate and Me.txtEndDate as well as txt.SD and txt.ED. I have also tired to set these using code builder and coping results to the code. My current code attempted to set these values by the TempVars values which are also in the code.
Some one please help direct me how it is best to achieve this and how would be best to transfer the info to the report, ie D......Wrapper, TempVars or by calling out the combo box/ text box. Code below.
I have adapted parts of Northwinds along with an old DB. I believe I have included Class Objects, Modules, and class modules in order to do so.
My issue is: I have designed a Sales Report Dialog form much like Northwinds and adapted code for varrious actions. Ex Update, Click etc.
I added two text boxes txtStartDate and txtEndDate. The goal is to run a designed report where records BETWEEN txtStartDate and txtEndDate will be returned.
It appears as though the code sets a value for month, quarter, year = to a number. It also transfers [SalesGroupingField] to the report as orders, suppliers/principals etc. It appears to set values for month, quarter, year based on Combo boxes by Case. Can the same be done with Text Boxes (2)? I have tired for days to work this out based on actual field names, by naming me.txtStartDate and Me.txtEndDate as well as txt.SD and txt.ED. I have also tired to set these using code builder and coping results to the code. My current code attempted to set these values by the TempVars values which are also in the code.
Some one please help direct me how it is best to achieve this and how would be best to transfer the info to the report, ie D......Wrapper, TempVars or by calling out the combo box/ text box. Code below.
Last edited:
