I'm trying to use the MDB database made on one PC at another PC. Access is 97 on both PCs. However, when the script reaches the lines:
Private Sub ProdRunCombo_Change()
If Trim(Left(Me.ProdRunCombo, 1)) = 0 Then
Me.StartField.Enabled = False
an error 'Can't find project or library' appears, and the word 'Left' is highlighted. I assume that the 'Left()' function is not defined in target Access for some reason - I can't view Help on it, although it is listed in Objects list there.
How can this be fixed? Re-link some reference?
P.S. When I compile an MDE at my PC, everything works OK there - but I need an MDB to work.