Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi



    Here is the Db with the Form Bound to the Table
    Attached Files Attached Files

  2. #17
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2010
    Posts
    209
    Hi - thank you for spending your time to do this.

    When i manually input the manager, hiredate, startingpay, hours - how do I then save that back to the table? (tblUserSocialInfo)

  3. #18
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    I have added a Command Button to Save and Close the Form
    Attached Files Attached Files

  4. #19
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2010
    Posts
    209
    Hi - i get this error. I think you are trying to save back to tblImport1 when I want to save everything but the name to tblUserSocialInfo
    Attached Thumbnails Attached Thumbnails 2020-02-27_16-10-52.png  

  5. #20
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Sorry Try this version
    Attached Files Attached Files

  6. #21
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2010
    Posts
    209
    We are getting closer!!!!

    Where is the default data coming from?

    I only want id and user to be pulled from tblImport1

    The fields manager, hiredate, startingpay, and hours should be coming from tblUserSocialInfo

    Meaning - if the data for the UserID does not exist in tblUserSocialInfo then the form should load with empty values for manager, hiredate, startingpay, and hours

    If the userID does exist in tblUserSocialInfo then the values from that table should load for manager, hiredate, startingpay, and hours

  7. #22
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    The example I have given is how to Bind a Form to a Table.

    As you have not as yet given an explanation of what you are trying to achieve then I can't give an guidance.

    Is tblImport1 a one off Import of data just to list Current Users?

    A more detailed explanation of your process would help everyone.

  8. #23
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2010
    Posts
    209
    I need to be able to get a list of users and userID (tblImport1) for the end user to select from, and input the other fields manager, hiredate, startingpay, and hours

    That's the difficulty i keep running into is that i am trying to load data from one table, and save/load data from a second table as well.

    My brain hurts working on thsi.

  9. #24
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    The example I have given you allows you to select a User from tblImport1

    It also allows you to select a Manangers Name from tblManagers.

    Can you tell us whether the fields HireDate, StartingPay and Hours relate to the User or the Manager??

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 02-15-2019, 08:26 AM
  2. Replies: 1
    Last Post: 07-09-2017, 06:02 PM
  3. Replies: 1
    Last Post: 01-24-2017, 09:50 AM
  4. Replies: 6
    Last Post: 12-15-2015, 04:11 PM
  5. Replies: 3
    Last Post: 07-20-2012, 11:41 AM

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