User Profile

Collapse

Profile Sidebar

Collapse
Steph83
Steph83
Last Activity: Jul 24 '19, 07:39 AM
Joined: Sep 8 '18
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Steph83
    started a topic Include and work with external data
    in Access

    Include and work with external data

    Hello,

    I have trouble with the following problem:

    I have a project database in which I have a main table tblProjects and 3 detail tables tblCosts, tblSchedules, tblProjectEmplo yees. Those tables are linked by the projectID and the information is filled by the user.

    Additionally I have three excel files with projects that are tracked in another tool. These excel files contain the same kind of information...
    See more | Go to post
    • Steph83
      replied to Edit/Add data on multiple related tables
      in Access
      Thank everyone for the support. I will certainly follow the advices, many requirements aren't requirements anymore... As said, I'm beginning, with no background. So it's good to see get advice of how to use and which kind of forms to use different purposes.
      See more | Go to post

        Leave a comment:

      • Steph83
        replied to Edit/Add data on multiple related tables
        in Access
        Hello Phil,

        thanks for your Input. With no Background in Access and programming this Kind of Input is always appreciated.

        The idea of the datasheet was to show a summary of the project with relevant information from the various tables (from details, cost, schedule). And then showing the details on top. It is actually still the idea.

        And for the failure mentioned, I am suspecting that it is showing up,...
        See more | Go to post

          Leave a comment:

        • Steph83
          replied to Edit/Add data on multiple related tables
          in Access
          Hello again,

          thank you both very much for your help. To start with, I don't have any programming Background, which is why I will follow the advice and use the forms I have.

          So my way Forward now is to lock and disable the controls and unlock and enable them through the Buttons "add" and "edit".

          Doing so, I get an error when creating a new record which I don't understand:
          ...
          See more | Go to post
          Last edited by NeoPa; Sep 11 '18, 02:51 PM. Reason: Made pics viewable inline.

            Leave a comment:

          • Steph83
            started a topic Edit/Add data on multiple related tables
            in Access

            Edit/Add data on multiple related tables

            Hello,

            I am new to MS access and having trouble to find a way of managing the following:

            I have a "main table" (tblProjects) and 3 "detail tables" (tblSchedule, tblCosts, tblResources). Those 3 detail tables have the "projectID" as foreign key.

            I have main form (frmProjects) with a subform showing a project overview (datasheet view)on the bottom and a tab control on the top...
            See more | Go to post
            No activity results to display
            Show More
            Working...