Project translated automatically. Log in or register, to view the original There is a geneological database in Access.It has tables tblIR - a list of people with the number of marriage in which they are born, tblMR - a table of marriage with the ind numbers of husband and wife, and tblCR - the connection of children and parents through marriage in which children are born (the fields tblCR.IDMR and tblIR.IDMRParents) Task 1: Remember all the ancestors of a particular person.For this, the number form (IDIR) is entered and for this number all ancestors are marked in the selected TagN field consistently (you can make a cycle in the macro until the value of tblIR.IDMRParents is not equal to 0).At the same time, in each generation you need to note in the TagN field the tblIR tables of the husband, wife, and then go through him and her ancestors consistently as long as they are in the base (maximum to 25 generations).Task 2: Remember all the descendants of a particular person.Also in the form is entered the value IDIR (predecessors), the field number in which to mark the descendants (TagN), then their descendants are marked by the macros in the fields Tag.You can find descendants by coincidence of tblIR.IDIR and tblMR.IDIRHusb or tblMR.IDIRWife, and then all descendants by number tblMR.MRID (one number tblMR usually corresponds to several children in the tblCR table).In the form you need to make a button to turn all the fields Tag or one of them to clean the fields before the new macro is performed.I can't send the base: it's very large and contains personal data of people.Therefore, I propose to write only macros according to the specified specifications, I will look at them and test them.

Proposals 4 Rejected 1

Vera Molchanova

Winning proposal

1 0

Projects -
Rating -
Rating 103

Budget: 7000 RUB Deadline: 10 days

Hello to you! The task in general is understandable and interesting. I am pleased to take it for me.

Vladyslav Y.

62 2

Projects 64
Rating -
Rating 1 261

Budget: 7000 RUB Deadline: 7 days

Hello to you,
I can choose all of my ancestors for a particular person.
A table with 10 lines of information is required for the test.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

5 proposals 0:36

335 USD
Updating Joomla version

Content Management Systems 26 proposals 5 August

16 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 19 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 20 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD

Yury Mashintsev
Moscow, Russia

Projects 1
Rating -
Rating 202

VBA macros in the Access genealogy base

Client's review of cooperation with Vera Molchanova

VBA macros in the Access genealogy base

5.0

Freelancer's review of cooperation with client

VBA macros in the Access genealogy base

5.0

Vera Molchanova

Vera Molchanova

Vladyslav Y.

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Updating Joomla version

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers