Search results

Thanks Ghudson.. just the job!

Hi Access 2007, .mdb I'm almost embarrased to ask this question but how does one drag and drop columns in a (subform)datasheet to change the order? I know about .ColumnOrder and acSaveYes/No to retain the changes... so I know how to manipulate in code but for the life of me I cannot drag...

Hi and thanks for the replies.... Curiously I have found the opposite to that which [I think] I expected... I have set Option Compare Text in my modules and Access has gone case-insensitive... so... IF "fred"="Fred" THEN .... is true...... Access... more red herrings then a Swedish...

Apologies, my error. I have just converted to ADODB recordsets and this architecture works in a slightly different way. In fact the reason my subform object was disappearing was my own fault ... I hadn't set the recordset up correctly. I think the situation I describe is still true for DAO...

Ok thanks... not used that before... and that's a good tip for other things too... I guess though it's only one half of the equation of this particular issue... let's say for example... I change the SELECT statement for the subform... it retrieves 0 records and unloads itself, I trap that...

Hi My main-form module has lots of references to its subforms. The subforms are populated by SQL Select Statements. These statements which include WHERE clauses are applied to the subforms via their ADODB RS.source params. When a SELECT WHERE statement retrieves 0 records the subforms...

Hi One thing that drives me to distraction is the opening of subforms and what strategy to employ when there are 0 records. I guess most of you have seen this... Subforms get opened before mainform, but the criteria on which they are loading at any given time might retrieve 0 records. If...

Hmmm... I'm getting confused now... so here's my experiemce. My modules came up with option compare database by default (or at least I didn't set it). When I wanted to check my Vars I changed it to Option Explicit. At this point it was discovering undeclared Vars but references to some...

Hi Actually, I have just done a compact and repair and the Option Explicit is now being enforced thanks. Odd that the Compare Text worked immediately but the Explicit didn't... Another mystery.. All is OK now, thanks for your assistance everyone.

Hi Sorry, yes, I should have said i want them explicity declared (as opposed to implicity declared when assigned). if possible, I prefer to switch case sensitivity off for everything... thnx

Hi Quick question please. I want to make sure my variables are all declared but I don't want case sensitivity... i.e. I want to turn case sensitivity off.... I tried this Option Explicit Option Compare Text This seems to turn off case sensitivity OK but it allows variables to be implicitly...

Hi Thanks for the reply. I use a mix of SQL SELECTs and ADO filters... Some of my main_form requirements are quite complex so I use an initial SELECT to get them into the RS... but you are correct and, under the circumstances described above, I'm just going to carry out a set...

Hi After many hours investigation I think I've fixed this. For anyone else out there who doesn't want to waste 3 weeks of their lives on trial and error :- When my main form "source-of-records" is re-built (I use that term to distinguish it from "RecordSource") I read that it was first...

Hi WinXPPro - SP3 Access 2007 .mbd file Native Access Db on Local Machine Sorry to post again so soon but I've an issue with ADO RS's and I'm completely out of ideas. I started to implement these some weeks ago and wish I'd not bothered! I have main and 6 subforms. All are built as I've seen...

This has been superceeded by another issue... please see http://www.access-programmers.co.uk/forums/showthread.php?p=1126865#post1126865 thanks HI Would appreciate advice on the following please. I have a Main form with several subforms (6 all told, each on its own tab). Once loaded...

HI Thanks for the reply... As you probably guessed from their names I use them for setting up the recordsets of my forms. At one time I assumed they had to be there for the life of the form.. and I killed them off in the form unload event... I later realised that wasn't necessary but I...

That's correct, I was having a problem... Access was actually crashing at the point they were being assigned.... and I began to wonder if these variables needed be re-dimmed somehow. They are sited on a subform and so are public in order that they can be managed from the mainform too. If I...

HI Quick question on variab;e scope within a form, If I declare a variable in the delararations section:- Option Compare Database Public Frm_RstADO As ADODB.Recordset Public Frm_CnnADO As ADODB.Connection Then set the variable:- Set Frm_CnnADO = CurrentProject.AccessConnection Set...

Think I may have solved this.... I changed the cursor type to 'adopenkeyset' and my connections to:- CurrentProject.AccessConnection I also set the Rs and CNx to Nothing after setting the form recordset....i.e. Set Me.Form.Recordset = Addrs_ABCD_rstADO Set Addrs_ABCD_rstADO = Nothing Set...

HI I'm having real horrors with my forms. I'm converting my forms to use ADODB RS's because I was plagued by problems with SQL Transactions in DAO (begintrans/commit etc). I have Access 2007, using local-machine native Access Db (but want to go FE/BE eventually). It is a .MDB project. All my...