geekhack

geekhack Community => Off Topic => Topic started by: Voixdelion on Sun, 07 August 2011, 22:48:07

Title: advice on MS Access db? incremental increase default field value possible?
Post by: Voixdelion on Sun, 07 August 2011, 22:48:07

Can I get Access to auto fill an increasing value into a field starting from a number that I specify?  (the field is also my primary key atm, but needn't be)  I want to save myself typing the filename IMG_####.jpg as I enter data to cross index a bunch of photos for a household inventory sheet  - posted the question in Yahoo answers (here) (http://answers.yahoo.com/question/index;_ylt=At_Hcgo5fBRh__IXK9AMtJ0azKIX;_ylv=3?qid=20110807173335AAZW2l1), but while i got a solution for Excel I think I'd rather use the Access db instead since its more flexible once the data is entered.