Search results

I'd like to do different tasks in the OnDoubleClick event of a control based on whether the CTRL key is pressed. Is this possible? Thank you, Evan

Banana - not a bad idea, especially since the subform would not be dependent on the parent's code. (The subform is going to be used many times on different forms.) I'm not sure if it will work though, because even when the subform has lost focus, it still remembers the last control that had...

Wow! Thanks, George. I looked so hard for that :) Amazing what you will never see that's right in front of you! Evan

Banana, that approach might work very well, but you still have the problem of triggering that event. That is the basis of the question here - how do you trigger a 'Subform Lost Focus' event. Evan

The reason I wasn't very happy with my solution is because I never was able to find a real 'Lost Focus' event that worked for the subform. The closest thing I could find was the 'On Exit' event - which fires before the form loses focus, so I had to use the Timer. To me this didn't seem very...

Is there any way to have VBA step through each line of Code without turning one EVERY breakpoint in the whole project? I'm working with a lot of Activate, Deactivate, Got Focus, Lost Focus, events... and it's nearly impossible to tell where the cursor is going next and how the error is being...

I have a simple puzzle to offer. Attached is a small DB with a form and subform. The subform is only allowed to be visible when it has the focus. Seems so easy - but it may be harder than you think. I have also included my 'solution', but I'm not really very happy with it... Evan

I went ahead and used &H8000 even though it comes out as -32768 instead of 32768. When I started having problems with bit flags evaluating to TRUE when I knew they were false, I substituted the base 10 equivalant of &H8000 (32768). Lo and behold, everything started working after that. So it...

Banana and George: Thanks for the help and clarifications. Banana - what you just said about Access trying to help and throwing out the leading zeros makes sense. I thought there was something illogical going on there. Based on what has been said here, it looks like I'm safe to use it for...

....or and + give the same results.... I thought that you should never use + and always use OR when working with bits like this. Now I'm getting confused... :(

I'm new to the whole binary constants thing, but from what I understand, for the math to work out right, each constant should be assigned a number that is a power of 2. Hex, as you said, is basically compressed binary, so here is my list of constants. My intention is that all of these switches...

Sorry, bout the confusing list. i just fixed it - please refresh

This doesn't make sense: &h1000 =4096 &h2000 =8192 &h4000 =16384 &h8000 =-32768 &h10000 =65536 &h20000 =131072 &h40000 =262144 &h80000 =524288 &h100000 =1048576 Why the negative number mid sequence? Is this how all good hex momma's teach their children to count, or is it a bug? Evan

Try putting single quotes before and after your string: strSQL = "UPDATE Positions SET Position = '" & strAmendNew & "' WHERE ID = " & PosId & ";" You may have other problems, but whenever you use a String this way it needs enclosed in quotes - single quotes act just like double-quotes...

How about this: dim blnShow as Boolean if Me!mysubformname.form!Application = "House" then blnShow = True else blnShow = False end if Me.Label53.visible = blnShow Me.Label58.visible = Not blnShow Evan

I just used this code by Allen Browne to add error handling to my app. http://www.everythingaccess.com/tutorials.asp?ID=Error-Handling-in-Access-Basic It writes each error to a table very nicely, but you must supply the function with a string that contains the name of the calling procedure...

DJkarl is the man! Thank you - it was too simple for me to figure out :) I was diving into binary theory, trying to figure out what properties were changing in the window, etc... Was this just a bug? Or are you not supposed to use minimize and maximize with hide and show? Thanks again! Evan

I'm trying to set up a FieldValidation routine that I can call from any form. When the user clicks, for example, "Proccess Order", the Validation function will run. It opens a query that contains a list of fields and required criteria that must be met before it allows the proccess to continue...

KenHigg - that's where I'm probably headed...

No - not always dealing with a subform.