bizwoman
asked on
Access Report automation stalling
gives this error? What error?!
As David indicated, we'd need to know what error number and description you are receiving and what code is used to perform this action.
Probably this happening due to erroneous/missing data or corruption
At first Compact & Repair your database
then if it doesn't resolve the issue then you need to use the NoData event to log/show the problem
Something like
At first Compact & Repair your database
then if it doesn't resolve the issue then you need to use the NoData event to log/show the problem
Something like
Private Sub Report_NoData(Cancel As Integer)
Msgox "This Report : " &Me.Name & " has NO Data"
End Sub
When the code stops, examine the value of sFileName. You haven't posted the code that calculates the file name and if the filename does not conform to DOS standards, the ouptutto cannot complete.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.