Search results

dead set for all that frustration, success felt so good i need a cigarette LMAO!

ok - thanks so much for that (i'm in australia hence why i took so long to respond, just got into work). i found the last response quite helpful, and putting this into code got EVERYTHING working. so thanks... god i love learning on the fly like this.... :/ but i can't thank you all enough (i'm...

ok did some reading, i need to re-load the filtered record into another recordset: rsCivilActivitySlipsUnfiltered.Filter = "JobNumber Like 001*" Set rsCivilActivitySlipsFiltered = rsCivilActivitySlipsUnfiltered.OpenRecordset but i get told i have a missing operator on this.... i wouldn't think...

ok everything seems ok, the only prob is that rsCivilActivitySlips.Filter = "JobNumber Like " & RJobNum(rsJobsList![Civil Job Number].Value) & "*" seems not to work although it seems fine. access doesn't stop there a Debug.Print on rsCivilActivitySlips.Filter returns: JobNumber Like 001*...

maybe some kind of update after the filter property set?

is it possible the filter statement there needs adjusting??? the first filter result (checked) is [Civil Job Number] = 001* which is right and access accepts. i run that in main query manually i get no records returned which is correct. when i run this in vba it gives me the first record in the...

ok, first, bob - thank you. great effort, much appreciated. seems to work without hanging. seems to come back with wrong result too, but i'll look into that...

no prejudices, willing to redo it anyway i have to lol. in my learning (and i may have this backwards) but isn't ado the new one and dao the one (supposedly) being phased out?

Access suggest it in Intellisense. seemed logical.

yep...just typed a value into the cache manually and it let me save it and reopen so i'll say yes. if the rsCivilActivitySlips.CursorType = adOpenDynamic isn't right feel free to suggest something else...access says i can use it here.

check it out...

btw rsJobsList.Edit is considered to be "not a valid property" by access....

ok. i need the query to hold data (its a cache) and dynamic seemed the best intillisense help there, still does lol. i added a rsJobsList.Update statement before the movenext, now it hangs on the update. i can do this with a query cant i? really don't want to use a table for certain reasons.

yeah i worked it out, simple syntax. on to worse problems lmao. check for my other post.... ;)

and here is the table - it complains on the first record i can check while in debugging (just to prove i'm not nuts) :)

hey bob, pleasure as always :) oh yeah, you can have it. there is more but this is all that effects... man this is ticking me off: Dim rsJobsList As ADODB.Recordset Set rsJobsList = New ADODB.Recordset rsJobsList.ActiveConnection =...

removed calculated fields, no joy there either.... @#$@#$

can anyone think what a rs.MoveNext would fail? it can't move on from first record and there are many. the compiler stops me on rsJobsList.MoveNext to debug. frankly weird i'm looking at query now, it has 37 records. seems stupidly simply....(yes, rsJobsList is a legit open adodb recordset -...

i'm loading a ADODB recordset and to simply extract and replace the data in afield. i've done this in bulk with a 'With" statement but when i try to access a single value in a field it goes all wrong.i would SWEAR that a simple: sampleVariable = rsCivilActivitySlips!TotalSpent would work if...

lol i consider it but reality is i have a VERY tight schedule and pretty non-understanding managers. we can meet the deadline with slower software and make it faster after deadline though. i'm painfully aware i will be looking over this for some time to improve it. - btw prob with fusing into...