Search results

The database is full of proprietary, highly confidential data, so, unfortunately, I'd be unable to do that. Apologies. The setup is done just like the post suggested. I have a form, and, within the detail section, I have two unbound text boxes and then a list box. In the Search For text box, I...

Hello - John Big Booty posted an awesome thread in these forums. I'm unable to post a link due to not having posted at least 10 posts, but you can find the link by tacking on the following to this site's primary URL: forums/showthread.php?t=188663 It was, essentially, a type-and-show-as-you-go...

Thanks for all of the assistance. It's not working though. I don't know what the problem is. It's just not requerying. That's fine. The main thing that I wanted is working. Thanks again! David

Okay, bear with me. This is what I got and it's just not working... Private Sub Sold__Click() forms!Order_Form!Child18!Child64.requery End Sub I guess Access named my subforms as child18 & child64 when I created them. "Order_Form" is my main form. "Child18" is my Orders subform."Child64" is...

Thanks for your continued assistance... The "Sold" checkbox field is in a subform, Inventory. I like your idea of putting the requery in the "sold" check box to requery the query. The query is called CalculationsTotal and I put it into a subform, Calculations_Total_Form. So, this requery needs...

Thanks to both of you. It worked; however, when I do enter a new record, the query goes blank and just displays the field name. I believe this is what you guys meant by doing a "requery". Now, at this point, where do I add that "Me.Requery" extension so that it requery's the fields each time...

I need some help. My brain just can't grasp how to do this. I have an Access DB. I sell vinyl records. I have an order form. When a customer orders a record, each vinyl record has a unique ID#. No two vinyl records are alike. I have four tables: Customers, Orders, Inventory, & Order Details. I...

Hello everyone, Problem: I have an MS Access database in Frontpage that I'm using for my online site. Table is set up w/ a field named, "Artist" (amongst others). In this field I have artist's last name followed by a comma, a space, then the artist's first name. I am using the CONTAINS operator...