Search results

Thanks Arnel

Thanks, agreed but still yeilds no result sadly, mystified as to why the combination (not event) is not detected. Even if I nest the If's despite Keycode being 42 (well at least in my tests) does not catch: Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) MsgBox "keycode: " &...

Thanks, I can't seem to detect it. Sure it detects the event firing, as it did without the parent having it's Key Preview property = True, & without the duplicate procedure (actually I didn't even have a subform in there; you kindly assumed correctly so thanks). But it does not detect the...

Thanks Arnel, I didn't have property set in parent frm, regardless the event was still firing but the multi-key combination not detected. I still cannot detect the multi-key combination. Maybe because the record is going in edit mode with depressed keys (pencil is indicated in selector).

Built a simple testing form; in a separate db to obtain what the keys should be As per Richard Rost. Trying to assign KeyDown/ KeyUp the form itself one or the other: Seems ctrl-delete = Keycode-46 & Shift-2 Frm - Key Preview = Yes The KeyUp event is detected but I cannot generate/ detect the...

That's more what I'm after thanks Arnel. Sorry been slow responding; I ran into another issue which prevents me from testing. I'm using a timer also with a mouse event but I'll just set it less than the other so pretty sure this will fix it. The sel.Height property is definitely what I'm after...

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...