Results 1 to 2 of 2
  1. #1
    Bertrand82 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Posts
    48

    Submit and retrieve data in a form


    Hi,

    I have some infomation in a table

    Employee number
    Name
    Adress
    Phone number
    Place of service
    Region

    1. I would like my collegues to be able to open a form (ex infopath or access form)
    2. They enter their employee number in an field.
    3. All ther data appears according to the table
    4. They are able to ONLY change their phone-number and address and submit to the table.

    Thankful for all help.

    Br Bertrand

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,443
    Create a query with [Enter Your Employee Number] in the criteria of the Employee Number field.

    Build a form based on the query. Set the LOCKED property of everything except their phone number and address to TRUE

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

Similar Threads

  1. Replies: 1
    Last Post: 03-09-2012, 07:43 PM
  2. Submit Button In Form
    By smarty84handsome in forum Forms
    Replies: 3
    Last Post: 01-12-2012, 11:17 PM
  3. Record Submit Validation Rule in Form
    By agent- in forum Programming
    Replies: 7
    Last Post: 05-24-2011, 04:03 PM
  4. Replies: 1
    Last Post: 05-17-2011, 05:19 AM
  5. Submit button in access form
    By Melo in forum Forms
    Replies: 2
    Last Post: 09-25-2010, 08:37 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