Looping Problem - hope it's really basic!
Hi there
I'm not too great on databases but have made a quite simple one to store records of all my photos. All photo records are stored in one table, and they are in batches referred to by set number.
What I would like is a module(?) to run an insert query as many times as I specify so that say 100 records with set number 020 are inserted. I can then flick through these with a form and insert the unique data. I already have the Insert query as I am familiar with MySQL.
So I think I need some kind of looping statement, but having no experience of programming in Access, I'm kind of stuck. Any ideas anyone?
Any help much appreciated
Andrew