Recent content by dalski

Thanks IslaDogs, that's a very good link & certainly will delve into it. Correct me if I'm wrong but I'd need to add another listbox to manipulate the order/ showing/ hiding columns. I'm tight on real-estate with the form & don't really have space a listbox/ another fair-sized control atm. I'm...

Thanks Minty, if possible I'm trying to avoid a form because it is nice for the user to be able to rearrange/ hide columns in what order they prefer; there is a lot of columns. That is helpful input though so thank you.

I know nowt about SQL Server, but I am aware that if a calculated field in your query relies on an Alias which was created in that query SQLServer will not recognize it but Access will; just incase this helps out (CheekyBuddha taught me [thanks]). Mismatch usually indicates a type error I...

How does one protect against multiple records being selected on a subform? Current Event - if multiple records are selected it will not recognize Record Selectors Property - would be handy if it had a collection of the currently selected records but does not seem to have Situation The subform...

Thanks Doc, yes that's the route I think. Any idea on the limit for layered queries? I said 30 to be safe but I recon I may be able to get it to around 8 separate queries. They make the calculations harder without them. I'm not sure exactly yet, it's a little difficult defining the dependancies...

If you're using MajP's masterful Treeview then I believe his clever Update & Sort method does all the heavy lifting, so presumably you have a reference field for your own needs. Not crystal clear but I get your gist. You could work with the recordset directly which is bound to the form with...

On math heavy queries what is the best way to handle titled? Was advised that other db systems would fail on a calculated field which obtains it's value from a calculated field defined in that query. So I'm not doing that. In an ideal world this makes it much easier but I will want to use MSSQL...

Are they using New Outlook; if so I believe that is the issue; does not allow manipulation through VBA. Probably not but just incase it was an easy fix; with a rapid response & got lucky.

How would he decouple - create a duplicate temporary record? I agree @bodders24, there are not a lot of good tutorials on VBA Class Factory like functions. I'm not sure what you're gaining in decoupling the BE/ FE? Only to add several layers to the process; diminishing performance, maybe you...

Thanks xavier.battle, apoligies Doug Steele. If Doug is a member would greatly appreciate if someone could tag him so he gets credit deserved.

Thanks @isladogs, I had no idea & I'm glad I mentioned PopUp (which I thought would be irrelevant). Some valuable lessons learned here; thanks guys. I should credit & boost page rank for the awesome tutorial I am following - Doug Steele's awesome Drag & Drop tutorial here; which I think is...

Thanks Dave, that's exactly what's happening & pretty much what I'm up to. But the unreliability of Screen.ActiveControl also seems to apply to Me.ActiveControl. PreviousControl also produces an inaccurate result; specifying a button which i have not pressed in years. Interestingly...

Interestingly specifying an objVar as Listbox type does not assign the listbox objectively (without an explicit string reference) either: Set thisList = Me.ActiveControl

I have a PopUp Form containing two listboxes (the control I refer to is the child listbox). Parent listbox has no multi-select property; child listbox (in question) mutli-select (simple) & an optionGroup (irrelevant) with other irrelevant buttons... MouseDown event assigned to a txtBox in the...

Thanks that's interesting; I was enjoying your Security challenges the other day, have not managed to complete one yet. Terrified I've spent a year learning an obsolete tool :cry: so that's a comforting read.