Run-time error 2147352567 (80020009)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

command not working 7
Runtime Error 4
Error -2147352567 (80020009), Access 2007 0
Error 2147352567 2
How to make one button to update 3 queries 9
Run-Time Error 2766 3
Report VB Code 1
Error with no value 2

Top