Incorrect error Handling

**AnthonyWB** · 05-25-2011, 11:44 AM

I have some error handling code that is supose to halt or termintate the program in the case that a file cannot be found - this would happen if the date extension of the file does not exist for the date the user selected via the date picker for a textbox. Unfortunately it does not work correctly and causes the code to run continuously without stopping ( a loop).

Please see the error handling below, for any suggestions:

Please Login or Register  to view this content.

Sub

**davegugg** · 05-25-2011, 02:53 PM

Take out the on error resume next line.

**AnthonyWB** · 05-25-2011, 03:22 PM

Thanks Dave for suggestion. But that does not work.

**davegugg** · 05-25-2011, 03:48 PM

Also take out the Resume line. Do you know how Resume works? If not, you need to read up on it before you use your code. It is a dangerous way of ignoring errors instead of really dealing with them.

**AnthonyWB** · 05-25-2011, 03:55 PM

Dave thanks. I got rid of both lines you said. it still does not work. All I want to do is check to see if the file exist. If it does not a prompt error message should pop-up.

**davegugg** · 05-25-2011, 04:03 PM

You can check if a file exists using the dir function:

Please Login or Register  to view this content.

**AnthonyWB** · 05-26-2011, 11:22 AM

Dave thanks. It's not really working, but I am getting closer. It pops up even if the file exist? Not sure whats wrong here.

Please Login or Register  to view this content.

**davegugg** · 05-26-2011, 11:26 AM

I'd suggest putting a code break (click a red dot onto the left margin) on the If Dir(... line. Then when the code runs, it will stop before executing that line. Next while still in debug mode, go to the immediate window and type Print strFullFileName. Press enter and this will show the path the database expects the file to be at. Next using the windows explorer go to the actual file, copy the path and paste it into the immediate window to compare the two strings. Do they match exactly?