数据表冻结列和标签 [英] Datasheet Freezing Columns And Tabing
问题描述
嗨
我有一个32列的数据表，前两列是冻结的
和禁用。我想做的是当一个用户选项卡通过一行
在工作表上是将工作表移到左边，所以它成为第一个
列旁边的冻结列（第3列），如果用户
返回标签，则表格将向右移动。我现在正在通过
将列的列宽设置为
宽度为10并且当焦点重置后重新设置列宽
到正常尺寸。有没有办法在没有设置和
重置列宽的情况下执行此操作？我现在也可以改变列的顺序，但是我试图避免这种情况。提前谢谢
求助。
Hi
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it becomes the first
column next to the frozen columns ( column 3 ), also if the user
back tabs the sheet would shift to the right. I am doing it now by
setting the columnwidth of the column being tabbed out of to a
width of 10 and when it gets focus resetting the columnwidth back
to its normal size. Is there a way to do this without setting and
resetting column widths? I now I can also change the order of
the columns but I was trying to avoid that. Thank you in advance
for your help.
推荐答案
只是一个风格评论。假设这是一个数据表/连续视图
您的表单（并且数据输入应该仅通过表单）那么32绑定
控件很多。为什么要让用户选项卡/平移/滚动所有这些？为什么
没有弹出单个记录样式表单，可以按照你想要的顺序显示所需的所有字段
？
-Ed
< fh *** @ aol.com在留言新闻中写道：eU **************** @ newsfe12.lga ...
Just a style comment. Assuming that this a datasheet/continuous view of
your form (and data entry should only be through forms) then 32 bound
controls is a lot. Why make the user tab/pan/scroll through all those? Why
not pop-up a single record style form that can display all the fields that
you want, in the order that you want?
-Ed
<fh***@aol.comwrote in message news:eU****************@newsfe12.lga...
嗨
我有32列的数据表，前两列是冻结的
和残疾人士。我想做的是当一个用户选项卡通过一行
在工作表上是将工作表移到左边，所以它成为第一个
列旁边的冻结列（第3列），如果用户
返回标签，则表格将向右移动。我现在正在通过
将列的列宽设置为
宽度为10并且当焦点重置后重新设置列宽
到正常尺寸。有没有办法在没有设置和
重置列宽的情况下执行此操作？我现在也可以改变列的顺序，但是我试图避免这种情况。提前谢谢
的帮助。
Hi
I have a datasheet with 32 columns, the first 2 columns are frozen
and disabled. What I would like to do is as a user tabs thru a row
on the sheet is to shift the sheet to the left so it becomes the first
column next to the frozen columns ( column 3 ), also if the user
back tabs the sheet would shift to the right. I am doing it now by
setting the columnwidth of the column being tabbed out of to a
width of 10 and when it gets focus resetting the columnwidth back
to its normal size. Is there a way to do this without setting and
resetting column widths? I now I can also change the order of
the columns but I was trying to avoid that. Thank you in advance
for your help.
嗨Ed，
数据一次输入1列，每列表示单个作业的单个作业，数据是该作业的工作时间，因此数据是按行而不是按行输入的。当操作员完成
a''作业/时间'表时，他们会水平滚动到下一个作业栏（
可能是下一列的顺序与否）制作它第一栏
旁边的冻结列，我想通过使用
选项卡为他们做这个，我还想设置一个热键，可以选项卡到下一个
列并将它们返回到工作表的第一行。谢谢。
Bob
Hi Ed,
The data is entered 1 column at a time, each column represents a
single job, the data is the time worked on that job, so the data is
being entered by column not by row. As the operator completes
a ''Job/Time'' sheet they horizontally scroll to the next job column (it
could be the next column in order or not ) making it the first column
next to the frozen columns, I would like to do that for them by using
the tab, I would also like to setup a hot key that would tab to the next
column and return them to the first row of the sheet. Thank you.
Bob
究竟如何在Access中一次输入一列而不是
一次一行？
fh***@aol.com 写道：
Exactly how, in Access, do you enter records one column at a time rather than
one row at a time?
fh***@aol.com wrote:
>嗨Ed，
数据一次输入1列，每列代表一份
单一工作，数据是该作业的工作时间，因此数据是按行而不是按行输入的。当操作员完成工作/时间工作表时，他们会水平滚动到下一个工作栏（它可能是下一列的顺序与否），使其成为第一列
在冻结的列旁边，我想通过使用选项卡为他们做这个，我还想设置一个热键，它将标签到下一个
列并将它们返回到第一行的表单。谢谢。
鲍勃
>Hi Ed,
The data is entered 1 column at a time, each column represents a
single job, the data is the time worked on that job, so the data is
being entered by column not by row. As the operator completes
a ''Job/Time'' sheet they horizontally scroll to the next job column (it
could be the next column in order or not ) making it the first column
next to the frozen columns, I would like to do that for them by using
the tab, I would also like to setup a hot key that would tab to the next
column and return them to the first row of the sheet. Thank you.
Bob
-
总是有不止一种方法来换肤了cat！
基于Access 2000的答案/帖子
http://www.accessmonster.com/Uwe/For .. .ccess / 200612/1
--
There''s ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1
这篇关于数据表冻结列和标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
