When I press <ctrl><g> I get the following from the window: LastName Like '*Mike*'
Do you think this might cause the overflow issue?
W4FF
Last Activity: May 18 '15, 04:14 PM
Joined: Jan 26 '15
Location:
-
Yes I did add spaces, and I still get an overflow error. By the way thank you both for your help, I'm truly grateful.Leave a comment:
-
Rabbit I'm not a pro at this and where would I find the actual string it is trying to put into the Filter?Leave a comment:
-
I think this is it, the last guy in my department left me with this mess to fix, and i'm new to ACCESS
...Code:Private Sub ClearFilter_Click() clearfilters End Sub Private Sub AssessorId_AfterUpdate() Dim lookup As String Dim temprecord As Recordset Dim emailfind As String Dim var As Variant DoCmd.SetWarnings (False) If IsNull(Me.AssessorId) = False Then lookup = "SELECTLeave a comment:
-
The Run-time Error'3075': error is gone but I still have the over flow error. Please help.Leave a comment:
-
Here is the entire code just in case I'm missing something:
...Code:Option Compare Database Private Sub BirthDate_AfterUpdate() filters End Sub Private Sub Closeform_Click() MsgBox ("Exiting Intake Portal. Click on OK") DoCmd.Quit End Sub Private Sub Command47_Click() Me.Referral.Form.FilterOn = False LastName = Null FirstName = Null SSN = NullLeave a comment:
-
I did what you ask and now I get Run-time error Syntax error (missing operator)Leave a comment:
-
Debugger is highlighting the following in bold:
Code:End If [B]Me.Referral.Form.Filter = filterstr[/B] Me.Referral.Form.FilterOn = True End Sub
Last edited by W4FF; Jan 26 '15, 07:34 PM. Reason: To show where Debugger is highlighting the following error.Leave a comment:
-
Over Flow Error and Run-time Error '3075':
I'm having issues with Access 2010, the interface includes the following input options:Last Name, First Name, SSN, and Birth date.
Access was working great since 2012 and all of a sudden we are getting issues since the 21 of January 2015, here are the following errors:
1. Overflow
2. Run-time Error'3075':
Syntax error in query expression 'LastNameLike'* Akers*' AND FirstName Like'*Mike*'AND SSN Like'*100101001 *';...
No activity results to display
Leave a comment: