field name issue / split dB

[gmaccess]

Newbie here: I created a dB with serveral forms given to different areas
wihin my POB to input data which then populates one main table. Its been up
and running for a few weeks with no problems. I need to make some tweaks and
have code that I want to add. Its seems that I created a bad situation by
naming a critical field "Loan #" instead of "LoanNbr". The code won't accept
my naming and I really need to make changes involving this field. Is there
any way I can correct w/o causing major issues? I am using access 2000 and my
dB is split into a front and backend. Thanks in advance to whomever responds!

 

[Allen Browne]

Try adding square brackets around the field name in your VBA code, macros,
or SQL statements, e.g.:
If Me.[Loan #] = 999 Then

You can rename the field in the back end, but of course you then have to
find every place where the name is used. This utility by Chas Dillon might
help:
Renaming fields and tracing dependencies
at:
http://allenbrowne.com/ser-41.html

 

[gmaccess]

I tried [Loan #] in VBA code as you suggested and it works!!
Thanks for this and the link to the renaming utility!!

Try adding square brackets around the field name in your VBA code, macros,
or SQL statements, e.g.:
If Me.[Loan #] = 999 Then

You can rename the field in the back end, but of course you then have to
find every place where the name is used. This utility by Chas Dillon might
help:
Renaming fields and tracing dependencies
at:
http://allenbrowne.com/ser-41.html

Newbie here: I created a dB with serveral forms given to different areas
wihin my POB to input data which then populates one main table. Its been

[quoted text clipped - 9 lines]

dB is split into a front and backend. Thanks in advance to whomever
responds!