Strange reset scroll behavior

  • Thread starter Thread starter kv
  • Start date Start date
K

kv

I created my Access database by copying data from an Excel spreadsheet. I'm
now editing the field names so they make better labels. Each time I make an
edit, the table view scrolls back to the front of the table. To get to the
next of my 30 fields, I have to scroll to the right again. Edit, view jumps
back to begining, re-scroll. Very tedious!
 
If you wish to rename table fields, you could open the table in design view
and change the fieldnames there.

NOTE: if your table has 30 fields, there's a possibility that it isn't
particularly well-normalized (this is also a possibility because you copied
data from Excel, which is unlikely to be well-normalized). So what, you
ask? So Access' relationally-oriented features and functions work best with
well-normalized data.

If you insist on feeding it 'sheet data, both you and Access will have to
work overtime to overcome the fact that Access is not optimized for the kind
of data you're feeding it.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff Boyce said:
If you wish to rename table fields, you could open the table in design view
and change the fieldnames there.
Click to expand...

Thanks Jeff, I found that workaround and realized it solved my problem nicely!
If you insist on feeding it 'sheet data, both you and Access will have to
work overtime to overcome the fact that Access is not optimized for the kind
of data you're feeding it.
Click to expand...
Umm, it was the first thing mentioned in the Access on-line training from
MS, so I didn't realize it was such a sin! I am in the process of breaking
the data into smaller tables -- haven't figured an easy way to do this yet.
kv
 
"sin" may be too strong a term ...

but think about this, you can probably drive nails with a chainsaw ...
neither safe nor a particularly smart use of the tool ... and you and the
tool both have to work at it!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top