停止重复

pitchID = 1和ScheduleDate = 26/02/07以及 pitchID = 1和ScheduleDate = 27/02/07可以，但 pitchID = 1和ScheduleDate = 26/02/07以及 pitchID = 1和ScheduleDate = 26/02/07也不行。 我想我会在更新程序之前在ScheduleDate上需要一个宏但不确定。 任何想法。谢谢 ATC 解决方案 在更新之前，无论是通过宏还是通过代码，您都需要： 展开 | 选择 | Wrap | 行号 感谢您回复兔子。 我现在有了这个代码 展开 | S选举 | Wrap | 行号 尝试： 展开 | 选择 | Wrap | Line编号 Hello.OK im new to VBA and access and need a bit of help.I have a subform with the fields pitchID and schedule date.I need to stop the user from entering duplicates. By this i meanpitchID = 1 and ScheduleDate = 26/02/07 along withpitchID = 2 and ScheduleDate = 26/02/07 would be ok pitchID = 1 and ScheduleDate = 26/02/07 along withpitchID = 1 and ScheduleDate = 27/02/07 would be ok but pitchID = 1 and ScheduleDate = 26/02/07 along withpitchID = 1 and ScheduleDate = 26/02/07 would not be ok. I think i will need a macro on the ScheduleDate before update procedure but am not sure. Any ideas. ThanksATC 解决方案 In the before update, either through a macro or through code, you''ll need: Expand|Select|Wrap|Line NumbersThanks for your reply rabbit. I now have this code Expand|Select|Wrap|Line NumbersTry : Expand|Select|Wrap|Line Numbers 这篇关于停止重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！