* BUG * - Datasheet + SubDatasheet fails

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

Just read about (form) datasheet view + subdatasheet, + sign, expanding
subdatasheets, etc.
Just made one.
Placing the subform control in the footer wouldn't work at all (no + sign)
Placing the subform control in the detail section, makes the + sign visible
but when clicking on it to expand the subdatasheet, I get the following
error:
- "The column prefix 'mytablname' does not match with a table name or alias
name used in the query."

Facts:
- the relationship one to many exists;
- the subdatasheet property is set to [Auto] for both tables;
- the link child/master fields have the proper fileds name;


Comments from MS appreciated.


================================================================
Windows XP + SP2
Access 2003 + SP1,
..adp project,
ADO 2.8,
MS-SQL Server 2000 + SP3a
 
Just read about (form) datasheet view + subdatasheet, + sign, expanding
subdatasheets, etc.
Just made one.
Placing the subform control in the footer wouldn't work at all (no + sign)
Placing the subform control in the detail section, makes the + sign visible
but when clicking on it to expand the subdatasheet, I get the following
error:
- "The column prefix 'mytablname' does not match with a table name or alias
name used in the query."
Click to expand...

This is a bug that happens sometimes in subforms and subreports. You can
usually fix the problem by editing the SQL, and removing the table name
qualifier from each expression in the ORDER BY clause. MS says they fixed
this bug, but I still see the problem.
 
This is a bug that happens sometimes in subforms and subreports. You can
usually fix the problem by editing the SQL, and removing the table name
qualifier from each expression in the ORDER BY clause. MS says they fixed
this bug, but I still see the problem.
Click to expand...

Still noticeing too many bugs!

Steve thanks for answering.... BTW do you use any custom control ina access
to have more speed and flexibility, like tree view etc.?
 
Back
Top