VBA error

[Me]

Hi!
I want to know why vba codes in access crash after short time.
for example i have used a Left() function to retrieve the first two
characters of a record.
it works but after some days VBA prompts : variable or function not found.
plz let me know why.

 

[Scott McDaniel]

1) Check your references and make sure none are marked MISSING. If they are,
uncheck them, close the dialog, then reopen it and find that reference and
recheck it.
2) Your database may be corrupted. Make a copy (do that NOW) and try
importing all your objects to a new, blank database.