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

How Managed IT Services Can Reduce Costly Downtime

Instead of worrying about how much a period of downtime could cost you, it’s better to have a plan in place that can reduce and prevent it whenever possible. And a managed IT partner can help you devise such a strategy.

Why Is It Important to Have a Robust DNS Filter?

A robust suite of cybersecurity tools is a vital necessity for any business. Failing to protect your network and devices can have huge financial consequences. DNS filters are more than just a tool — they’re an investment in your business. Here’s how having your IT team set up a DNS filter can provide big benefits across your organization.

Employee Spotlight: Mark

For this months employee spotlight we’re featuring new-again employee, Mark. He previously worked at AngelCom for 7 years and is back in the role of Director of Support.