Joined today

[wingers]

Hi everyone !

I'm Alan, from Suffolk, England, in the UK. I'm an inexperienced and infrequent Access user but only use from time to time for very simple tables.

I am a civil engineer by profession but will be retiring in 1 year (if I last that long !), and hope to develop my MSaccess skills to help construct a database to hold my many family history records and references.

A general sports fan and have followed Tottenham Hotpur since as early as I can remember, having been born within earshot of White Hart Lane, "the world famous home of the Spurs".

I enjoy photography and woodwork, music and music creation too. I hope Access can help me out?

cheers for now and happy databasing !

Alan

 

[pbaldy]

Welcome Alan!

 

[Uncle Gizmo]

Hi Alan welcome to AWF.
I read about the project you want to do with MS Access namely create a genealogy database. I recollect some distance knowledge, namely that MS Access isn't considered suitable for use as a genealogy database. I can't remember why, and I'm not 100% sure if it's true. But I have this hunch if you like or it's one of those facts I have filed a way without actually knowing if it's true or not. So I would ask a few more questions before you get too far into your project because I have this niggly feeling that there are some issues.

cheers Tony...

 

[Uncle Gizmo]

I think I found the root of my concern, but it was 10 years ago, so it may not be relevant today. See this thread for further information:- Genealogy relationships

 

[wingers]

Hi Tony,
Thanks for the note but believe I didn't fully explain matters. I don't wish to record the people in the family tree, that's all supported in the GEDCOM genealogy database. Its the supporting information files that I have that I wish to record, e.g. census forms, photographs etc. I have hundreds of them from all over the UK and worldwide, so when adding another photograph to the db, i'd use a form, that would have a number of data entry points, county, town, parish, road, surname, christian name, occupation, date.

I won't want to have to laboriously type in say the town "Newcastle-under-Lyme" every time I make a new entry for that place, I'm asking whether MSaccess is smart to recognise that when I begin to type "Ne", it offers me (in a dialogue box, say?) to pick from all the towns the db holds beginning with "Ne", so if I had 3 or 4 towns starting Ne, it would suggest or offer me those towns to "pick" to enter it. If Neath, Neesdon, Newcastle-under-Lyme, Newmarket, Newquay.

Similarly, not all the photographs I'll have are of people called Wingfield (my surname). there are others, Brotherstone, Jones, Llewellyn, etc. so when adding a new image record into the db, if a wingfield photo is already recorded, when I begin to type in wi, it identifies all the names that begin wi, withers, williams wingfield etc. and I can pick on the relevant word.

the photo's location in my computer will be enetered into the db with a hyperklink reference.


please let me know if I am asking for something access doesnt support?

chaeers

alan

 

[pbaldy]

I moved the thread out of the introductions forum since it now has technical content.

A combo box can jump to the items like you describe. I think it's the default.