Recent content by LostInCode

Maybe the spaces and not length? It works for me as you show. try to use the short name Private Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" (ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long Public Function...

Good. But a rs copy is easy to work with. I post some code so you can see: Public Function CopyRS(rstOrig As ADODB.Recordset) As ADODB.Recordset Dim rstCopy As ADODB.Recordset 'Not updatable to db - no connection Dim fld As ADODB.Field Set rstCopy = New ADODB.Recordset...

But the recordset should still show only the filtered records -just not the grid So, you can easily create recordset from this. Make new recordset objekt, append fields by looping through the original fields collection, then just loop through the filtered data and add that to the new recordset -...

>I think that is not the purpose of filtering with array of bookmarks I understood the problem because of my own experience to have to do with bound control such as the datagrid. So I understood this is what you mean by not seeing the records. The recordset shows in code only filtered records...

>hides filtered records I mean when using with bound grid or whatever.

Sorry, I think that is not the purpose of filtering with array of bookmarks. A filter never effect persisted recordset when using array of bookmarks. It is only effected when you specify specific filter. And this I think is good so. Filter method has several purposes - maybe 5 or 6, and only...

Is your time field a text field holding time, or date field? Store the time as date-time in date field! Or at least, store the time in 24 hour!! format in text field. Date field is maybe better. Use dao? Surround literal time with ##. Text field: If use dao then TimeValue(horav ) and...

I try to use CDec() on numbers before converting then to dates. CDec(120 + ((2.3 - 2) * 100)) (CSng() will not always work either, and CCur() is not enough accuracy)

I think it only possible to send receive and read post with OE using mapi. Read messages - If this is what you looking for, and not looking for list of contacts or something, then for starts check out the Microsoft MAPI control (the Session and Messages objekts)

Thank you for your reply. I only have the API viewer, MZ-Tools, Klass generator, and Pretty.Print. The others are not automatic loaded - just when needed. All of these have were being used at a time when this problem never occured. I just don't remember if it started after I updated the NT 5...

Thank you for your reply. Yes, I have SP6 since it came out. The problem getting to the nerves and I thought that maybe someone else knew why or how to correct.

So, this must be a limit in CR < 8.5

Thank you for you're help!

This just may be an error coming from a bound control such as a datagrid or the data environment. Are you trying to update a recordset which uses a JOIN (I mean edit, and not just add or delete) Is any one of these a possibility?

Without knowing the code behind this recordset wrapper class, it is hard to say what is wrong. The way it looks, the error is being returned from that class wrapper itself (the programmer's - of the class - own defined error) and not ADO. See if you can find out exact ADO error code and...