Results 1 to 3 of 3

Thread: Access Modules

  1. Feb 16th, 2006, 06:22 PM #1
    shane01
    shane01 is offline

    Thread Starter
    Member
    Join Date
    Jul 2004
    Posts
    50

    Access Modules

    How can I use a Microsoft Access Module to run an SQL Update or DELETE statement on a table in the database?

    Shane
    Reply With Quote Reply With Quote
  2. Feb 16th, 2006, 07:05 PM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Access Modules

    Search this forum for ADO and Access. That should give you some pointers.
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. Feb 17th, 2006, 08:01 AM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Access Modules

    VB Code:
    1. Sub RunMySql()

    2.    Dim strSql As String

    3.  
    4.    strSql = "DELETE * FROM tblFOO"

    5.    DoCmd.RunSql strSql

    6. End Sub
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width