User Profile

Collapse

Profile Sidebar

Collapse
Rocky Road
Rocky Road
Last Activity: Mar 13 '07, 03:44 PM
Joined: Nov 26 '06
Location: Boulder, CO USA
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rocky Road
    replied to Timing issues with Access & SQL Server again
    in Access
    Thanks for your help. I found the problem. There was an error in my OpenMyForm Function....
    See more | Go to post

      Leave a comment:

    • Rocky Road
      replied to Timing issues with Access & SQL Server again
      in Access
      Here's the code. Remarked out lines are some of the code I have tried to use to resolve this issue.

      Code:
         '*******
   ' StoredProc set PositionStatus = Previous and PositionEndDate = @PositionEndDate in EmployeePosition
   ' WHERE PositionStatus = Current and EmployeeID = @EmployeeID

   cnn.BeginTrans
   Set cmd = MakeStoredProc("sp_EmployeePosition_UpdatePositionEndDateNStatus_ForEmployeeID")
      ...
      See more | Go to post

        Leave a comment:

      • Rocky Road
        started a topic Timing issues with Access & SQL Server again
        in Access

        Timing issues with Access & SQL Server again

        I'm using Access 2002 as a front end to a SQL Server 2000 database. I Update a status field in a SQL Server table using a parameter based stored proc. Works great. Then in the same sub, I open a popup form to view the record I have just updated.

        If I open the Popup Form automatically in code, the status field is not updated. If I open it from a button on the form, it works great.

        I have tried every trick I know...
        See more | Go to post
        No activity results to display
        Show More
        Working...