Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    9

    Unanswered: Need Help with DoCmd.RunSql

    I would like an example of an SQL statement using the DoCmd.RunSQL to insert values into the tables from the form. Do you Have exampless of updating multiple tables too? Any help would be appreciated.

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi cristy

    Welcome to the forum.

    You will want to run some sort of DML action statement (like this or this) or DDL (like this) although Access DDL is rarely used and can be a bit fiddly.

    Check out RunSQL in Access help too.

    You can update multiple tables - just include the relevent tables in the SQL statement, ensuring you join them appropriately.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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