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  dBforums > PC based Database Applications > Microsoft Access > Data-Entry property not working

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
Data-Entry property not working

I have set a form's data entry property to "yes" but it is still only showing the current records and not even allowing me to create a new record, why?
Reply With Quote
  #2 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,079
is the underlying recordset updateable
is it a query or table
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
It is an updatable table
Reply With Quote
  #4 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
It's an obvious question, but is the Form's AllowAdditions Property set to 'Yes?'

Also, is this a 'free-standing' Form, i.e. not one being used as a Subform?

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
Yes it is.

it is a form with a sub-form in it. However I have also set the sub-form to have data-entry too and still no luck.
Reply With Quote
  #6 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
Quote:
Originally Posted by kkid View Post

...I have also set the sub-form to have data-entry too...
This sounds as if you have the Data Entry Property on the Main Form set to 'Yes,' as well! If that's true you need to change that, on the Main Form.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
I want both the main form and sub-form to have data-entry.

nevertheless, I still tried setting the main form's property to No and the issue still occurred.


The Sub-form is acting as a data-entry form perfectly fine but it is just this main form which is acting up. It still displays record "1 of 6" at the bottom and the new record button is greyed out.
Reply With Quote
  #8 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
Quote:
Originally Posted by kkid View Post

...I want both the main form and sub-form to have data-entry...
Two things:

First, you do understand, do you not, that having Data Entry set to 'Yes' is not necessary in order to Add/Edit Records, correct? Data Entry, set to 'Yes,' allows you to only Add New Records. Adding Records only requires that the Recordset be updatable and having the AllowAdditions Property set to 'Yes.

Secondly, it sounds as if your Main Form is Read-Only. Is it based on more than one Table? Many multi-table Queries are Read-Only. For the reasons have a look at Allen Browne's article on the subject:

Why is my query read-only?

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
Thank you for all of your help. Your suggestions did help me but it was for a slightly different reason in the end.

I have managed to (Kind of) get it to work now.


I do have one issue though. My sub-form works when not used in the main form (i.e. it works when standalone). But when placed into the sub-form, the combo-box disappears.

Also, how do I get rid of the annoying graphics on my sub-form? I want it to be pure white but access will not allow me to get rid of it.


DB is attached
It is the AddNewBooking and AddNewBookingSUB forms which are causing the issues.
Attached Files
File Type: zip Database.zip (1.53 MB, 8 views)
Reply With Quote
  #10 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
Once again, you have to set the Data Entry Properties on both the Main Form and the Subform to 'No!'

And in order for you to add Records to the Subform, the AllowEdits Property of the Main Form must be set to 'Yes.'

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
oh, no, sorry, it wasn't like this. I turned it off to test something and never switched it back on.
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
Does anybody know why the subform doesn't work and.or how to get it with no graphics?
Reply With Quote
  #13 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
Quote:
Originally Posted by Missinglinq View Post

Once again, you have to set the Data Entry Properties on both the Main Form and the Subform to 'No!'

And in order for you to add Records to the Subform, the AllowEdits Property of the Main Form must be set to 'Yes.
If you follow these instructions the Subform will work!

If you don't want the graphics, go into Design View and select the item and delete it.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #14 (permalink)  
Old
Registered User
 
Join Date: Aug 2012
Posts: 70
ah, it was the allow edits that I wasn't doing, thanks


The graphics still won't budge though, I cannot get rid of it on the sub-form - even through design view
Reply With Quote
  #15 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,478
I'm confused as to exactly what you're doing with the Subform, as you have no Controls on it! Is this a Template that you downloaded and are trying to modify? Unless you have a specific reason for using a Continuous Form, you can get rid of the graphics by simply changing the Form the Subform is based on to a Datasheet View Form.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On