Computer Learning Zone CLZ Access Excel Word Windows

The main hope of a nation lies in the proper education of its youth

-Desiderius Erasmus Roterodamus
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Courses > Access > Seminars > Genealogy > Lessons
 
Genealogy Seminar

Welcome to the Microsoft Access Genealogy Seminar. Total running time is 8 hours, 12 minutes.


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  

Lessons

Resources

Questions

Post your questions or comments below

 

Genealogy Upload Images   Link 
Ina van Rooyen 
21 days ago
I managed to change my breeding database to the concept of the Genealogy database and it seems to work out much better.
I do have a problem at this stage and I struggle to find where I went wrong. Read More...
Richard Rost
17 days ago
Does this problem occur in my (the sample) database? If it's just in your database that you've built, then you're probably missing an event. Check the OnCurrent event. I believe that's where the picture is swapped when you open the form or move from record to record.
Ina van Rooyen
17 days ago
Thank you for your reply, Richard.  I did not add the current_form event and it is working perfect know.
My other question regarding the search button on the PersonF form, are you looking at that?
Add a Reply
Genealogy Reports Not Updating Upload Images   Link 
Anthony P Mitchell 
2 months ago
Richard, please advise, I have been building a Genealogy Database following your Genealogy seminar. I have an issue which no matter what I do cannot sort out. I have a table with relationships to me for each person. I then built a query that also incorporated the location of the person. I then built a Report that when run shows me the persons full name, ID, the country/county he or she comes from and the relationship to me. The first time the report worked well, then I updated the table and ran the report but the new people did not show in the report. I checked my Property sheets for items to be checked in all my associated tables but do not recognise any issues! I know I have missed some thing but not sure what? please advise, thank you.
Alex Hedley
2 months ago
Does the Query that feeds the Report show data if you open that?
Does it have a Query Criteria that is based on a Form that needs to be open at the same time?
Anthony P Mitchell
2 months ago
Hello Alex, to answer your questions;

Does the Query that feeds the Report show data if you open that?
Yes, it shows data, but the data shown is the data prior to the update. I update the table, run the query to show the new information and the new information is not there, only the old data when I made the table first.

Does it have a Query Criteria that is based on a Form that needs to be open at the same time?
Sorry I do not understand your question. I have a form associated with the Query but it shows only the data prior to the update.
Add a Reply
Genealogy Form Question Upload Images   Link 
Anthony P Mitchell 
4 months ago
Richard, hope you can help? I have been building my Genealogy Database from your "Genealogy Seminar Part 1" which is excellent. I have developed a form "Family Group" which shows the husband, wife and children with their details. the issue I have is some families have e.g. 3 children while some families have 8 or more! How can I set the system up to see only the children that are family, also some people are not married. I want the form to show only the actual family members. Hope you understand it some times is not easy to explain!
Richard Rost
4 months ago
It would be easier for me to help if I can see a screen shot of what you have. But you need some way of indicating who you want to see in your family group. Is there a FamilyID? If not, add one. If so, use that as the link field for your subform.
Anthony P Mitchell
4 months ago
Thank you, Richard, you said the magic word, Family ID. I think I have spotted the problem, I will see if I can sort out the answer, maybe get back to you if I need more help, thank you.
Add a Reply
Conditional Formatting Upload Images   Link 
Anthony P Mitchell 
9 months ago
Hello Richard, another question if I may? In my Genealogy database on the PersonF page I have added a Combo box which shows the relationship of all the individuals to the "Home Person", I am the Home person. So for example when the person page is opened on my Father in the Combo box up comes the word "Father", for the individual Charles, my Granddad comes up in the Combo box, so I can see what relationship every one is to me. Now what I have tried to do is Color Code the individuals in the Combo box to show for example, Descendants, ancestris, Not related etc. but am unable to do this! I am not using VBA and I cannot get this to work, any advice would be appreciated, thank you.
Richard Rost
8 months ago
You shouldn't need VBA to do this, just some conditional formatting. You may need to use an expression though because it sounds like you want to format based on the value in a different column of the combo box (descendant or ancestor). See this video on Conditional Formatting with an Expression.
Add a Reply
Genealogy Database Upload Images   Link 
Anthony P Mitchell 
9 months ago
Dear Richard can you please advise!

I have been progressing through the Genealogy Database, adding members and checking that everything is working. With the exception of the People list all is well, but! Read More...
Richard Rost
9 months ago
Email me your screen shots at amicron@gmail.com and I'll take a look as soon as I have time.
Add a Reply
Genealogy My Documents Upload Images   Link 
Anthony P Mitchell 
10 months ago
Hello Richard, I am getting through building the Genealogy database, struggle sometimes but learning all the time. It is absolutely fantastic just what I have been trying to build for a number of years. I have one question, "My Documents", do I still need to make this an Attachment in my Datebase or a Short Text. I think I have missed some thing? (Sorry)
Richard Rost
10 months ago
You can leave the Documents as attachments if you want. I end up switching the Pictures over to Short Text because it's better that way in the long run (and there's a bug in Access we have to work around). I strongly recommend making EVERYTHING external files and NOT using the attachment type, but if you want to, it's OK for now. I'll be doing more with this in Part 2.
Anthony P Mitchell
10 months ago
Thank you Richard much appreciated.
Add a Reply
Header Control Box Settings Upload Images   Link 
Anthony P Mitchell 
10 months ago
Richard, I must apologise for asking this question, I should know the answer! In a number of your forms, the header control box your text is centralised, for example your form PersonF, and some of your background colours are also changed to black. Are the settings in the property tables, if so where, please give me a clue. Thank you.
Richard Rost
10 months ago
I'm not following you. Could you point out a specific video and time index so I can see what you mean. What do you mean by "header control box?" As far as colors go, no, those are never set in the table. Colors and other formatting are specified in form design.
Anthony P Mitchell
10 months ago
Sorry for my lack of knowledge; Genealogy Seminar Part 1, Video = Calculate Age, Lesson 4. If you look at the form ""PersonF" that is being developed (Time 2:21). the very top section, above the form and page header. How do you centralise the word "PersonF" and how do you change the colour in this section?

Add a Reply
Genealogy Part 2 Features Upload Images   Link 
Alex Hedley 
11 months ago
Add the Map a Location in Access TechHelp to the Person, could register their cemetery plot
Add a Reply
Same pictures with diff names Upload Images   Link 
Juan C Rivera 
11 months ago
Richard I lost something in the Genealogy files when we made the change from attachments to link.  Everything is working fine up to the point in there are no pictures the tree gets refresh but the old pictures remain like it looks for something to put in and when there is no picture it fails to remove the old.  if you did a fix let me know if not where do I go.  I'm on lesson 9 Should I wait to the end and see if this bug was fixed?  asfor the name in the field stay with married.  this will make folks go to the life events... LOL   Read More...
Richard Rost
11 months ago
Pictures: I think this was fixed in lesson 11 with the bug fixes.

Names: I've been using married names in mine and listing maiden names after them. I'm going to add more fields in Part 2 so that you can type in either and if you add a married name it will add that as a life event for you. As I've been using the database more for my OWN personal use, I've come up with lots of enhancements like that which I want to add.
Add a Reply

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access genealogy seminar ancestry family tree  Page Tag: whatsnew  PermaLink