If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Strange reset scroll behavior
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! |
#2
|
|||
|
|||
Strange reset scroll behavior
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 "kv" wrote in message ... 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! |
#3
|
|||
|
|||
Strange reset scroll behavior
"Jeff Boyce" wrote: If you wish to rename table fields, you could open the table in design view and change the fieldnames there. 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. 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 |
#4
|
|||
|
|||
Strange reset scroll behavior
"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 "kv" wrote in message ... "Jeff Boyce" wrote: If you wish to rename table fields, you could open the table in design view and change the fieldnames there. 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. 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 |
Thread Tools | |
Display Modes | |
|
|