Results 1 to 3 of 3
  1. #1
    sdoyle7798 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Automatically creating new tables

    Hi, all. I should start by saying I have a rudimentary understanding of how to use Access, but I am by no means an expert, or even that advanced with it.

    So, where I work, we keep a running activity log for our calls for service. The program we use to use is no longer supported, and was for individuals. I need to make one that a central dispatcher can use. It would be great if I could have the a new table come up automatically when the current one is used.

    Our old program used to do that. When you first brought up the log, it looked like this:


    Once you began typing in any of the fields, a new table would appear underneath, like this:


    How do I make that second table automatically appear?



    Thank you.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe build a form and set its Default View property to equal Continuous Forms.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It would be great if I could have the a new record come up automatically when the current one is used.
    BTW, the terminology is "record", not "table". "Tables" have "Records"; "Records" are comprised of "Fields".
    You enter info into record that is in a table (or tables), usually using a form as you have displayed.

    If you have a problem and want someone to review your dB, ask the question and maybe post the dB here. Plenty of help is available.

    And welcome to the forum.

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

Similar Threads

  1. Record Creating Automatically
    By baskey in forum Queries
    Replies: 5
    Last Post: 02-06-2014, 10:26 AM
  2. Automatically Creating an Invoice
    By Kelsod in forum Access
    Replies: 8
    Last Post: 05-15-2013, 08:03 PM
  3. Replies: 3
    Last Post: 04-09-2013, 01:39 PM
  4. Automatically update tables
    By jenncivello in forum Access
    Replies: 1
    Last Post: 08-31-2012, 10:13 AM
  5. Creating a Record that automatically adds more records
    By fatimah25 in forum Database Design
    Replies: 5
    Last Post: 08-22-2012, 02:07 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