Search results

Hi Banana Thanks, I changed to CursorType = adOpenStatic which on it's own did not cure the problem but with Set Edit_Cnn = CurrentProject.Connection ... it now works!! Just to answer a couple of your queries... I may have tricked myself here ... it's a while since I switched this form to...

Hi hany1002 Not quite sure what you a re asking me here... can yo explain a little further please? rgds

Hi All Access 2002/2007 WinXP Pro SP2 I'm struggling to add a record into a recordset, or more specifically, copy a record within it. I have a form with an unlinked subform. The subform is populated by the main form using an ADO recordset and within a begintrans/endtrans. I use an ADO so...

Hi I've done a fair bit with these transactions now... they were 'interesting' to set up ... the order in which they were built and populated for example... I don't think they do lock the tables in [what I would call] the traditional way or even in the Access way for that matter... I have...

Hi Not an issue as such but I am curious.... does anyone know why the VB IDE toolbar backgound colour changes every so often? It does not seem to be linked to anything glaringly obvious such as 'save changes' being required? In the attached you will see it's turned a very attractive shade...

Aha... I see... thanks for clearing up my misunderstanding... as they say "assumption is the mother of all ..... [unprintable]" :)

Hi kaisersose1995 Thanks for the reply. Unfortunately, this still doesn't quite return what I was hoping. In the example, If unique_no 15 has record=true and the SQL is run to set record=true, the db.RecordsAffected still returns a 1. What I was hoping to do was detect if a 'real' change...

Cheers Bob!! That's worked... I now have a step thru' For anyone else with this problem... try... Start-Run (on XP) then type... "c:\Program Files\Microsoft office\office12\msaccess.exe" /decompile "c:\Shared_Network\Test.mdb" Replace the directory for msaccess.exe plus directory and name...

Hi Bob Apologies for late reply - distracted by a 1 day job that took 2 weeks! :) I've verified that option thanks.. I've also done the usual compact and repair.. I've created a copy of the Db, deleted the code module and restored it (via notepad to lose any phantom control charcters)...

Hi Access2007 I have a couple of debug points set in my code... one in Form-ApplyFilter and one in Form-Timer. When I apply a filter the code steps thru' the ApplyFilter event OK but from that point my debug points are ignored... i.e. Access does not step thru' I have set...

Hi Great... thanks for such a comprehensive answer... For now I shall assume use of Jet/ACE when reading the ADO guidelines. I expect no more than a handful of users. Incidentally, I went for ADO because I wanted to use SQL Transactions (BeginTrans etc) and I seemed to be getting...

Hi Access 2002/2007 - please see attached I've been reading up on connection strings, providors etc as I want my form Rs's to be ADO. At present they are not linked tables but 'local', I do, however, want to split them sooner of later. I'd like it to be backwards compatible with Acc2002 if...

Well, well ... re-boot, compact and repair.... type into a new query and it works!

Thanks Jdraw... So its not my Select ... all very odd... when in doubt re-boot!! :) thanks

Hi WinXPPro SP2 Access2002/2007 I'm building a recordsource on-the-fly for a form which I want to appear in a particular order.... Before I throw myself under the next passing train can anyone tell me why the ORDER BY on this simple Select is ignored please? I've tried ASC and Desc ...

Hi I thought so too.... But turns out it's not needed for an ADO Rs (rather than DAO)... found this .... in this useful guide.... http://www.classanytime.com/mis333k/sjdaoadorecordsets.html#editADO Cheers

I think I've resolved this... Opened the form RS with:Edit_rstADO.Open SQLLine, Edit_Cnn, adUseClient, adLockOptimistic Trapped the "error" which I don't think is really an error??If Err.Number = -2147217864 Then Resume Next End If (Great that... we were taught never, never, never...

Certainly worth a go thanks... I added a referesh after setting the form recordset.. alas no joy...

Hi WinXpPro Sp2 Access2002/2007 Does anyone know how to achieve this please? I've spent 3 x 12/14 hour days trying to get it to work. I really don't think what I'm trying to achieve is so spectacular? Simple Form with a Subform. The idea is to permit users to deselect and/or re-order the...

Hi Thanks for the feedback. No... my feelings are not hurt :)... but my heart rate has risen over the past few months! I set out some time ago with a handful of, what seemed to me, very un-ambitious aims. Believe me, at no point did I intend to drill so deep into Access! Use built-in...