|
| 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. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
December 22nd, 2008, 09:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Why does it keep changing back?
Hello-
Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks! 
|
|
#2
December 22nd, 2008, 10:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
On Mon, 22 Dec 2008 13:46:01 -0800, ZigZagZak
wrote: Hello- Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks! Access version? Have you Compacted and Repaired? What is it doing that convinces you it's not Data Entry? Are you aware that Data Entry means "don't show me any old data, just let me add new records, but show those new records until I close the form"? -- John W. Vinson [MVP]
|
|
#3
December 22nd, 2008, 10:58 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
"ZigZagZak" wrote in message
... Hello- Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks! Exactly how are you changing it? Are you opening the subform separately in design view, changing the Data Entry property manually, and saving it? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#4
December 22nd, 2008, 11:07 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
VER 2003, I don't think I have compacted/repaired this database. What makes
me think that is because the forms properties keep switching from yes to no. And I don't know why. And ya, I know what a data entry form does, I have made several data bases with them in general, just not one that had it as a subform. I might be doing something stupid, so it keeps reseting defaults or something......Not sure "John W. Vinson" wrote: On Mon, 22 Dec 2008 13:46:01 -0800, ZigZagZak wrote: Hello- Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks! Access version? Have you Compacted and Repaired? What is it doing that convinces you it's not Data Entry? Are you aware that Data Entry means "don't show me any old data, just let me add new records, but show those new records until I close the form"? -- John W. Vinson [MVP]
|
|
#5
December 23rd, 2008, 12:51 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
On Mon, 22 Dec 2008 15:07:02 -0800, ZigZagZak
wrote: VER 2003, I don't think I have compacted/repaired this database. What makes me think that is because the forms properties keep switching from yes to no. And I don't know why. Open the database, and select Tools... Options... General. UNCHECK "Track Name Autocorrect Info" if it's checked - this misfeature has richly earned the nickname "Name Autocorrupt". Compact and repair, and try again. This shouldn't be happening but you're not alone... -- John W. Vinson [MVP]
|
|
#6
December 23rd, 2008, 02:41 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
Hi,
If your main form is not data entry, then it may be forcing all subforms into non-data entry. Maybe? Clifford Bass "ZigZagZak" wrote: Hello- Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks!
|
|
#7
December 23rd, 2008, 02:56 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
"Clifford Bass" wrote in message
... Hi, If your main form is not data entry, then it may be forcing all subforms into non-data entry. Maybe? It's a good idea, but it didn't work that way in my tests. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#8
December 23rd, 2008, 05:01 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
I've never actually seen Access change the property in the property box, but
the AllowEdits, AllowAdditions, AllowDeletes and Data Entry properties of a form used as a subform are over-ridden by how these properties are set in the Main form. If Data Entry is set to No on the Main form, in effect it'll be set to No for the subform, because the subform is an object of the Main form. The same thing holds true for the other properties I listed. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com
|
|
#9
December 23rd, 2008, 05:18 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:8f135b01d4df7@uwe... I've never actually seen Access change the property in the property box, but the AllowEdits, AllowAdditions, AllowDeletes and Data Entry properties of a form used as a subform are over-ridden by how these properties are set in the Main form. If Data Entry is set to No on the Main form, in effect it'll be set to No for the subform, because the subform is an object of the Main form. Can you give me a repro scenario? As I said, I tested a form with subform, with the main form's Data Entry property set to No and the subform's Data Entry property set to Yes, and it worked exactly as I expected: main form normal, subform in data entry mode. I tested with Access 2003. Now, if it were the other way around -- main form Data Entry, subform not -- it would certainly look at first sight like the main form was overriding the subform, because every record on the main form would be a new record, so the related records in the subform would have to be new ones. But a little experimentation shows that the subform is not really in data entry mode. The same thing holds true for the other properties I listed. It is true that if the main form's AllowEdits property is set to No, then the records on the subform can't be edited either. But that's not true for AllowAdditions or AllowDeletions. Test it yourself, and tell me if you get different results than I do. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
|
|
#10
December 23rd, 2008, 01:22 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Why does it keep changing back?
Are you trying to do this via code?
I had a similar problem a while back, where I had a subform in continuous mode (AllowAdditions = False), and what I wanted to do was put the subform into data entry mode when the user clicked an "Add" button. What I found was that IAW Access Help, "The DataEntry property has an effect only when the AllowAdditions property is set to Yes" -- HTH Dale email address is invalid Please reply to newsgroup only. "ZigZagZak" wrote: Hello- Getting kinda frustrated with a form...... I have a main form & a subform. The subform I want to be an entry form...but when I put it to "data entry" in the properties, it keeps changing back to not a data entry form.......... WHY???? haha its making me crazy! thanks!
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
