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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problems with entering data into a form



 
 
Thread Tools Display Modes
  #1  
Old August 29th, 2006, 03:36 PM posted to microsoft.public.access.forms
fenrir
external usenet poster
 
Posts: 12
Default Problems with entering data into a form

Hi

I have a simple data entry form with 4 fields. How do i get Access to move
to a new (blank) form when i need to enter a new record? The navigation
buttons are not highlighted etc.

Thanks

  #2  
Old August 29th, 2006, 08:41 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Problems with entering data into a form

On Tue, 29 Aug 2006 07:36:02 -0700, fenrir
wrote:

Hi

I have a simple data entry form with 4 fields. How do i get Access to move
to a new (blank) form when i need to enter a new record? The navigation
buttons are not highlighted etc.

Thanks


Normally, you would simply tab out of the last field in the tab order.
Check the form's Properties to ensure that Allow Additions is set to
Yes; you may also want to set the form's Cycle property to All Records
(the default; someone might have reset it to Current Record).

Do the nav buttons *not work* if you click them?

John W. Vinson[MVP]
  #3  
Old August 30th, 2006, 10:26 AM posted to microsoft.public.access.forms
fenrir
external usenet poster
 
Posts: 12
Default Problems with entering data into a form

Hi John

I checked the properties as you suggested. The Allow Additions was indeed
set to No. However, this hasnt resolved the problem.

I can only tab around my fileds in the current form, and am not able to tab
to next/new record. There are only the "goto first and goto last"
navigation buttons highlighted and they dont work when clicked as there is
only the one record available.

Any other ideas on what Im doing wrong?
Thank you.
mark


"John Vinson" wrote:

On Tue, 29 Aug 2006 07:36:02 -0700, fenrir
wrote:

Hi

I have a simple data entry form with 4 fields. How do i get Access to move
to a new (blank) form when i need to enter a new record? The navigation
buttons are not highlighted etc.

Thanks


Normally, you would simply tab out of the last field in the tab order.
Check the form's Properties to ensure that Allow Additions is set to
Yes; you may also want to set the form's Cycle property to All Records
(the default; someone might have reset it to Current Record).

Do the nav buttons *not work* if you click them?

John W. Vinson[MVP]

  #4  
Old August 30th, 2006, 04:56 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Problems with entering data into a form

On Wed, 30 Aug 2006 02:26:01 -0700, fenrir
wrote:

Any other ideas on what Im doing wrong?


Nope. Can't see the form and don't know anything about its properties.

Clearly whoever developed the form set it up this way (going to some
effort to get around Access' default behavior). Forms don't HAVE the
buttons you describe (they have a navigation bar in the lower left,
with * * type arrow buttons), unless the form designer turned
that feature off.


John W. Vinson[MVP]
  #5  
Old August 31st, 2006, 10:55 AM posted to microsoft.public.access.forms
fenrir
external usenet poster
 
Posts: 12
Default Problems with entering data into a form

The scope has now changed and so ive handed the project back to the
originator.
Thanks for your help with this, much appreciated.





"John Vinson" wrote:

On Wed, 30 Aug 2006 02:26:01 -0700, fenrir
wrote:

Any other ideas on what Im doing wrong?


Nope. Can't see the form and don't know anything about its properties.

Clearly whoever developed the form set it up this way (going to some
effort to get around Access' default behavior). Forms don't HAVE the
buttons you describe (they have a navigation bar in the lower left,
with * * type arrow buttons), unless the form designer turned
that feature off.


John W. Vinson[MVP]

 




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 10:11 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.