UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Option To Choose Index Type Greyed Out, Access 2010    
 
   
Kamulegeya
post Jul 13 2019, 07:29 AM
Post#1



Posts: 1,846
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


Hello Members,

I am trying to create a unique composite index on a table but is greyed out.

I cant do it for any database on this computer.

Any hints on how to enable it?.

See screen shot attached.

I can create it using VBA.
This post has been edited by Kamulegeya: Jul 13 2019, 07:29 AM
Attached File(s)
Attached File  unique_index.png ( 160.68K )Number of downloads: 14
 
Go to the top of the page
 
ADezii
post Jul 13 2019, 08:05 AM
Post#2



Posts: 2,535
Joined: 4-February 07
From: USA, Florida, Delray Beach


What other Field beside [StaffID] is involved in the Unique Composite Index?
Go to the top of the page
 
GroverParkGeorge
post Jul 13 2019, 08:13 AM
Post#3


UA Admin
Posts: 35,502
Joined: 20-June 02
From: Newcastle, WA


It's not clear from the screenshot what you intend.

Here's a quick review of how you go about creating ANY index, including a composite.

The Index NAME column is the name by which you refer to the index. The Index FIELD NAME column is where you specific the fields in the table to include in that index.

It looks like you provided a name, stUnique, but there are no fields selected to be IN that index. So, is that the problem? You can't select the Fields to be in the Index?

You can't provide an index type until you tell Access which field(s) are going to be included in that index.

BTW. A composite Index has the name on the top row of that index, with the name column for additional fields left blank, next to the selected Field.

Attached File  CompositeIndex.jpg ( 138.15K )Number of downloads: 1

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
ADezii
post Jul 13 2019, 08:42 AM
Post#4



Posts: 2,535
Joined: 4-February 07
From: USA, Florida, Delray Beach


I have provided a visual on how a Unique, Composite, Non-Primary Index would look like on the [StaffID] and [AllowancesProcessTypeID] Fields. The existing Primary Key is listed in the Indexes Dialog by default.

@GPG:
Sorry, just realized how close my explanation was to yours. shrug.gif
This post has been edited by ADezii: Jul 13 2019, 08:46 AM
Attached File(s)
Attached File  Index.JPG ( 39.06K )Number of downloads: 0
 
Go to the top of the page
 
GroverParkGeorge
post Jul 13 2019, 09:04 AM
Post#5


UA Admin
Posts: 35,502
Joined: 20-June 02
From: Newcastle, WA


Great minds, etc.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
pere_de_chipstic...
post Jul 13 2019, 10:42 AM
Post#6


UtterAccess Editor
Posts: 10,497
Joined: 8-November 07
From: South coast, England


PMFJI

Looking at the attachment in Ronald's post it looks as if the drop down boxes to change the Primary, Unique and Ignore Nulls settings are not visible.

Try making the form wider by dragging the right hand edge and they should appear.

hth

--------------------
Warm regards
Bernie
Go to the top of the page
 
Kamulegeya
post Jul 14 2019, 07:58 AM
Post#7



Posts: 1,846
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


pere_de_chipstick,

Your suggestion solved it.

uarulez2.gif
Go to the top of the page
 
pere_de_chipstic...
post Jul 15 2019, 02:21 AM
Post#8


UtterAccess Editor
Posts: 10,497
Joined: 8-November 07
From: South coast, England


yw.gif

Good luck with your project. thumbup.gif

--------------------
Warm regards
Bernie
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th August 2019 - 08:12 AM