A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto fill certain fields in a data entry form Access 2003



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2009, 05:30 PM posted to microsoft.public.access.tablesdbdesign
cbianco
external usenet poster
 
Posts: 3
Default Auto fill certain fields in a data entry form Access 2003

I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?
  #2  
Old September 16th, 2009, 05:42 PM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Auto fill certain fields in a data entry form Access 2003

cbianco wrote:
I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?


Set the default value for the control to =Date() and leave it out of the tab
order.

--
Message posted via http://www.accessmonster.com

  #3  
Old September 16th, 2009, 06:12 PM posted to microsoft.public.access.tablesdbdesign
cbianco
external usenet poster
 
Posts: 3
Default Auto fill certain fields in a data entry form Access 2003

Thank you, but that puts today's date which is not necessarily the date I
want to use.

"PieterLinden via AccessMonster.com" wrote:

cbianco wrote:
I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?


Set the default value for the control to =Date() and leave it out of the tab
order.

--
Message posted via http://www.accessmonster.com


  #4  
Old September 16th, 2009, 10:03 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Auto fill certain fields in a data entry form Access 2003

You can set the default of a control in its after update event. Try something
like:

Me.txtDate.Default = "#" & Me.txtDate & "#"

--
Duane Hookom
Microsoft Access MVP


"cbianco" wrote:

I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?

  #5  
Old September 18th, 2009, 07:25 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Auto fill certain fields in a data entry form Access 2003

.... and the date you DO want to use is ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"cbianco" wrote in message
...
Thank you, but that puts today's date which is not necessarily the date I
want to use.

"PieterLinden via AccessMonster.com" wrote:

cbianco wrote:
I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the
date
field.

Any suggestions on how to accomplish this?


Set the default value for the control to =Date() and leave it out of the
tab
order.

--
Message posted via http://www.accessmonster.com




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.