L
Larry12
Hello everyone,
i am trying to portate a Jet-Based Db-Application to SqlServer/AccessAdp.
the datastructure is complete normalized, and i am heavly using subforms to
display all splitted informations.
now i have reached a "stuck"-point, and am wondering if anyone would be so
kind to give me a hand with it:
i would like to sort the data in the subform,
the form uses a Sql-Statement as recordsource, including an "ORDER BY" -
phrase
this works fine as long the form is opened on its own, but if its opened as
a linked subform i recive an error message telling me that
"the column prefix <name of the sub form> can not be found in any of the
query tables or aliases"
i tried to drop the "ORDER BY" phrase from the Sql-Statement and use the
form property OrderBy instead, but this helps only in some cases,
i also tried to bind the subform to a view, which already included a "ORDER
BY", with the same unsatisfying result: only some forms allow me to display
its content ordered.
is it possible that this is an AccessProject (Adp) - weakness, or should i
try some other Sql-Server objects like RowsetFunctions?
could anyone help me on this
i would be very gratefull,
oh, by the way, i have the same effects using Access XP as 2003
i am trying to portate a Jet-Based Db-Application to SqlServer/AccessAdp.
the datastructure is complete normalized, and i am heavly using subforms to
display all splitted informations.
now i have reached a "stuck"-point, and am wondering if anyone would be so
kind to give me a hand with it:
i would like to sort the data in the subform,
the form uses a Sql-Statement as recordsource, including an "ORDER BY" -
phrase
this works fine as long the form is opened on its own, but if its opened as
a linked subform i recive an error message telling me that
"the column prefix <name of the sub form> can not be found in any of the
query tables or aliases"
i tried to drop the "ORDER BY" phrase from the Sql-Statement and use the
form property OrderBy instead, but this helps only in some cases,
i also tried to bind the subform to a view, which already included a "ORDER
BY", with the same unsatisfying result: only some forms allow me to display
its content ordered.
is it possible that this is an AccessProject (Adp) - weakness, or should i
try some other Sql-Server objects like RowsetFunctions?
could anyone help me on this
i would be very gratefull,
oh, by the way, i have the same effects using Access XP as 2003