Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.



411 University St, Seattle, USA


+1 -800-456-478-23

Access Microsoft SQL Advanced Text Filter Contains Like Not Insert Identity

Not Like “*(*” And Like “*Office*” And Like “*Microsoft Office*”

‘ Insert Into Database
Line = “Insert into notes (notedate,idclub) values (‘” & Date & “‘,” & Me!IDClub & “)”
CurrentProject.Connection.Execute Line
‘ Get Last Identity ID
mylastid = CurrentProject.Connection.Execute(“Select @@IDENTITY”)(0)
‘ Refresh Form
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

‘ Open Form with New ID
stDocName = “Notes”
stLinkCriteria = “[IDNotes]=” & mylastid
DoCmd.OpenForm stDocName, , , stLinkCriteria

More Posts

Is It Time to Migrate from G Suite to Microsoft 365?

Google’s G Suite (now called Google Workspace) and Microsoft 365 are the major productivity software players competing for attention, and both are worthy of consideration for entirely different reasons. However, many companies eventually leave the startup phase and outgrow G Suite. This is when you know it’s time to migrate to Microsoft 365.

The Importance and Features of KnowBe4

In light of OpenAI’s viral ChatGPT platform, users worldwide are leveraging the tool to accomplish tedious tasks, improve their workflows, or just have fun. We look at how AI tools like ChatGPT function, and then we’ll review some positives and negatives when it comes to using it at your place of work.