比条件格式更深......可能吗？ [英] Deeper than conditional formatting... possible?
问题描述
好的，这里有。
连续表格......可能是访问的最佳功能。唯一的缺点是：在每个记录上进行条件评估的唯一方法是通过条件格式化......这会产生一个问题，因为它非常有限（没有通配符，无法访问格式所在的控件之外的控件） ，不能执行除...以外的评估...大于，小于等等。
有没有办法，即使它涉及通过for循环遍历每条记录，评估甚至参考各个线上的项目...
在某个地方是否有一个数组，其中包含主控件的每个成员？如果我说chkbox.checked = true那么显然所有的复选框都会检查（就像你在连续表格上显示的那么多记录）......这不是我想要的。有没有办法以编程方式只检查其中一个（显然点击它会起作用，但只给出该记录的索引号，即：checkbox [4] .checked = true）？
这是一个例子，如果解决了，我可以很容易地适应我想做的事情：
你有一个连续的形式，一些文本框与他们的数据源设置等...现在在设计模式（你只看到你的''模板''记录），你有一个标签，没有链接到任何东西......只是在其中的静态文本（让我们称之为lblTest）并将其标题设置为''Test''。现在有20条记录......我在这张表格上有20个''行'，每个都有一个标签，上面写着测试。和其他链接文本框中的一堆不同信息...
如果我只是编码... lblTest.caption =" changeme" ...那么所有20个标签都将改为..有没有办法改变，比方说，只有第4行标签的标题？以编程方式不使用条件格式化？
希望这是一个可以克服的障碍，因为它是极其有限的。
Okay, here goes.
Continuous forms... possibly the best feature of access. The only downside is this: the only way to have a conditional evaluation run on each record invididually is by conditional formatting... this poses a problem because it is extremely limited (no wildcards, cannot access controls other than the one the formatting is on, cannot perform evaluations other than the ones give... greater than, less than etc).
Is there a way, even if it involves cycling through each record via a for loop, to evaluate or even reference items on invididual lines...
Is there an array somewhere with each member of the ''master'' control in it? If i say "chkbox.checked = true" then obviously ALL of the checkboxes will check (for as many records as you have showing on your continuous form)... this is not what i''m looking for. Is there a way to programmatically ONLY check one of them (obviously clicking on it would work, but given only the index number of that record, ie: checkbox[4].checked = true)?
Here is an example that, if solved, I could adapt easily to do what I want:
You have a continuous form, some text boxes with their datasources set etc... now in design mode (which you only see your ''template'' record), you have a lable, not linked to anything... just with static text in it (lets call it lblTest) and set its caption to ''Test''. Now there are 20 records... I have 20 ''rows'' on this form and each of them has a label that says "Test" and a bunch of varying information in the other linked text boxes...
if I simply code ... lblTest.caption = "changeme" ... then all 20 labels will change to that.. is there a way to change, say, only the 4th row label''s caption? programatically without resorting to conditional formatting?
Hopefully this is a hurdle that can be overcome because it is extremely limiting.
推荐答案
我不太确定可以实现什么效果，但尝试使用OnCurrent活动。
这应该可以让你格式化个别记录，但我不太确定所有的休息。
玩它，看看你能做些什么。
I''m not too sure what effect could be achieved, but try playing with the OnCurrent event.
This should enable you to format individual records, but I''m not too sure about all the rest.
Play with it and see what you can do.
我的问题是，你如何计算连续形式...可能是最好的访问功能什么时候允许你做任何你想做的事情？对于你所列举的所有原因，连续形式无疑是最糟糕的特征（形式）！
My question is, how do you figure Continuous forms... possibly the best feature of access when it allows you to do nothing that you wish to do? Continuous forms are undoubtedly the worst feature (form-wise) for all the reasons you''ve enumerated!
嗨
如果你想要的话每一行都有不同的标签....
最好的方法是在你的数据库中有单独的字段，即Label1
你可以确定什么信息应该像Label ...
默认情况下你会引入一个值但是如果有一个标签应该不同的记录你改变了字段..
在你想要使用Label Control的Continious表单中，使用被锁定的字段控件，像标签一样填充......并且没有焦点......并且点击这个字段创建一个功能，将焦点设置到要更新的相应字段...
希望这有帮助
Hi
If you want on each row have different label....
The best way is to have separate field in your database ie Label1
There you can determine what information should be like Label...
By default you introduce a value but if there is a record with a label that should be different you change the field..
In your Continious form instaed to use the Label Control use the Field Control that is locked, filled like a label...and don''t has the focus... And on clicking on this field create a function that sets the focus to the respective field to be updated...
Hope this helps
这篇关于比条件格式更深......可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
