>I am running an app that uses an alias to refer to a table. When I run a report I want to check and make sure that a file is open and the alias is being used else show a message box saying that a file is not open. If it is, then the report should run. I have tried quite a few ways to get this done, but with no luck. The alias is the cause of my trouble. If it were just a filename, I could do this. Any ideas?
Did you know the ALIAS?
You probably tryed this:
IF USED([ALIAS HERE])
report
ELSE
MessageBox([No alias])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
