>Is there any way to stop visual foxpro to bring up the dialog box prompting you to select a table when File is in use or other error messages?

You can trap any error
ON ERROR DO processerror()
and replace it with custom on, but in most cases you can just remove the source of error, e.g.
IF USED("mytable")
Select mytable
Endif