Hi, I have a macro which automatically populates fields with a future date based on one entry on a form, it has worked fine for over a year and suddenly doesn't recognise the form - error code is 2795. Does anyone have any suggestions? Many Thanks!
Macro stopped working
- Thread starter huntr
- Start date
SpentGeezer
Pure Noobism
- Local time
- Today, 17:09
- Joined
- Sep 16, 2010
- Messages
- 258
What happens if you make a copy of the form and rename it then adjust your code with the new form name?
boblarson
Smeghead
- Local time
- Today, 00:09
- Joined
- Jan 12, 2001
- Messages
- 32,059
Making sure that Name Auto Correct (also known as Name Auto CORRUPT)is turned off.
The form might be suffering from corruption. You can try importing (not copying and pasting, but importing) everything into a new, blank database shell. If that fails or the form fails to import (then it is corrupt) you will probably need to import everything BUT that form into a new, blank database shell and then import the form from a backup that works.
I hope the database is split (backend with tables only and frontend with everything else and a COPY of the frontend is on EACH USER'S machine). If not, it needs to be.
