Solved

Subform won't allow additions on MS Access 2010 but will in MS Access 2007

Posted on 2012-04-10
13
940 Views
Last Modified: 2012-04-15
I have an MS Access application that was developed in 2003, then further enhanced in 2007 and now being run on 2010. One of my forms has a subform that in versions 2003 and 2007 will allow additions but when run in MS Access 2010 the subform won't allow additions. Does anyone know what may have changed to cause this odd behaviour and what I can do to fix?
0
Comment
Question by:Rob4077
13 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 125 total points
Comment Utility
Never had this problem with Access 2010. May be you can upload your forms and tables with sample data?
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
Comment Utility
<One of my forms has a subform that in versions 2003 and 2007 will allow additions but when run in MS Access 2010 the subform won't allow additions. >
Please be clear.
How are you adding New records?
    Via a button you inserted? (If so, what is the code)
    Via the built in New record button?
        If so, is the button active, or greyed out.
            If it is active, what happens when you click it?
Any errors?
Record added, but not saved...

Just saying "Subform won't allow additions", does not tell the whole story...

JeffCoachman
0
 

Author Comment

by:Rob4077
Comment Utility
Hi Jeff. Sorry to be unclear. The sub form has the standard access record selectors and a add new record button button at the end of the list of records. When I run the app using 2007 the button is active and works. When I run it on 2010 the button is inactive. I am using the same backend and front end on both.

Based on comments coming back this shouldn't be happening so I will need to completely review my table structures and see if there's something that's creeping through on older versions but being captured by the latest version access.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
Comment Utility
Also is the button "always" greyed out, or only under certain circumstances?
What if you open the subform on its own?

Is this an issue for all users?
For all Computers?

Look for any code that sets "Allow Additions" to False


I am curious as well...

Keep us posted...


;-)

JeffCoachman
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 125 total points
Comment Utility
I have seen others having similar issues with Access 2010.  To help reproduce the issue, do you have the 2010 SP1 update installed?
0
 

Author Comment

by:Rob4077
Comment Utility
I am relieved to hear that others have had similar issues. Unfortunately this user migrated to MS Access 2010 without telling me and I actually don't have MS Access 2010 on my installation so I need to do all my testing remotely on their system. My remote test machine is using version 14.0.6112.5000 (32 Bit). Now that I look at the version information I note that on the test machine they've allocated to me it is an unlicenced version. Not sure if that means there are some limitations. I will have to check all the other machines having this problem to see if any of them have SP1 installed and to make sure they're running licensed versions.

At this stage I am going to assume that the issue is not a known issue with 2010 that is easily fixed and so it will need considerable additional investigation. I am going to a training course all next week and need to spend the next few days preparing for it so I won't have time to review and fix until week after next. I don't like leaving questions open for that amount of time so I think it best if I close out the question now and thank all of you for your support. I will post an update later when I find out the ultimate cause.

Thanks for your kind assistance.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:Rob4077
Comment Utility
Forgot to answer:
>>Is the button "always" greyed out, or only under certain circumstances?
Always greyed out

>>What if you open the subform on its own?
Button is still greyed out

>>Is this an issue for all users?
>>For all Computers?
Only tested on two machines and same problem exists for both

>>Look for any code that sets "Allow Additions" to False
Checked for that and Allow Additions is set to Yes
0
 

Accepted Solution

by:
Rob4077 earned 0 total points
Comment Utility
In case you're wondering, the record source is not a query but just a table
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<Will post the resolution later when I discover it>
Then there was no need to close the question...
0
 

Author Comment

by:Rob4077
Comment Utility
Jeff, only closed it out to avoid keeping a question open and unattended for 2 weeks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<Jeff, only closed it out to avoid keeping a question open and unattended for 2 weeks.>
This is not really a reason to accept posts that do not resolve the issue...
Only close a question if it has been resolved.
Nobody here was rushing you...

Otherwise just ask that the Q be deleted.
0
 

Author Comment

by:Rob4077
Comment Utility
I have left questions open before and after a few days I get advised that I should close the question down or it will be closed for me. I try not to clutter the system unnecessarily.

The answers provided did lead to the solution I needed in the immediate term. I knew I had limited time to look into this but I wondered if there may have been an easy and immediate fix  (e.g. I recently discovered that I simply had to change a setting on another software package I use to make it backwards compatible after an upgrade) and I have no knowledge of the differences between 2010 and 2007 Access. There wasn't but there were a few anomalies for me to look into, i.e. SP1. I asked the user to upgrade immediately but he hasn't replied to me yet either.

 I apologise if my closing the question seemingly prematurely has annoyed you but I think its unfair to leave an open question in the system too long while the person asking finds time to work on the suggestions. I value the support I get from EE Experts too much to add to their annoyance by doing that.
0
 

Author Closing Comment

by:Rob4077
Comment Utility
Thanks to helping me work through this one. Will post the resolution later when I discover it
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now