Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 26th, 2015, 12:04 AM
Registered User
 
Join Date: Feb 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error occur when switching form view to datasheet view

Hi everyone,

I'm a new user to Access 2010. I have a problem when switching from a form view to datasheet view in Access 2010. My calculated field appear as '#Type!' and '#Error', which is the control source for the field is from the sub-form. I've working this for few weeks but could not get the solution. I really appreciate if anyone can help me on this.

Thanks!
 
Old March 3rd, 2015, 05:18 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

The short answer is that you will not be able to use datasheet view with your current form design.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
 
Old March 3rd, 2015, 09:02 PM
Registered User
 
Join Date: Feb 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is that mean I need to change my form design and one more thing, when I create a query using that form, the calculated field seems not to be appeared as well. is it due to my form design?
 
Old March 4th, 2015, 06:04 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Yes.

Only very simple forms can be be switch to datasheet view.

In over 15 users using Access I have rarely switch a form to datasheet view.

I find that a properly normalized (well design) database will not display properly if datasheet view from a form design to show related data from multiple tables.

If you can flatten (de-normalize) the data into a single row of a query then you can base the form on that query. This design will allow you to switch the form to datasheet view.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015





Similar Threads
Thread Thread Starter Forum Replies Last Post
reading a dataset into a form in datasheet view jd_erd Access 2 January 29th, 2007 04:26 PM
Re: Add button on a form with datasheet view lxu Access 5 March 8th, 2004 06:19 PM
Datasheet View - Customize Dataman Access 0 February 16th, 2004 02:07 PM





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