Error message help

[ksibly]

I have this error message that started to appear and not sure what caused it or how to fix looking for some help in this. Thanks

[pbaldy]

Those 2 lines need to be one.

[rpeare]

you can't have a formula that's broken up onto separate lines

your line should be something like:

fOSUserName = left(StrUserName, lnglen-1)

[ksibly]

I changed it to fOSUserName = left(StrUserName, lnglen-1) but now when jun it highlights the word left and get the compile error: Can't find project or libary

[rpeare]

I guessed at your missing code. I don't know what was there originally but it looks like someone had a section of code highlighted and hit enter (thereby deleting a bunch of code). You may have had a different function than LEFT in there, it's impossible for me to say what was there before.

If LEFT is the correct function you have to add the reference back in for it to work (TOOLS>REFERENCES in the vb code window). You probably want the microsoft access object library (you'll have to find the appropriate one for your version of access)

[pbaldy]

More info:

Access Reference Problems