Disallowed VBA names

C

Colin Hammond

I recently started using VBA and immediately fell into the obvious trap when
trying to record the date a subscription was paid. (I used Date and Sub as
variables). I eventually found out why the code didn't work. My question is
where do I find a list of disallowed variable names.
 
F

fredg

I recently started using VBA and immediately fell into the obvious trap when
trying to record the date a subscription was paid. (I used Date and Sub as
variables). I eventually found out why the code didn't work. My question is
where do I find a list of disallowed variable names.

See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Top