Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-17-2019, 02:57 PM   #1
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 88
Thanks: 37
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Plus symbol on table

Hi! Here I am again asking for help, I have a little plus sign on my table. It shows on the image attached. When I click it, it says "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables." What does this mean? What do I need to change? Please let me know if I need to upload the db. Looking forward to your help!
Attached Images
File Type: png Capture.PNG (3.9 KB, 30 views)

Mackbear is offline   Reply With Quote
Old 07-17-2019, 03:05 PM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,834
Thanks: 107
Thanked 2,662 Times in 2,435 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Plus symbol on table

The + symbol indicates a subdatasheet. If setup correctly it should open a dependant table with the same ID value. However subdatasheets are not recommended as they are a resource drain and slow performance.
Recommend you remove all subdatasheets.
Click the Home tab on the ribbon then click More on the Records section ...Subdatasheet...Remove
If you really want to use it, go to the Subdatasheet ribbon section then click Subdatasheet again & define the related table to display
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
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.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Mackbear (07-17-2019)
Old 07-17-2019, 03:23 PM   #3
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 88
Thanks: 37
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Plus symbol on table

I see... so i dont really need it but does it mean there is something wrong that i need to fix in my db since it is not showing the subform as it normally should? Since i am getting the error...

Mackbear is offline   Reply With Quote
Old 07-17-2019, 09:54 PM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,834
Thanks: 107
Thanked 2,662 Times in 2,435 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Plus symbol on table

You don't need subdatasheets as they are used when viewing tables.
Users should always interact with forms, never with tables.

The standard method of viewing data in master/child tables at the same time is to use a form and subform.
Use a single form for the master table with a continuous or datasheet subform.
Hope that makes sense.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
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.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Mackbear (07-22-2019)
Old 07-18-2019, 05:03 AM   #5
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,090
Thanks: 24
Thanked 268 Times in 255 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Plus symbol on table

I would investigate why they didn't open, then turn them off. Probably a weird join like Colin mention in post#2.
AccessBlaster is offline   Reply With Quote
Old 07-18-2019, 09:40 AM   #6
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 88
Thanks: 37
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Plus symbol on table

Quote:
Originally Posted by AccessBlaster View Post
I would investigate why they didn't open, then turn them off. Probably a weird join like Colin mention in post#2.
Hello, sorry, I don't know where to check for that, could you tell me what to look out for? Thankss
Mackbear is offline   Reply With Quote
Old 07-18-2019, 11:40 AM   #7
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,090
Thanks: 24
Thanked 268 Times in 255 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: Plus symbol on table

Quote:
Originally Posted by Mackbear View Post
Hello, sorry, I don't know where to check for that, could you tell me what to look out for? Thankss
In design view open the database tools tab, then click the relationships button. Take a screenshot of your tables and post it here. Hopefully someone could see a weird join.

AccessBlaster is offline   Reply With Quote
The Following User Says Thank You to AccessBlaster For This Useful Post:
Mackbear (07-22-2019)
Old 07-22-2019, 12:00 PM   #8
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 88
Thanks: 37
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Plus symbol on table

Quote:
Originally Posted by AccessBlaster View Post
In design view open the database tools tab, then click the relationships button. Take a screenshot of your tables and post it here. Hopefully someone could see a weird join.
Hello I apologize for the late reply, here is the screenshot. thanks much!
Attached Images
File Type: jpg CaptureHelp.JPG (29.8 KB, 10 views)
Mackbear is offline   Reply With Quote
Old 07-22-2019, 12:19 PM   #9
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 408
Thanks: 21
Thanked 88 Times in 87 Posts
mike60smart will become famous soon enough
Re: Plus symbol on table

Hi

Your tblNoticeInfo has the following field set as a Primary Key - EntryID_Info

Is this field set as an Autonumber ?

Your other 2 tables do NOT have any Primary Keys ?

What Data Types are the 2 fields that your Primary Key is linked to?

Last edited by mike60smart; 07-22-2019 at 12:19 PM. Reason: spelling
mike60smart is offline   Reply With Quote
Old 07-22-2019, 12:33 PM   #10
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 408
Thanks: 21
Thanked 88 Times in 87 Posts
mike60smart will become famous soon enough
Re: Plus symbol on table

Hi

Can you upload a zipped copy of the Db?
mike60smart is offline   Reply With Quote
Old 07-22-2019, 12:52 PM   #11
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 803
Thanks: 10
Thanked 162 Times in 156 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: Plus symbol on table

the relationship info is a bit helpful but is not enough. Maybe you have joined a number field to a text in the relationships, or something like that?
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 07-22-2019, 02:46 PM   #12
Mackbear
Newly Registered User
 
Join Date: Apr 2019
Posts: 88
Thanks: 37
Thanked 0 Times in 0 Posts
Mackbear is on a distinguished road
Re: Plus symbol on table

Quote:
Originally Posted by mike60smart View Post
Hi

Your tblNoticeInfo has the following field set as a Primary Key - EntryID_Info

Is this field set as an Autonumber ?

Your other 2 tables do NOT have any Primary Keys ?

What Data Types are the 2 fields that your Primary Key is linked to?
The primary key one is autonumber, while the other two are numbers..
The other two tables data come from data entry... can you work on the stuff even if I strip off all the data on it? I cannot send the copy with the data mostly it is sensitive info... thank you
Mackbear is offline   Reply With Quote
Old 07-23-2019, 12:25 AM   #13
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 408
Thanks: 21
Thanked 88 Times in 87 Posts
mike60smart will become famous soon enough
Re: Plus symbol on table

Hi

Yes if you make a zopy and remove all data we can take a look for you.

mike60smart 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
Linked table with reserved symbol Stillpause Tables 1 01-25-2017 08:06 AM
Doesn't find existing symbol in table CarlRostron Modules & VBA 5 11-02-2013 06:29 AM
symbol on export, require symbol DeanRowe Reports 28 07-10-2008 08:52 PM
Less Than Symbol millertimecu32 Tables 6 05-04-2007 11:26 AM
[SOLVED] What's that little + symbol in a table ? nt7272 Tables 2 01-23-2004 01:09 AM




All times are GMT -8. The time now is 08:22 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