User Profile

Collapse

Profile Sidebar

Collapse
rk2008
rk2008
Last Activity: Mar 26 '08, 11:00 PM
Joined: Mar 26 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rk2008
    started a topic How to open two instances of a Form and select record
    in Access

    How to open two instances of a Form and select record

    Hi,
    I'm using following code to select a record on a form from dropdown list and I'm using MSSQL ODBC linked tables inside MS Access:
    Code:
    Private Sub cboFind_AfterUpdate()
  Dim strCriteria As String
  Dim rst As DAO.Recordset
 
  Set rst = Me.RecordsetClone
   strCriteria  = "[EmployeeID] = " & Me![cboFind]
 
  rst.FindFirst strCriteria
  Me.Bookmark = rst.Bookmark
    ...
    See more | Go to post
    • rk2008
      replied to Finding a Specific Record Programmatically
      in Access
      Hi,
      I was looking at your 3rd example and it is similar to what I'm using for my forms. But I have a problem, If one person opens form A and select one of the record from the list it works fine. Now at the same time if second person open the same form A from the same copy of MSAccess the first form A starts pointing at the new record also and save changes to the newly selected record. How can I prevent this happen, so that each instance of...
      See more | Go to post

        Leave a comment:

      • rk2008
        replied to Finding a Specific Record Programmatically
        in Access
        Hi,
        I was looking at your 3rd example and it is similar to what I'm using for my forms. But I have a problem, If one person opens form A and select one of the record from the list it works fine. Now at the same time if second person open the same form A from the same copy of MSAccess the first form A starts pointing at the new record also and save changes to the newly selected record. How can I prevent this happen, so that each instance...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...