Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-17-2011, 10:11 AM   #1
kfschaefer
Newly Registered User
 
Join Date: Oct 2008
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
kfschaefer is on a distinguished road
Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007

I am in the process of validating my Access 2003 database and the functionality working in the new Access 2007 environment w/o converting to 2007 - will have mixed environments for awhile.

The forms within the AK3 version work perfectly, however not in Ak7. When I open the form with the multiple subforms in AK3 if functions correctly, but for some reason when the same form/subforms open in AK7 the subform (datasheet view) will only display 1 record when it should be multiple records. When I view this subform outside of the Main form/Subform it displays the data correctly. The Query returns the correct records etc.

Does anyone know why this is happening?

Thanks,

Karen

kfschaefer is offline   Reply With Quote
Old 06-17-2011, 12:27 PM   #2
Jeanette Cunningham
AWF VIP
 
Join Date: Aug 2010
Posts: 245
Thanks: 0
Thanked 45 Times in 44 Posts
Jeanette Cunningham will become famous soon enough
Re: Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007

I don't know of any quick way to fix this.
I suggest that you make a copy of the form and the subforms for testing.
Try testing with only one subform at a time in the main form - see if you can get it working correctly with just one subform.
You may need to create a new form for testing - remove all code on that form that is not needed to get the subform to display correctly.
When the subform is displaying correctly - maybe you need to remove all code from the subform while you are testing - see if it still works after you add the code back in.
Jeanette Cunningham is offline   Reply With Quote
Old 06-17-2011, 04:09 PM   #3
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,312
Thanks: 11
Thanked 719 Times in 669 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007

I saw a post by Allen Browne the other day about a similar problem. I don't run Access 2007/2010, and so can't check this, but apparently there is a new Property for Forms named Filter On Load. Check it for the errant Subform and if set to Yes change it to No.

If set to Yes it automatically applies a previously saved filter the next time the Form opens, giving unexpected results at times.

Linq ;0)>

__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
Reply

Tags
access 2003 & 2007

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 vs. Office 2007 Ray Stantz Modules & VBA 5 05-19-2011 07:38 AM
Link Excel to Access DB problem,Office 2007 fibayne Theory and practice of database design 5 01-19-2011 10:12 AM
Access 2007 and Access 2003 Outlook email problem hardrock General 3 02-02-2010 10:12 AM
Access problems converting from Office 2003 to 2007 fARRELLMJ General 1 11-28-2007 09:58 AM
Can Office Access 2003 Runtime-Based Solutions applies to Access 2007? pond105 General 1 01-29-2007 08:10 PM




All times are GMT -8. The time now is 03:23 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World