Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 26th, 2015, 12:04 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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!
Reply With Quote
  #2 (permalink)  
Old March 3rd, 2015, 05:18 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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
Reply With Quote
  #3 (permalink)  
Old March 3rd, 2015, 09:02 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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?
Reply With Quote
  #4 (permalink)  
Old March 4th, 2015, 06:04 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:20 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.