Recent content by sweensterpng

Hi there. I have a form that creates quotes, and when you get to the bottom of the form there are links to various reports that are based on the data. I want to set up some kind of interface where you can select which reports you want, then press one button to print them all. Is this possible?

Hmm, I just did, and it still is giving me this error. It's only a problem in the subform in this form.

I have been developing a database for a security company for the past several weeks, and am looking forward to having it finished. Imagine how dissapointed I was yesterday when I was creating the last form, and realized that the VBA wasn't working at all. I had typed out a fairly long IF...

Never mind I figured it out. I had some VBA code triggered by another object that would change the text of the text box that was supposed to toggle the yes/no field. I just needed to make sure the code was in the after update events for both objects, because I realized that even though the text...

Slightly better code... maybe I made some changes, so now the code looks like this: Private Sub Combo14_AfterUpdate() Dim ininventory As Boolean ininventory = IIf(IsNull(DCount("[Item]", "tbItems", "[Item] = " & Chr(34) & [Item] & Chr(34))), True, False) Me![Locked] = ininventory End Sub...

I have a form that creates quotes for my company by inputting inventory items in a continuous subform. I need to be able to check and see if the item already exists in the inventory or if it is a new one that has been manually entered, and have this toggle a bound yes/no field that I will use to...

I am building a form that will generate quotes for security sytems by allowing you to select inventory items from a combo box, then simply adjusting the number of that item needed. I have needed to make it so you can enter in items and prices that are not in the inventory. What I need to do now...