Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2020
    Posts
    2

    Records in form been save but with different User

    Hi there. I have a call table that will keep data for all the contact that all telemarketers need to call each day. Each data will be assign to their name. Some contact will be assign to 2 telemarketers. We will use "Edit calls details" Form to edit the contact after we made a call. Example i have 2 different Telemarketer and they have to the same person in one day and although the (Telemarketer 1) Call the contact first but the data is updated under (Telemarketer 2) records. Can you guys help me to solve this?


    Click image for larger version. 

Name:	Capture.jpg 
Views:	9 
Size:	61.5 KB 
ID:	43475

    This is my VBA code?

    Code:
    Option Compare Database
    Private msaved As Boolean
    
    
    
    
    Private Sub Campaign_Name_AfterUpdate()
    Me.Requery
    End Sub
    
    
    Private Sub Command203_Click()
        Dim App As Outlook.Application
    Dim oMail As MailItem
    Set App = CreateObject("Outlook.application")
    
    
    
    
    Set oMail = App.CreateItem(olMailItem)
    oMail.Body = "Dear" & Me![First_Name] & "," & vbCrLf & vbCrLf & "It has been six months or longer since I last contacted you. Have there been any big gains with regard to impact?"
    oMail.Subject = Me![Campaign_Name] & "- check up"
    oMail.To = Me!Email
    oMail.Display
    Set oMail = Nothing
    Set App = Nothing
    End Sub
    
    
    Private Sub Form_BeforeUpdate(Cancel As Integer)
    If msaved = False Then
    Cancel = True
    Me.Undo
    Cancel = False
    End If
    End Sub
    
    
    Private Sub Form_Current()
    msaved = False
    End Sub
    
    
    Private Sub Form_Load()
    
    
    End Sub
    
    
    Private Sub save_record_Click()
    msaved = True
    MsgBox "Records Saved"
    End Sub
    
    
    Private Sub SDRname_AfterUpdate()
    Me.Requery
    End Sub
    
    
    Private Sub ID_AfterUpdate()
    Me.Requery
    End Sub

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    I am going blind in my old age.?
    I cannot see anything in that code that shows a caller field being updated.?

    If you have a field in a table for that form that holds the CallerID then the last person to call is always going to update that field last.?

    You should likely have a separate Call table that holds CalledID and ClientID with Date and Time etc. if you want to see the 'history' of the calls.?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    The 'gasman is right...and the Call table needs to be displayed as a Subform to your Main Form...with the Subform being sorted on the Call_Date and Call_Time fields.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-27-2019, 03:18 PM
  2. Replies: 6
    Last Post: 11-19-2017, 08:41 PM
  3. How to save new form records
    By sud2017 in forum Forms
    Replies: 100
    Last Post: 08-18-2017, 04:17 PM
  4. Replies: 2
    Last Post: 09-09-2016, 01:50 PM
  5. Unbound Form, but wish to save records...how?
    By LostInAccess in forum Forms
    Replies: 4
    Last Post: 07-18-2012, 09:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums