Error in Update Query Syntax

[Killer42]

Since I am unfamiliar with VB6(?) syntax, I'm defering it off to the rest of you.

Two question, for the OP...

1. Are we dealing with VB6? We don't know what version it is yet.
2. Is the "ONE OR MORE ARGUEMENTS ARE MISSING" a runtime or compile error?
   If runtime, then it's probably the databsae engine complaining, so the VB version would be irrelevant.
   Note, if the single quotes made a difference, I'd say we're dealing with a database issue rather than VB.

[QVeen72]

Hi Killer,

I had got a PM from OP and it is not VB6, it is VBA

Regards
Veena

[lotus18]

Hi Killer,

I had got a PM from OP and it is not VB6, it is VBA

Regards
Veena

Hello

Could anyone explain to me what does the OP means?

[QVeen72]

Hi Lotus,

I guess OP means "Originally Posted"...

Regards
Veena

[lotus18]

Hi Lotus,

I guess OP means "Originally Posted"...

Regards
Veena

This is only a guessed and you are not sure. I think you are right. (LOL) But anyway thanks for replying : ) Have a nice day Veena.

Rey Sean

[CyberSoftHari]

Veena guess is correct.
Note: This shows both of you never read Posting guidelines.

[Plater]

Hello

Could anyone explain to me what does the OP means?

Original Poster
It gets used to help avoid gender mix-ups when using "he/she, him/her his/hers"