Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2023, 03:49 AM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Angry How to remove PK icon from table

By default next to the PK attribute in a table the key icon is showing. Can anyone help me to disable this so it doesn't show the icon, just the PK letters to show next to the attribute name.

There must be a setting somewhere.

Thanks all.
Reply With Quote
  #2  
Old 02-08-2023, 02:54 PM
Guessed's Avatar
Guessed Guessed is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You need to attach a sample file that includes this so we can see what you are talking about.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-09-2023, 06:29 AM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default Picture attached

Please see the picture attached.
Attached Images
File Type: png pk icon.png (5.7 KB, 8 views)
Reply With Quote
  #4  
Old 02-09-2023, 01:14 PM
Guessed's Avatar
Guessed Guessed is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It looks like the shape is similar to the database entity shapes shown in this video
https://www.youtube.com/watch?v=Z3uTWpuv54U
There is instructions in that video that show how to change the primary key which are probably directly relevant to what you are wanting to do.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 02-09-2023, 01:40 PM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default No luck

All videos I've seen on YouTube don't have this key icon against the PK of the entity. I have added another picture to show the difference.
Attached Images
File Type: png pk icon.png (53.6 KB, 7 views)
Reply With Quote
  #6  
Old 02-09-2023, 01:44 PM
Guessed's Avatar
Guessed Guessed is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm pretty sure it will work the same way. Did you click on that attribute so that it is sub-selected and then right click it?

I can't investigate a screen capture - you need to post an actual Visio file if you want someone here to provide specific instructions. We don't have the same entity shape that you do and it may have features we haven't seen before.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 02-09-2023, 02:01 PM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default Visio Document

I have attached a Visio document with the problem. I was not allowed to upload the .vsdx file so I renamed it with extension .txt. Please rename back to .vsdx and you should be able to open in Visio 2016.
Attached Files
File Type: txt PK Icon Test.txt (31.0 KB, 2 views)
Reply With Quote
  #8  
Old 02-09-2023, 11:06 PM
Guessed's Avatar
Guessed Guessed is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Yes, the symbol is different but the behaviour is the same.

Watch the video this time - the solution shown around the 9 to 10 minute mark is EXACTLY the same method to remove the Primary Key symbol and PK letters.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #9  
Old 02-10-2023, 02:57 AM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default

Hi

Thanks for your feedback so far.

I don't want to remove the PK letters, that is fine. It's the icon that I want to remove, the picture of a key.

The PK letters have to stay as this indicates primary key. It's just the the picture of the key that I want to be removed.
Reply With Quote
  #10  
Old 02-10-2023, 03:00 AM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default

I am not worried that the PK letters are slightly different, just want to get rid of the picture of the key.
Reply With Quote
  #11  
Old 02-12-2023, 05:16 PM
Guessed's Avatar
Guessed Guessed is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

OK, to get rid of the key image, it is easiest to make it non-visible. It will still be there but that won't matter if it is set to be hidden. That way you will have the option to make it visible again if you change your mind.

To do that, you need to decide what you are going to change. You could change one instance but it would make more sense to change either the instance in the document stencil or in the stencil you chose it from in the first place. Let's make the assumption you are changing the instance in the document stencil - this will change all the instances already in your document.

In the stencils list go to More Shapes > Document Stencil.
Right click on the shape called Primary Key Attribute and choose Edit Master > Edit Master Shape. This opens a new window with the key symbol beside a PK and attribute name.
Click on the key shape twice so the selection handles ONLY show the key shape selected. Then right click it and choose Show Shapesheet
Find the Geometry 1 section and the field called Geometry1.NoShow. Change its value to =True
Close the shapesheet
Close the Primary Key Attribute window - You will be asked if you want to update the shape and all of its instances - click Yes.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #12  
Old 02-13-2023, 08:34 AM
suhelchoudhury suhelchoudhury is offline How to remove PK icon from table Windows 10 How to remove PK icon from table Office 2016
Novice
How to remove PK icon from table
 
Join Date: Feb 2023
Posts: 7
suhelchoudhury is on a distinguished road
Default

Fantastic, thank-you so much for your instructions. It has worked.
Reply With Quote
Reply

Tags
icon, pk, primary key

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove PK icon from table how to remove the refresh icon from the save icon in the quick access toolbar in word 2013 wondermuse Word 5 12-20-2016 10:48 AM
How to remove PK icon from table QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action ElfegoBaca Word 1 08-13-2016 08:42 PM
How to remove PK icon from table Insert Object into Word Document only appears as Icon, without selecting display as Icon Simy Word 1 04-30-2015 12:47 PM
Remove Skype icon in word docs CodeShredder Word 3 04-23-2013 06:58 AM
sort & filter icon not available or icon not highlighted survivo01 Excel 1 08-08-2011 03:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft