联系日期小于开放日期：MS Access 2003 [英] Contact date less than Open date: MS Access 2003

问题描述

嘿帮派！


我相信这很简单，我会在这里找到答案。现在不能这样做，但是当我回到家时>


看起来下面的代码不允许我设置它所以联系日期canot比开放日期小：

展开 | 选择 | Wrap | 行号

解决方案

嘿帮！


我相信这很简单，我会在这里找到答案。现在不能这样做，但是当我回到家时>


看起来下面的代码不允许我设置它所以联系日期canot比开放日期小：

展开 | 选择 | Wrap | 行号

嗨D？k？ll ，
ms访问中的日期字段具有日期组件和时间组件，并且您感觉时间组件的效果。你需要将日期组件分开，你就可以了。使用DateValue函数来做到这一点，例如DateValue（[YourDatefield]）

总是很高兴，puppydogbuddy，怎么样？


我过来报告我可能已经找到了一些东西，但它有一些奇怪的副作用。验证文本和规则：


> V中的日期（）规则删除了我的数据库副本中的所有数据，你对它做了什么？


我毫无疑问错过了什么...


会尝试你的选择，非常感谢！


D？k？ll

总是很高兴，puppydogbuddy，怎么样？


我过来报告我可能已经找到了一些东西，但它有一些奇怪的副作用。验证文本和规则：


> V中的日期（）规则删除了我的数据库副本中的所有数据，你对它做了什么？


我毫无疑问错过了什么...


我会尝试你的选择，非常感谢！



D？ k？ll

嗨D？k？ll，

保持忙碌我看到了！


关于V规则......它说输入的日期必须是>今天的日期.....但我不明白为什么它会删除你数据库中的所有现有数据，除非你的代码中有其他地方的编码删除程序。


在我忘记提及它之前，我相信函数Date（）只对日期组件起作用，因此时间组件在使用Date（）时没有区别。

Hey Gang!

I am sure thi is simple and will find answers here. Can''t do so as of now, but will when I get home>

It looks like below code is not allowing me to set it so Contact date canot be lesser than open date:

Expand|Select|Wrap|Line Numbers

解决方案

Hey Gang!

I am sure thi is simple and will find answers here. Can''t do so as of now, but will when I get home>

It looks like below code is not allowing me to set it so Contact date canot be lesser than open date:

Expand|Select|Wrap|Line Numbers

Hi D?k?ll,

Date fields in ms access have a date component and a time component, andd you are feeling the effects of the time component. You need to separate out just the date component and you will be ok. Use the DateValue function to do that, e.g. DateValue([YourDatefield])

Always a pleasure, puppydogbuddy, how are things?

I was coming over to report I may have found something but it has some weird side affects. The Validation Text, and Rule:

>Date() in V Rule deleted all data in my database copy, what do you make of it?

I missed something no doubt...

Will try your option, thanks much!

D?k?ll

Always a pleasure, puppydogbuddy, how are things?

I was coming over to report I may have found something but it has some weird side affects. The Validation Text, and Rule:

>Date() in V Rule deleted all data in my database copy, what do you make of it?

I missed something no doubt...

Will try your option, thanks much!


D?k?ll

Hi D?k?ll,
Keeping busy I see!

Regarding the V Rule...it is saying the date entered must be > today''s date.....but I can''t see why it would delete all your existing data in your database unless you have a coded delete procedure elsewhere in your code.

Also before I forget to mention it, I believe the function Date() operates only on the date component, so the time component should make no difference where Date() is used.

这篇关于联系日期小于开放日期：MS Access 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！