2014-08-16, 12:38 #1
- Join Date
- Nov 2002
- London, Gtr London, England
- Thanked 0 Times in 0 Posts
Access 2013: changing field names when there are data macros
I have used Access for years but now have Access2013 and some things have changed. I have an asp db.
I wanted to change the field names. there is a data macro which sets one of the fields. It would seem that now changing the field names doesn't update the field references in the macros. The problem is that I must save the table before updating the macro, on save I get an error because the field referred to doesn't exist, it won't save with an error. This means I can't save the table then update the macro. I think the only way round it is to delete the macro, make the changes then recreate the macro.
It seems ridiculous that I ca't do this and if the macro is large it is an unnecessary waste of time.
Do you agree or is there another way?
Thank you................. liz
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!