User Profile

Collapse

Profile Sidebar

Collapse
bherring
bherring
Last Activity: May 26 '10, 01:17 PM
Joined: May 17 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bherring
    replied to Access command button to invoke a trigger in SQL can it be done
    in Visual Basic
    Thnak you Jim for your work on this. Your explanation makes more sense to me.

    Bypassing the trigger and creating an update procedure by itself,but the part I was missing was the Pass through Query. I have not worked with access in many years and neither has anyone else in our group. We use Microsoft SQL servers and SQL report writers and someASP programming. I was looking for the best way to handle it and my SQL guy said a trigger...
    See more | Go to post

      Leave a comment:

    • bherring
      replied to Data entry from an access form to the CUST_PAYMENT table is not hitting my SQL trigge
      in SQL Server
      trigger will not fire when data inserted in access but does fire when data entered into SQl table
      See more | Go to post

        Leave a comment:

      • bherring
        replied to Access command button to invoke a trigger in SQL can it be done
        in Visual Basic
        Ok TABLES ARE VISITS and CUST_PAYMENTS

        Fields are PAT_ID which is in both tables Total payments in the visit table

        AMNT, TRNSCD, TRNSDT are in the CUST_PAYMENT table. the users will enter the patient ID the amount of the payment the trasnction cod and transaction date to the form in access. once a row has been added to the CUST_PAYMENT table I need the amount of that row to be added to the total payment field of the...
        See more | Go to post

          Leave a comment:

        • bherring
          replied to Access command button to invoke a trigger in SQL can it be done
          in Visual Basic
          I put it hear because my SQL trigger is working after a manual insert on the SQl server. What is not working is that the Access Form data entry is not viewed as an insert by SQL so it is not hitting my trigger. I need to find some code that I can put behind a command button to hit my SQL trigger...
          See more | Go to post

            Leave a comment:

          • bherring
            started a topic Data entry from an access form to the CUST_PAYMENT table is not hitting my SQL trigge
            in SQL Server

            Data entry from an access form to the CUST_PAYMENT table is not hitting my SQL trigge

            I have a form called allpayments that allows for data entry to a table called CUST_PAYMENTS. On the form I only have certain fields from the table. PAT_ID, TRNSDT, TRNSCD, AMNT. now in SQl I have a trigger called add_to_total2.

            The trigger on insert adds the AMNT to the total payment in another table. My issue is when the users enter data into the table. It is being uploaded to the SQl tables via the ODBC connection, but it is not...
            See more | Go to post
            • bherring
              started a topic Access command button to invoke a trigger in SQL can it be done
              in Visual Basic

              Access command button to invoke a trigger in SQL can it be done

              I have a form called allpayments that allows for data entry to a table called CUST_PAYMENTS. On the form I only have certain fields from the table. PAT_ID, TRNSDT, TRNSCD, AMNT. now in SQl I have a trigger called add_to_total2.

              The trigger on insert adds the AMNT to the total payment in another table. My issue is when the users enter data into the table. It is being uploaded to the SQl tables via the ODBC connection, but it is not...
              See more | Go to post
              No activity results to display
              Show More
              Working...