Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2002
    Posts
    23

    Unanswered: Access Submit Button SQL Insert?

    I have an access db with a form used for entering data. Is there a way a can setup a command button on the form so that when pressed it can execute a sql statement and then enter that information into a SQL server table?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Of course, there's a bevy of possible solutions. Perhaps you could be more explicit...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2002
    Posts
    23
    Lets say I add a command button to the form in design view. How do I attach the SQL command from there?

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    ADODB.command, direct query, adp connection, linked table, ad-hoc ODBC... what are you doing here?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jun 2002
    Posts
    23
    Not sure what you are referring to. There is nothing setup right now.
    I am creating an access db that is going to be available for download from my website. The users then can enter data into a form. When they click the submit button on the access form I want that data that they just entered to go into a SQL Server table that I setup.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Where is this SQL Server? How does it expect to accept incoming connections?

    You've revealed a needle when what we need is the whole haystack...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Jun 2002
    Posts
    23
    Sorry, I have the IP address for the SQL Server.

Posting Permissions

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