Search results

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

Ahhh...didn't think to look at the table level. That was the only way (that I know of) to solve my problem of the option group automatically defaulting to "No" when I entered something in another field. When it defaults to "No", the "Further Problems" combobox won't appear unless you click...

I'm not sure what you mean here. Try it on my most up-to-date version. Enter a record on the "Record Form" and then attempt to search for that same form on the "Search Form". It doesn't "find" it for some reason. The record is appended to the EquipmentID_Table, but it doesn't seem like that's...

One last question on the Search Form and I'm completely done with it. The subform doesn't seem to update with new records. I added a couple more records via the "Record Form", but they don't seem to show up in the results of the "Search Form." Is this another case of making the subform...

Hmm... When I select "Yes", it returns all the ones checked Yes, but when I check "No", it returns everything. EDIT: Well...fooling around myself actually worked this time. That seemed to do the trick. If Me.optPrecision = -1 Then varWhere = varWhere & " [Precision State] = True "...

What if I were to use an option group instead?