E
evilc
I am receiving this error message when trying to run my form:
Run-time error '-2147352567 (80020009)':
The bound or unbound object frame you tried to edit doesn't contain an OLE
object.
Can someone please help? I am creating a database where you use a calendar
to select the start date and end date for various data. Once the dates are
selected the Subform should automatically prefill with the information from
the query it runs then you click the export button to run the macro to export
the data to an Excel spreadsheet but I keep getting this error when trying to
run the form. Somebody, anybody please help. It may help to know that when
I get the error and click the Debug button it highlights this row: Me.
dteDate1 = Date - 1 Here is the Event for the On Load field for the form:
Private Sub dteDate1_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub
Private Sub dteDate2_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub
Private Sub Form_Load()
Me.dteDate1 = Date - 1
Me.dteDate2 = Date
EscalatedEntrySubform.Requery
End Sub
Private Sub Export_Escalated_Call_Data_Click()
On Error GoTo Err_Export_Escalated_Call_Data_Click
Dim stDocName As String
stDocName = "ExportEscalatedCallData"
DoCmd.RunMacro stDocName
Exit_Export_Escalated_Call_Data_Click:
Exit Sub
Err_Export_Escalated_Call_Data_Click:
MsgBox Err.Description
Resume Exit_Export_Escalated_Call_Data_Click
End Sub
Any help you can offer would be greatly appreciated. Thanks in advance.
Run-time error '-2147352567 (80020009)':
The bound or unbound object frame you tried to edit doesn't contain an OLE
object.
Can someone please help? I am creating a database where you use a calendar
to select the start date and end date for various data. Once the dates are
selected the Subform should automatically prefill with the information from
the query it runs then you click the export button to run the macro to export
the data to an Excel spreadsheet but I keep getting this error when trying to
run the form. Somebody, anybody please help. It may help to know that when
I get the error and click the Debug button it highlights this row: Me.
dteDate1 = Date - 1 Here is the Event for the On Load field for the form:
Private Sub dteDate1_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub
Private Sub dteDate2_AfterUpdate()
EscalatedEntrySubform.Requery
End Sub
Private Sub Form_Load()
Me.dteDate1 = Date - 1
Me.dteDate2 = Date
EscalatedEntrySubform.Requery
End Sub
Private Sub Export_Escalated_Call_Data_Click()
On Error GoTo Err_Export_Escalated_Call_Data_Click
Dim stDocName As String
stDocName = "ExportEscalatedCallData"
DoCmd.RunMacro stDocName
Exit_Export_Escalated_Call_Data_Click:
Exit Sub
Err_Export_Escalated_Call_Data_Click:
MsgBox Err.Description
Resume Exit_Export_Escalated_Call_Data_Click
End Sub
Any help you can offer would be greatly appreciated. Thanks in advance.