Karen, Don't you remember the tricks Aleksey was showing us with the sys_forms3 table? I think Razzak and John were having fits at the time, worried about all the tech support calls they would get as a result. Try this:
EDIT * FROM sys_forms3 WHERE sys_data CONTAINS 'karenscolumnname' Double-click on the sys_data "blob" cell. Press Ctrl-F, and in the "find" dialog, type karenscolumnname VERY CAREFULLY make the edit you need to, and close the blob editor. (Oh, yes, and back up your forms first!!!) Bill On 2 Dec 2004 at 19:57, [EMAIL PROTECTED] wrote: > When Dennis mentioned this, it reminded me of a question I'd been > meaning to ask. I understand why you'd want to have "custom code" > in the forms rather than a whole bunch of .rmd and .eep programs out > there. But I'm not 100% sure I want to go that way, and here's why.. > I couldn't count the number of times that I had to change a column > name or change its type, or was asked a question of where are all > the places where we update a table in code, etc. With search > utilities it's very easy to search all your .rmd and .eep programs > for occurrences of certain words. With all the code in a form, the > only thing you could do is search the forms table where the data > contains your word, and you'd get a list of forms but you would have > to check every control to find where it might appear in the custom > code! Even if you put every single piece of code in the "custom > form actions" (how many of you are using this feature?), you would > still have to bring up each procedure one at a time to search for > the word. >
