Recent content by MCatz

Where would I go to change this property? It's strange. Shift-Click works fine on the database I provided in Access 2003 but does not in 2010. Is there something new in 2010 that I'm missing?

For some reason, I cannot get Shift-Click to work in Access 2010. Originally, I put in a shift-click disable module to prevent tampering with the database, and had a secret button to click to disable the module, so I could still work in the database. Well, that secret button decided it...

Bump it on up!

Bump it on up

Not sure what you mean here. I figured it'd be some kind of event in the On Click, On Got Focus, or something along those lines.

Hi Access gurus, Is there an easy way to create a "comment" when you select a field similar to what you see in Excel. I see an option for text in the status bar, but I doubt anyone will actually look there. Something similar to this:

Good deal. Worked perfectly. Thanks, guys.

That did the trick SmallTime! Thanks! One last thing I'm trying to get. How can I get a listbox to clear based on the value in a combobox? If the choice is "Yes", any selections previously made in the listbox will be cleared. I tried this in the "AfterUpdate" event on the Yes/No combobox...

Thanks for the response, Pbaldy. Should I put the code in the AfterUpdate of the form or the subform (I tried both, but it didn't seem to do anything)? Also, how can I refer to the column I want hidden? Here's what I tried If Me.cmbPrecision = "Yes" Then Me!sbfrmEquipResults.[Further...

Basically, If a user selects "Yes" in a combobox, the subform appears and a certain column is hidden, but if he/she selects "No", the column is visible. What's the best way to go about this?

Once again, I'm a total super-nice person. The only part of the query I could originally see was this... But...if you simply extend the window down further... MAGIC! I can sort by M Number. D'oh!

Alright...I lied One more thing. How can I get the subform results on the "Search Database" to sort ascending by M Number? I've tried fooling with the subform Record Source and the query but can't seem to get the subform to cooperate.

Is there an easy way to prevent mouse scrolling through records on a form? I've found a few long-winded ways of doing it as well as others saying "there's an easier way to do that" but posting no follow-up solution. Thanks,

Alright...I think I've got everything I can think of for my database now. Can't thank you enough for the time and effort, Bob. If I lived anywhere near Portland, I'd take you out for lunch. :D

I suppose I could just do that. I'll just leave the default as "Yes" Now...one last question, and I'll be done: On my "Record Form", how can I make the Area, Month, Year, and Further Problems show up as Text instead of Numbers. I figure it's a little different than the "Search Form" since...