Member Avatar for isumasama

hi how to do insert ignore in access? is access support this function?

CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")"

or how can i do a search for duplicate record first before insert?

thanks

  • 1 Contributor
  • 1 Reply
  • 985 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by isumasama
Member Avatar for isumasama

after trying too many times yesterday, i dont think MS Access support INSERT IGNORE.
what i did instead is:
1. get the count for the particular record.. if there's record then >0
2. use the if statement before inserting any record.

dim temp as string

'1.
temp = DCount("ID", "FullDB", "IDProc = " & IDProct & "AND IDOp = " & IDOpt & "AND IDTech = " & IDTecht & "")

'2.
If temp = 0 Then
    CurrentDb.Execute "INSERT INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")"
   
ElseIf temp > 0 Then

MsgBox "The record you try to add is already exists. Please refill the form.", vbExclamation

End If
Edited by isumasama because: correction
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.