469,328 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,328 developers. It's quick & easy.

How can I change 'Data entry' property and 'Allow additions' without using VBA

I have an access database with a main form and four sub forms. I can enter data through the forms, and this is fed through to the underlying tables. However, when i close the form and re-open it, I cannot scroll through the form and look at previous records. From some preliminary research I can see that setting the 'data entry' to yes and the 'allow additions' to yes that this should resolve the problem. However, I can't find a way of doing this that doesn't use VBA - is this possible?
Aug 19 '10 #1
9 15464
munkee
374 256MB
Yes, you should be able to to go to the form properties page and under the Data tab they are available. Change data entry to no and allow additions to yes.

Edit:

In response to the information provided by linq you should probably have everything set to yes apart from DataEntry which should be set to no .

So on your data tab have:

Allow edits = yes
Allow deletions = yes
Allow additions = yes
Data entry = no

Setting data entry = yes will only load a new record each time the page is opened. This is often useful when you do not want users to be able to edit/change records but just to supply fresh data.
Aug 19 '10 #2
missinglinq
3,532 Expert 2GB
I can see that setting the 'data entry' to yes and the 'allow additions' to yes that this should resolve the problem
Your interpretation of what you've read is incorrect!

Setting Data Entry to Yes is causing the problem. Forms set like this only allow the entry of new records! They do not allow for the viewing/editing/deleting of existing records!

The Data Entry Property name was a poor choice by Microsoft, as it would seem to indicate that it is necessary in order to enter records, which is incorrect.

Welcome to Bytes!

Linq ;0)>
Aug 19 '10 #3
Hi - thanks for the quick responses!

Unfortunately, when I look at the properties for the form or sub-forms in design, the data tab is blank - is there something I have to do to allow me to view the Data properties?
Aug 19 '10 #4
munkee
374 256MB
Are you sure you are in the form properties page? You may be selectiong a section instead such as the header / detail / footer.

Click on the square section on the top left of the form in design view where the rulers/guides intersect each other so that a black square appears within it. Then right click this and select properties. They should be available from there. This ensures the focus is on the correct form.
Aug 19 '10 #5
Thanks munkee - found it!

I set the Data Entry to yes as you suggested missingling but it hasn't made any difference! Every time I close the form and open it again I can't view the other records that have been entered. Can you suggest any other alternatives?

Thanks
Aug 19 '10 #6
munkee
374 256MB
set these:



Allow edits = yes
Allow deletions = yes
Allow additions = yes
Data entry = no
Aug 19 '10 #7
Excellent! My form is now working - thanks for the help.
Aug 24 '10 #8
munkee
374 256MB
Glad you finally have everything working correctly. Remember to set "best answer" so others who may find the thread in a similar situation can get straight to the answer.
Aug 24 '10 #9
NeoPa
32,181 Expert Mod 16PB
Angeliki:
I set the Data Entry to yes as you suggested missingling but it hasn't made any difference!
To be fair to Linq, he said the exact opposite. Essentially the same as what Munkee said that seems to have helped you resolve the issue eventually.

Welcome to Bytes!
Aug 24 '10 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by edworboys | last post: by
3 posts views Thread by Joe Cajon via AccessMonster.com | last post: by
4 posts views Thread by LFM | last post: by
7 posts views Thread by =?Utf-8?B?QU9UWCBTYW4gQW50b25pbw==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.