Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2011
    Posts
    45

    Unanswered: Two Tables in One form

    i know this problem is a bit old for may user of this site but i think i got nobody to ask this question. Am just hoping i could get a help from you guys.

    I just recently learned ms access and am trying to create a queing system for our transaction area. The thing is i want to get this two tables merged into one form. I just want to look it more decent and professional, not to mention that not most of my co worker doesnt know how access work. I just wanna know, is it possible to make the two tables working independently in one form. Attached is my sample project. Thank you very much.(=
    Attached Thumbnails Attached Thumbnails queingsystem.JPG  
    Last edited by dennis_ian; 10-17-11 at 02:33.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You simply need to create a query that will join information from both tables. This query then becomes the RecordSource of the form.

    If there is no logical relationships between the rows of both tables, the technique is slightly different:
    1. Create a bound form for each table.
    2. Create a form that will act as a container for the 2 forms created in 1.
    3. Include both bound forms in the form created in 2 as subforms.
    Have a nice day!

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Why not create subforms/child forms on the main forms and hide the bits that make the form look like msaccess Form

    The main form does not point to a table but the subforms can point to difference tables
    Last edited by myle; 10-17-11 at 05:14. Reason: Spelling
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Oct 2011
    Posts
    45
    Hi Sinndho and Myle. Thank you for the suggestion. Am trying it now. Hope this time it will work. Appreciate your help!

  5. #5
    Join Date
    Oct 2011
    Posts
    45
    I Finally got it, thank you so much friends...but i have another problem. How can i make the text blink or flash with another color whenever i click the button NEXT, then make the blink stop after 10 seconds?

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    new problem, new question/ new thread please
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Oct 2011
    Posts
    45
    ok healdem. Thank u for the reminder.(=

  8. #8
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Oops ! Moved to a new thread.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •