Results 1 to 6 of 6
  1. #1
    GiantFlamingo is offline Novice
    Windows 11 Access 2019
    Join Date
    Feb 2024
    Posts
    4

    Outsourcing

    I can see that this project will make me spread myself so thin there will be nothing left.

    Anyone want a few extra $$$ do setup the DB so I can just start entering the data?

    send me an email:
    suzzyflamingo@gmail.com

    Thank you and have a good day!


    Susan Flamingo

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Amended post below
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    You will likely need to sit down and think of EXACTLY what you want. Then write some sort of specification as to what that is, even if it is in plain english.
    The last thing any developer wants, is a client to keep coming back and saying 'Oh, I forgot, I also need it to do this....'

    Might also be wise to remove your email address, as bots can harvest that and just ask to be contacted by PM. Make sure you allow PMs though.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    GiantFlamingo is offline Novice
    Windows 11 Access 2019
    Join Date
    Feb 2024
    Posts
    4
    I think I know exactly what I want/ Here it is:

    Ok, I will try to explain exactly what I am doing.
    I am constructing a genealogy of scholars over 2000 years of history. Every scholar is in a table tblScholars. Each scholar has one main teacher and any number of "secondary" teachers. I want to choose a scholar like "Isaac Newton" and see that he studied mainly under "Donald Trump" but also under "Joe Biden". If I choose Joe Biden I see he studied mainly under "JFK" but also under "FDR","Margret Thatcher" and "Churchill". As I continue up the tree I can see any and all teachers of the main identity as well as his students. So if I choose "FDR" I see he studied under "Abe Lincoln" and "Harry Houdini", but one of his students was also "Biden" and "Eisenhower and if I choose him I get all that info on him.

    I need the tables queries and data entry forms I add a main Scholar and enter his details, then I choose main teacher from combobox or enter new one (which is added tot eh main tblScholars) I choose however many secondary teachers/mentors as Main students and secondary students.

    Pretty straightforward, right? Anybody game for the challenge?

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    tables are pretty straightforward - you need two

    tblScholars
    ScholarPK
    Scholarname

    tblTeachers
    TeacherPK
    ScholarFK (scholar)
    TeacherFK (link back to scholars)
    TeacherType (primary/secondary)

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    I think I know exactly what I want/ Here it is:
    so no mention of books per your other thread- not really a complete answer to post#3

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums