I have a form with many buttons & text display objects that use Formulas & Procedures quite extensively.
All was working for the last month or two and then hours ago, nothing seemed to work. The Text Display objects had lookups that weren’t looking up. The buttons has Formulas that were not doing anything.
I found that if I went into an object and add a space at the end and then used the Apply button, that object’s Formula or Procedure would then start working.
As the form has many buttons and Text Display objects, what trick can I use to cause every object to ‘recompile’?
Use the Preference panel’s Recompile Database drop zone to drop the file which will force everything in the file to recompile (even form objects). Check the Help page Recompiling Code under Recompiling with the Preferences Window.
You are a gem Gary. I did check the Help with the word Compile as my search term but this page did not come up as the word Recompiling does not contain ‘recompile’. The resulting pages only spoke of recompiling procedures.
And who would have known there was such a thing! Never had to use it before but it was a very handy item to make use of.
Ouch! I was trying to figure out why a databsae was failing to run as it did quite recently. I had forgotten about the need to recomplie them all. Glad this came up.
I’m glad this worked for you, but it’s very puzzling that you encountered this problem in the first place. I’ve never heard of all of the formulas all of sudden failing like that, and don’t know of any reason why that would or could happen. This was not the purpose for which the recompile feature was added (this is a very recent addition, just a few months ago).