We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub Command73_Click() Dim strSQL As String strSQL = "SELECT FIRST([Group Code]), [Month], FIRST([Quarter]), FIRST([Year]), " & _ "SUM([Gross Sales]), SUM([CM-PY Sales]), SUM([E-Sales]), SUM([Rebateable Sales]), " & _ "SUM([Standard Calc Percent]), SUM([Growth Calc Percent]), SUM([Electronic Calc Percent]) " & _ "FROM tblHistoricSales WHERE [Group Code] = '" & Me.GROUP_CODE.Value & "' " & _ "GROUP BY [Month]" '***The error occurs on the following line: Me.tblHistoricalSales_subform.Form.RecordSource = strSQL Me.Requery End Sub
|Import multiple Excel files to different Access tables (same database) adding an extra column with the Excel`s filename||37||25|
|On form close getting error "the changes you requested to the table were not successfull... duplicate values||3||16|
|Display Excel gridlines when called from Access||7||17|
|Access Report Print Preview locking up the screen||14||12|