Hi,
I'm using Access 2010(32-bit) on a Win 7 Pro box. Been using this a number of years and never had this problem before; or any problem I couldn't resolve in Access or Excel.
I went to the immediate window and typed =currentdb.version. At first when I typed the period, the context menu popped up but immediately disappeared. If it disappeared before I typed the v, it didn't complete the word "version". So I completed the word and hit enter. I then received the dreaded error msg: Compile error: Expected line number or label or statement or end of statement.
This happened time and time again (what did someone say?: Doing the same thing over and over and expecting a different result is the definition of insanity. LOL)
Anyway, I compacted and repaired the DB; same result. So I rebooted the PC. Again, same result.
One other thing that's happened: If I tried creating a new subroutine in a Module, when I typed the word "Sub", then hit space to give it a name, the cursor immediately went back to after the "b" in Sub turning the word Sub red and effectively removing the space I had typed. If I then type a name immediately after the "b" in Sub I can then move the cursor between Sub and the name and then I'm able to enter a space, at which time the parens are added after the name and also the "End Sub" line.
Can anyone suggest a course of action? I'm scratching my head on this one.
Thanks,
Vic
I'm using Access 2010(32-bit) on a Win 7 Pro box. Been using this a number of years and never had this problem before; or any problem I couldn't resolve in Access or Excel.
I went to the immediate window and typed =currentdb.version. At first when I typed the period, the context menu popped up but immediately disappeared. If it disappeared before I typed the v, it didn't complete the word "version". So I completed the word and hit enter. I then received the dreaded error msg: Compile error: Expected line number or label or statement or end of statement.
This happened time and time again (what did someone say?: Doing the same thing over and over and expecting a different result is the definition of insanity. LOL)
Anyway, I compacted and repaired the DB; same result. So I rebooted the PC. Again, same result.
One other thing that's happened: If I tried creating a new subroutine in a Module, when I typed the word "Sub", then hit space to give it a name, the cursor immediately went back to after the "b" in Sub turning the word Sub red and effectively removing the space I had typed. If I then type a name immediately after the "b" in Sub I can then move the cursor between Sub and the name and then I'm able to enter a space, at which time the parens are added after the name and also the "End Sub" line.
Can anyone suggest a course of action? I'm scratching my head on this one.
Thanks,
Vic