Search results

Use LIKE in place of the = sign correct?

Thanks, Ill give it a try. I only have less than 3000 records

Thank you Pat, what if I need to use a portion of the field to see similar items in the data - such as: typing ST in the search box would show all models numbers with ST in them like this user types ST and the form is limited to: ST 304 ST 305 ST 306 and so on. Thanks

Pat, I hope this question finds you and yours doing well. I have a similar question on a bit of code you created for us, it is in Module 1 and it is Public Sub FilterByControl. I would like to modify this to filter based on multiple txt boxes at the top of my form but I can't wrap my head around...

If you’ll look, you’ll see that I responded to your post. Thank you.

Easy enough but...I am using the FilterByControl method in VBA to filter the records on the form and when I select the "All" selection I get the error that no items match "All" on my form. How do I use a if then in VBA to remove the filter?

This is what i have. The primary key from the table the combo is looking up is the first column and 0 length. When I say the combo is clear after selection is made I mean it is blank but applies the filter.

I think I've figured out why it is clearing, I am using it to filter the form so I believe it clears the combo box after the filter is applied and re-paints the screen with the filtered records - does that make sense? The combo box was made using the wizard. and gets it's value from a table, is...

I have a form that shows all records in a query, one field is called ProductType, In the header I have an unbound combo box that gets records from the product type table and filters the detail section of the form (all records) to the selection in the combo box. All is working fine but once i...

The move went as well as expected. We're all settled in finally. It's already too small though - our salesmen are real go getters. Wearing me out :) The app is working great, thanks again for all your help!

Hi Pat, Thanks for chiming in! I hope you're doing well. What I was trying to accomplish is a mute point. I fixed my data with an update query, I was attempting to be able for a user's mistake to be corrected with code. Instead I ended up writing the code to keep them from making the mistake...

I corrected some bad data and now there is no issue. I do t need the code. Still don’t k ow why it would not update the checkbox though. That’ll keep me up all night I am sure.

If QtyAvail =0 then the check box should be checked. If not it should be unchecked. This is for a completion form, so if there are none available to be completed, then the checkbox is checked “Marked as Complete.”

I have this code in the on current event of a main form I want a checkbox on the subform to change the value to false if QtyAvail = 0 But it is not updating. Private Sub Form_Current() If Me!frmOrderDetailsListToMarkForCompletionWthQty.Form!QtyAvail = 0 Then...

Thanks

What event occurs when user moves to new record on main form and subform updates the list of it's records? In other words: If move move to another parent record on a form, is there an event that is triggered in either the subform or main form?

Cool, that was easy!

Thanks How would i code this?

I have a popup form that lists records and has these fields: CompID Qty Date OrderDetID I want to restrict the user from editing the existing records while still allowing them to add the new record. Not sure how to go about this Thanks

I have a DB that has an OrderDetails table with Qty, Description, Yes/No Complete and Price fields along with some other fields. Currently I have a form showing an order list and when clicking on one of the orders, the subform will populate with all of the order details records. I can check each...