MS Access Help

[kosandpol]

ow ban..eeka mata kalin hambuna..but eke 1st step eka awul ban....autonumber field eka delete karanna denne na..primary key eka nisa...

key එක අහක් කරන්න. ඊට පස්සෙ මකන්න

 

[delmar]

key එක අහක් කරන්න. ඊට පස්සෙ මකන්න

hmm..eeke thiyana widiya hari yanne na ban..ane manda

 

[NO_MeRcY]

mokakda Office version eka?

 

[NO_MeRcY]

ආ! මේ දීලා තියෙන්නෙ කලින්ම..

 

[delmar]

mokakda Office version eka?

2010 ban

 

[NO_MeRcY]

Mulin dunna link eke hariyata steps tika thiyanawa.Malli uba okkoma records ayn karala table eke design view ekata gihin ID column eka uda right click karala Primary Key kiyana option eka select karala primary key ekak karapan.E field eke properties pahala pennay. eken balanna auto increment properties ubata configure karathaaki .

 

[NO_MeRcY]

ehema hari yanne nattam menna me query eka run karapan

ALTER TABLE YourTable ALTER COLUMN YourField COUNTER(1,1)

YourTable kiyana thanata oyage table name eka daanna
YourField kiyana thanata Auto Increment wena field eke name eka danna


Counter eken oyata 1st increment number eka change karanna puluwan
100 idan patan ganna nam COUNTER(100,1)

1 indan patan ganna nam COUNTER(1,1)

 

[delmar]

Problem Solved
thank you very much machanla....
7+ all