Results 1 to 4 of 4
  1. #1
    nasim is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    2

    how create an access form with having joined tables fields

    Hi guys
    I have at least 3 relates tables in my access database.the first(sessions) table stores session detailes like id,date,time


    the second one (tblemployees) contains our employees details like name, idp ,the third (attreq) relates the first table to second it stores ids of sessions and ids of personals that which determine which personals have attended in special sessions.
    now,my problem is that I want when a personnel log in and opens "confirmed session"form ,the access check and open records that this person have attended.
    how can I do it

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    One way like:

    DoCmd.OpenForm "form name", , , "EmployeeID = " & Me.EmployeeID
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nasim is offline Novice
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    2
    no ,I want show session details for special person ,that have log on if he has attended in session

  4. #4
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Did the suggestion from june7 not work?
    Please explain what the problem was.

    Dale

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

Similar Threads

  1. Duplicate records in joined tables
    By msmithtlh in forum Programming
    Replies: 2
    Last Post: 04-10-2013, 08:19 AM
  2. How to create using the fields from two tables?
    By Allen1892893 in forum Access
    Replies: 1
    Last Post: 03-31-2013, 07:29 PM
  3. Multiple Tables Joined ????
    By Ekim in forum Database Design
    Replies: 10
    Last Post: 01-15-2012, 07:08 PM
  4. Replies: 3
    Last Post: 07-16-2010, 12:32 PM
  5. Replies: 5
    Last Post: 08-07-2009, 05:23 PM

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