Results 1 to 2 of 2
  1. #1
    duhvorak is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2

    How to Take Multiple User Inputs From a Form To a Table

    Been Playing around with the INSERT INTO and UPDATE commands, along with the APPEND button and PARAMETERS in creating a query.



    How can I take the user input for several variables and insert them into a new row?

    EDIT: Possibly better off in the Query Forum, Put it here because of the Form aspect. Mods feel free to correct if necessary.

  2. #2
    duhvorak is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2
    All I really need is to make a new row instead of overwriting all rows.

    PARAMETERS [input] Text ( 255 );
    INSERT INTO Room ( RoomNum )
    SELECT Room.RoomNum
    FROM Room;

    keeps throwing primary key violation errors to as many rows as i have on the table. RoomNum is my key.

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

Similar Threads

  1. Multiple Table query
    By bibbyd01 in forum Queries
    Replies: 1
    Last Post: 10-06-2009, 09:12 AM
  2. Multiple inputs one result
    By ee12csvt in forum Queries
    Replies: 0
    Last Post: 09-11-2009, 03:19 AM
  3. Replies: 3
    Last Post: 06-01-2009, 01:41 PM
  4. Possible to store user-defined types in table?
    By Binky in forum Programming
    Replies: 0
    Last Post: 11-20-2008, 02:28 PM
  5. multiple user database on a network
    By felo in forum Access
    Replies: 1
    Last Post: 05-27-2006, 06:17 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