wedd
12-19-2011, 10:40 AM
Hi experts,
In my visual basic Code doesn't recognise new field names I replaced over old names which I initially used to create by using an update query i.e surname: lastname...everytime I click a button or compile the code the vba code doesn't recognise my new names for some reason. Can this be resolved? If so, how can this be done? Everything was working fine before, but since I changed the names of the fields it displays a compile error...I am very close to finishing a project but it's just a bit of a challenge why it's not recognising my new fields in the code when I changed and updated the queries.:dunno
I am a novice/intermediate user of vba...so any experienced user who's encountered a similar issue..what steps did you take to resolve this and get it to work for you...I am using access 2003 which I then have to adapt it or export it into access 2010. If you know of a guideline, or know websites or other resources that can assist me that would be much appreciated in my learning and understanding of troubleshooting such issues.
Thanks forr your contributions:friends:
In my visual basic Code doesn't recognise new field names I replaced over old names which I initially used to create by using an update query i.e surname: lastname...everytime I click a button or compile the code the vba code doesn't recognise my new names for some reason. Can this be resolved? If so, how can this be done? Everything was working fine before, but since I changed the names of the fields it displays a compile error...I am very close to finishing a project but it's just a bit of a challenge why it's not recognising my new fields in the code when I changed and updated the queries.:dunno
I am a novice/intermediate user of vba...so any experienced user who's encountered a similar issue..what steps did you take to resolve this and get it to work for you...I am using access 2003 which I then have to adapt it or export it into access 2010. If you know of a guideline, or know websites or other resources that can assist me that would be much appreciated in my learning and understanding of troubleshooting such issues.
Thanks forr your contributions:friends: