| Recent Answers from ScottGem |
 |
2008-09-29 The Error is: You keep missing the point here. Again, both sides of the comparison have to be the same datatype. The expression sFilter = "[Date]= '" & Format(Me.fgh, "MM/DD/YYYY") & "'" will fail since Date...
|
2008-09-29 The Error is: Yes that's part of it. The Format function returns a text string, yet you are comparing that to a Date/Time datatype. You have to make sure that both sides of a comparison are using the same datatype....
|
2008-09-29 The Error is: OK, That tells me the problem and it should tell you as well. That means that you are mixing your datatypes. It looks like you are comparing a date value to a text string. there may be other places...
|
2008-09-29 Access Error: I've asked you a couple of times now, what is the error message? If I know what the error is, I may be able to diagnose the issue. The code snippets I gave you should work. Hope this helps, Scott<>...
|
2008-09-26 Access Error: But what IS the error? Also I would di like this Private Sub Command20_Click() Dim sFilter As String sFilter = "" If Me.ListFilter.ListIndex <> -1 Then sFilter = "[Assigned To]= " & Me...
|
| More Answers for "Data Management & Storage" |