Forms in ADP behave differently to regular Access

G

Geoffrey King

Form ( datasheet view) created against a table in an Access Project behaves
differently to regular Access. If you sort a column & then start to update
one of the values, Access Project immediately undoes the sort and row
pointer moves you back to unsorted position in the table , whereas in
regular access you can update any value and you stay in same row in table
even though new value may be in wrong position in sorted column.
Access 2000 on XP with SQL2000 DB.
Any ideas?

Geoff
 
V

Vadim Rapp

GK> Form ( datasheet view) created against a table in
GK> an Access Project behaves differently to regular
GK> Access. If you sort a column & then start to
GK> update one of the values, Access Project
GK> immediately undoes the sort and row pointer moves
GK> you back to unsorted position in the table ,
GK> whereas in regular access you can update any value
GK> and you stay in same row in table even though new
GK> value may be in wrong position in sorted column.
GK> Access 2000 on XP with SQL2000 DB. Any ideas?

It was fixed in access 2002.

Vadim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form in Acess Project behaves differently 0
Form filter help with .adp with Access 2003 Runtime 4
Access 2007 ADP and SQL 8
Update trigger works in SQL Server but NOT in Access adp datasheet 5
Total Row in datasheet view has problems if using ADP / SQL 4
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
ADP Form totals causing error 2
Access 2002 ADP & SQL 2005 Views 8

Top