Disallowed VBA names

  • Thread starter Thread starter Colin Hammond
  • Start date Start date
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.
 
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.
Click to expand...

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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you Highlight a file name and copy the path and name to avariable using VBA? 4
Prevent PivotTable Overwrite Warning and Disallow Overwrite 0
Run-time error 3426 1
setting a date type field to null 5
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
FieldName Variable in VBA 1
How to refer to a VBA module variable within a report select state 3
VBA to automatically cut, paste entire row based on date input and delete row 0

Back
Top