Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-14-2019, 01:39 PM   #1
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 80
Thanks: 36
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Form Field shows #Name?

Hello everyone! Reaching out for help again, I have a form that is based on a crosstab query, and looks like this (Image attached) when the query does not have results for example in "High" column. How do I get it to show nothing if the query has nothing instead of it showing "#Name?"?

Thank you everyone in advance!

Attached Images
File Type: jpg pichelp2.JPG (49.0 KB, 12 views)

Mackbear is offline   Reply With Quote
Old 08-14-2019, 01:42 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,631
Thanks: 38
Thanked 885 Times in 868 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Form Field shows #Name?

Hi. Unfortunately a #Name? error means the reference can't be resolved. So, to avoid it, we'll need a resolvable reference. What is the control source of those controls?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 08-14-2019, 01:44 PM   #3
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 2,032
Thanks: 0
Thanked 487 Times in 483 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Form Field shows #Name?

Is that image a form in Datasheet view?

Specify column headings in the CROSSTAB. Review http://allenbrowne.com/ser-67.html#ColHead

__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Mackbear (08-20-2019)
Old 08-14-2019, 02:01 PM   #4
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 80
Thanks: 36
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Form Field shows #Name?

Quote:
Originally Posted by June7 View Post
Is that image a form in Datasheet view?

Specify column headings in the CROSSTAB. Review http://allenbrowne.com/ser-67.html#ColHead
Hello, the image is already in form view, it is a datasheet form. This is how my query looks like (image attached). I specified the column headings as the Priority field. However if there are no values in the priority, for example, there are no records classified as High priority, then it shows the error #Name?. I want to get It to show nothing if there are no records found under that priority.
Attached Images
File Type: jpg pichelp3.JPG (55.1 KB, 10 views)
Mackbear is offline   Reply With Quote
Old 08-14-2019, 02:05 PM   #5
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 80
Thanks: 36
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Form Field shows #Name?

Quote:
Originally Posted by theDBguy View Post
Hi. Unfortunately a #Name? error means the reference can't be resolved. So, to avoid it, we'll need a resolvable reference. What is the control source of those controls?
The source are fields from a query. The query looks like this (image attached). When the query returns nothing for example there are no records found under High Priority, it shows the error #Name?.
Attached Images
File Type: jpg pichelp3.JPG (55.1 KB, 9 views)
Mackbear is offline   Reply With Quote
Old 08-14-2019, 04:13 PM   #6
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 2,032
Thanks: 0
Thanked 487 Times in 483 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Form Field shows #Name?

I can't see that column headings have been specified as prescribed in the Allen Browne article. Did you review the article and follow the steps outlined? Show your SQL statement for the CROSSTAB.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
Mackbear (08-20-2019)
Old 08-14-2019, 06:57 PM   #7
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,596
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Form Field shows #Name?

right click on each relationship line and choose these:

1. include all records from tbl_noticesinfo and only those records
from tbl_noticereso
where the joined fields are equal.

2. include all records from tbl_noticesinfo and only those records
from PMCList
where the joined fields are equal.

__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
Old 08-20-2019, 12:03 PM   #8
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 80
Thanks: 36
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Form Field shows #Name?

Quote:
Originally Posted by June7 View Post
I can't see that column headings have been specified as prescribed in the Allen Browne article. Did you review the article and follow the steps outlined? Show your SQL statement for the CROSSTAB.
This worked thanks! Just added column headings on the property.... appreciate it!

Mackbear is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Field on Form with Expression that shows number of days overdue but excludes negative frenzied_female Forms 4 01-15-2018 03:40 PM
Web Tables w/lookup - Report shows ID, query shows data mvanella Reports 1 11-15-2012 01:38 PM
When i open the form some field shows #name? meenctg Forms 6 09-27-2012 01:07 AM
Why can Form VBA "see" a field's value but the UI and form reference shows 0 mdlueck Modules & VBA 1 02-01-2012 09:22 AM
Calculated field shows in form, by not in my table chablups Forms 1 04-02-2002 01:32 PM




All times are GMT -8. The time now is 02:15 AM.


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