Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 1st, 2006, 11:54 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default subform update problem

Hi,

I am having problems with updating my database from a subform derived from a Query. It worked fine before and previous versions work fine also. But all of a sudden editing just suddenly isnt allowed. I made sure in the properties on the form/subform that 'Data Entry' = Yes, 'Locked' = No, 'Enabled' = Yes
But its still not allowing data to be edited. (Data can be edited in main table when opened).

Any help, suggestions or advice would mostly be appreciated, Thank you for your time.

Derek

 
Old February 1st, 2006, 03:38 PM
Registered User
 
Join Date: Jul 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This has to be a problem with MS Access. I am also having the same problem; I opened a subform that I was able to edit last week but all of a sudden it wouldn't allow me to enter any information since yesterday. I have searched everywhere with no help. Let's hope someone out there will be able to help us.

Good luck!
 
Old February 1st, 2006, 04:04 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

If the data is not sensitive and either of you would want to send me an email with the database attached in zip file, I would be happy to see if I could figure anything out.

My address is mike-at-echovue-dot-com

Mike

Mike
EchoVue.com
 
Old February 1st, 2006, 04:16 PM
Registered User
 
Join Date: Jul 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Mike. I will email you the database.

 
Old February 1st, 2006, 10:55 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Derek and CMensah,

I've had the SAME problem with one database in particular, Have lost about 12 forms over the past 2 months. When a subform dies, it's query works, the tables are fine, Data Entry and Enabled = True, Locked = no, etc., etc.....

Have given up on trying to figure out WHY it has been doing it, but I now I make a copy for archive both BEFORE and AFTER I make changes. When one of the subforms (or forms) goes, I just import a working copy from the last working archive copy and dump the copy of the form that is not working.

There's been other issues going on with my VBA/Access and I assumed this horrid "feature" was part of them(but if other people are having the SAME problem perhaps not)Our Tech is supposed to rebuild and reinstall my system. I'm using A2k- what about you both?

Loralee


 
Old February 2nd, 2006, 05:16 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi all
Thanks for taking time to reply. Im very sorry to hear that you all have the same problem without any solutions to it.

I have however found the cause of my problem. The Query!
Data was editable until I added and extra field to the subform, hence Query. And after adding this table, the data is no longer editable in the subform or Query itself in Datasheet view. When that table is removed, everything is fine.

Does anyone know why this is?

That table (Requests) exists with a one-many relation with the Users table.

Thank you for your time and Help

Del

 
Old February 2nd, 2006, 05:18 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry Loralee,

I am using Access '03, but the .mdb is in 2000 format.

Del

 
Old February 2nd, 2006, 08:47 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi again...

After doing some reading on SQL/Query updates I have got my forms/subforms to allow update now based on the Query. The cause of my problem was beacuse the SQL design had more than 3 tables that had a one-to-many relationship. The solution is to change the 'recordset type' property on the form.
from 'Dynaset' > 'Dynaset (Inconsistent Updates)'

Im not sure what implications this will have as the word 'Inconsistent' doesnt sound too good for the DB. But anyway, I went ahead and data editing works fine now.

Hope this helps.

Del

 
Old February 3rd, 2006, 01:22 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Well congratulations on figuring it out. Wish mine was the same. :(
Loralee






Similar Threads
Thread Thread Starter Forum Replies Last Post
Update field on all selected records in a subform S300570 Access 1 January 14th, 2008 02:19 PM
Subform Record Saved, Update/Requery Form controls CB-VTXer Access VBA 2 August 6th, 2007 02:35 PM
Update Subform Devilboy13 Access VBA 15 December 21st, 2006 01:44 PM
Update subform results? dstein4d Access VBA 0 February 8th, 2006 05:23 PM
auto-update multiple records in subform stoneman Access 1 February 8th, 2004 12:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.