C
Colin Small
When making changes to forms, I keep seeing problems relating to names
and/or events that were deleted.
In the most recent problem, I deleted a control for time, because I added it
to the date in the select statment, partly so the records could sort
properly.
1. Instead of "select date, time from ....", I used "select date+time as
datetime from ..... Order By date+time ".
2. I deleted the control bound to time. The query runs fine and when I
viewed the form by itself, it works fine.
3. When the form is used as a sub-form, I get an error - the time field
is not present.
4. If I add time to the query, the sub-form runs OK.
I have looked at all the fields in the form and the VB module, time is not
used anywhere. Yet the error persists. I have also seen this when a form
keeps trying to call an event which is no longer there.
The problem is not this particular example, which can be worked around, but
in other cases where the field been deleted from the table. I know you
could even work around this case by creating spurious field-names, but these
types of workarounds are a descent into spaghetti hell.
This would appear to be the same as the name correction bug in MDB
databases, but I can't find any options to disable the feature for ADP
projects. Neither can I find anything that would let me clear any name
association table, except by starting the form from scratch again and I am
really getting tired of this.
Any light on this issue would be appreciated.
Colin
and/or events that were deleted.
In the most recent problem, I deleted a control for time, because I added it
to the date in the select statment, partly so the records could sort
properly.
1. Instead of "select date, time from ....", I used "select date+time as
datetime from ..... Order By date+time ".
2. I deleted the control bound to time. The query runs fine and when I
viewed the form by itself, it works fine.
3. When the form is used as a sub-form, I get an error - the time field
is not present.
4. If I add time to the query, the sub-form runs OK.
I have looked at all the fields in the form and the VB module, time is not
used anywhere. Yet the error persists. I have also seen this when a form
keeps trying to call an event which is no longer there.
The problem is not this particular example, which can be worked around, but
in other cases where the field been deleted from the table. I know you
could even work around this case by creating spurious field-names, but these
types of workarounds are a descent into spaghetti hell.
This would appear to be the same as the name correction bug in MDB
databases, but I can't find any options to disable the feature for ADP
projects. Neither can I find anything that would let me clear any name
association table, except by starting the form from scratch again and I am
really getting tired of this.
Any light on this issue would be appreciated.
Colin