Runtime error 3075

[Pookiemeister]

First let me say that I am new to Access. I currently using Access 2010. In my table I have 10 Fields, the field names are below:

EmployeeEntry = AutoNumber
EmployeeNumber=Text
FirstName=text
LastName=text
Title=text
EmailAddress=text
workphone=text
extension=text
HireDate=date/time
Notes=Memo

Private Sub cmdAdd_Click()
   'adds data to table
   'refresh data in table
   CurrentDb.Execute "INSERT INTO MaintenanceEmployees(EmployeeNumber,FirstName,LastName,TItle,EmailAddress,WorkPhone,Extension,HireDate)" & _
      "VALUES('" & Me.EmployeeNumber & ",'" & Me.FirstName & "','" & Me.LastName & "','" & Me.TItle & "','" & Me.EmailAddress & "','" & _
      Me.WorkPhone & "','" & Me.Extension & "','" & Me.HireDate & "')"
   
End Sub

 

[jackd]

Not related to this specific error, but you should include Option Explicit as the second line in every module.
Does your regional Date format include a "." after the day value?

 

[csababenyi]

Not related to this specific error, but you should include Option Explicit as the second line in every module.
Does your regional Date format include a "." after the day value?

Good call, yes it does.

 

[JonXL]

I see...

Replace both instances of this:

DoCmd.ApplyFilter task

With this:

Me.Filter = strCriteria
Me.FilterOn = True

 

[Fluff]

Duplicate to: Run time Error '3075' (Missing Operator) - DoCmd.ApplyFilter task

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.