Link to home
Start Free TrialLog in
Avatar of bizwoman
bizwoman

asked on

Access Report automation stalling

We have an Access database that sends out pay stubs every week.  All of a sudden it stops and gives this error.
We end and start again, and it runs.  We cannot figure out why it is doing this randomly.

How do we prevent it from doing this?

User generated image
User generated image
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

gives this error?  What error?!
Avatar of Daniel Pineault
Daniel Pineault

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
Private Sub Report_NoData(Cancel As Integer)
Msgox "This Report :  "  &Me.Name & " has NO Data"
End Sub

Open in new window

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 TRIAL
Members 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.