Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by peladito
-
DoCmd.ApplyFilter. Main form and subform
Sorry guys, the same error as before. The error that I’m getting is “the action or method is invalid because the form or report isn’t bound to a table or a query”- peladito
- Post #9
- Forum: Microsoft: Access Forms
-
DoCmd.ApplyFilter. Main form and subform
Hi! You are going to kill me, after I put that code it gives me a new error "you cant assign a value to this object- peladito
- Post #7
- Forum: Microsoft: Access Forms
-
DoCmd.ApplyFilter. Main form and subform
Hi, Thanks for the help. After I put Dim sCriteria As String sCriteria = "(Year([supplier_issuer_date])=Year(Date()) And DatePart(""ww"",[supplier_issuer_date],0)=DatePart(""ww"",Date(),0)) = " If Me.OpenedDateFilter = "Today" Then Me!Browse_All_Issues.Filter = sCriteria...- peladito
- Post #5
- Forum: Microsoft: Access Forms
-
DoCmd.ApplyFilter. Main form and subform
The error that I’m getting is “the action or method is invalid because the form or report isn’t bound to a table or a query”- peladito
- Post #3
- Forum: Microsoft: Access Forms
-
DoCmd.ApplyFilter. Main form and subform
I have a main form (search) that has an unbound combo box (name: OpenedDateFilter) on my main form that has the following list values. "Today";"This Week";"Last Week";"This Month";"Last Month". My subform (Browse All Issues) has a date field (supplier_issuer_date) that I want to filter. I know...- peladito
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
