获取表单中默认值的字段的最后一个条目 [英] Getting last entry of field for default value in form
本文介绍了获取表单中默认值的字段的最后一个条目的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
好的,我知道这很简单,但声明让我不知道...
我有一个日期字段,我希望数据输入表单上的默认值为'br />
日期字段是输入的最后日期。我想我可以用查询来做这件事
但不知道需要的标准是什么。
任何帮助都会受到赞赏,
谢谢
Ok I know this is simple but the statement eludes me...
I have a date field where I want the default value on the data entry form''s
date field to be the last date entered. I figure I can do this with a query
but don''t know what the criteria needs to be.
Any help would be appreciated,
Thanks
推荐答案
David,
输入以下代码在数据日期字段的AfterUpdate事件中
报名表:
我!NameOfDateField.Default =我!NameOfDateField
-
PC数据表
您的资源以获取Access,Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com
" David Messner" < dm@thetechtutor.com>在留言中写道
新闻:EM ************** @ newssvr26.news.prodigy.com ..。
David,
Put the following code in the AfterUpdate event of the date field on your data
entry form:
Me!NameOfDateField.Default = Me!NameOfDateField
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David Messner" <dm@thetechtutor.com> wrote in message
news:EM**************@newssvr26.news.prodigy.com.. .
好我知道这很简单,但声明让我不知道......
我有一个日期字段,我希望数据输入表单'
日期字段的默认值是输入的最后一个日期。我想我可以通过查询来做到这一点
但不知道需要的标准是什么。
任何帮助都将不胜感激,
谢谢
Ok I know this is simple but the statement eludes me...
I have a date field where I want the default value on the data entry form''s
date field to be the last date entered. I figure I can do this with a query
but don''t know what the criteria needs to be.
Any help would be appreciated,
Thanks
这给我一个错误说明......
运行时错误''438 '':
对象不支持此属性或方法
输入的代码为:
私有Sub Date_AfterUpdate()
Me!Date.Default = Me!Date
End Sub
再次感谢您的帮助,
" PC数据表" < SP ** @ nospam.spam>在消息中写道
新闻:IB ****************** @ newsread1.news.atl.earth link.net ...
That gives me a error stating...
Run-time error ''438'':
Object doesn''t support this property or method
Code entered is:
Private Sub Date_AfterUpdate()
Me!Date.Default = Me!Date
End Sub
Thanks again for any help,
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:IB******************@newsread1.news.atl.earth link.net...
David,
将以下代码放在
数据输入表单上日期字段的AfterUpdate事件中:
我!NameOfDateField.Default =我!NameOfDateField
-
PC数据表
您的资源获取Access,Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com
" David Messner" < dm@thetechtutor.com>在消息中写道
新闻:EM ************** @ newssvr26.news.prodigy.com ..。
David,
Put the following code in the AfterUpdate event of the date field on your data entry form:
Me!NameOfDateField.Default = Me!NameOfDateField
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David Messner" <dm@thetechtutor.com> wrote in message
news:EM**************@newssvr26.news.prodigy.com.. .
好的我知道这很简单但是声明让我不知道......
我有一个日期字段,我希望数据条目
表格'的日期字段的默认值是输入的最后日期。我想我可以用
查询来做到这一点,但不知道需要的标准是什么。
任何帮助都将不胜感激,
谢谢
Ok I know this is simple but the statement eludes me...
I have a date field where I want the default value on the data entry form''s date field to be the last date entered. I figure I can do this with a query but don''t know what the criteria needs to be.
Any help would be appreciated,
Thanks
您正在使用保留字(日期)。您不应该使用它们来命名您创建的对象
。你可以看到Access会感到困惑。
看看MSKB文章#109312
- Jim
2004年2月5日星期四22:45:22 GMT,David Messner
< dm@thetechtutor.com>写道:
You are using a reserved word (Date). You should not use them for
naming objects you create. As you can see Access can get confused.
Look at the MSKB article # 109312
- Jim
On Thu, 05 Feb 2004 22:45:22 GMT, "David Messner"
<dm@thetechtutor.com> wrote:
这给我一个错误说明......
运行时错误''438'':
对象不支持这个属性或方法
输入的代码是:
Private Sub Date_AfterUpdate()
我!Date.Default = Me!Date
End Sub
再次感谢您的帮助,
PC数据表 < SP ** @ nospam.spam>在消息中写道
新闻:IB ****************** @ newsread1.news.atl.eart hlink.net ...
That gives me a error stating...
Run-time error ''438'':
Object doesn''t support this property or method
Code entered is:
Private Sub Date_AfterUpdate()
Me!Date.Default = Me!Date
End Sub
Thanks again for any help,
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:IB******************@newsread1.news.atl.eart hlink.net...
大卫,
将以下代码放在
David,
Put the following code in the AfterUpdate event of the date field on your
数据
条目表格的日期字段的AfterUpdate事件中:
我!NameOfDateField.Default =我!NameOfDateField
-
PC数据表
您的资源以获取Access,Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com
" David Messner" < dm@thetechtutor.com>在消息中写道
新闻:EM ************** @ newssvr26.news.prodigy.com ..
entry form:
Me!NameOfDateField.Default = Me!NameOfDateField
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David Messner" <dm@thetechtutor.com> wrote in message
news:EM**************@newssvr26.news.prodigy.com.. .
>好的,我知道这很简单,但声明使我无法...
>
>我有一个日期字段,我想要数据输入表'>上的默认值日期字段是输入的最后一个日期。我想我可以用aquery>做到这一点但不知道需要的标准是什么。
>
>任何帮助将不胜感激,
>
>谢谢
>
>
> Ok I know this is simple but the statement eludes me...
>
> I have a date field where I want the default value on the data entryform''s > date field to be the last date entered. I figure I can do this with aquery > but don''t know what the criteria needs to be.
>
> Any help would be appreciated,
>
> Thanks
>
>
这篇关于获取表单中默认值的字段的最后一个条目的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文