Search results

This is probably really easy and I just can't figure it out. I have two true/false check boxes on a form, one for Paid and one for pickedup. On the query builder I have these two fields listed, and I want the records to show on the form if either box is not checked(false). So in the Query...

So I have your main form and the sub form (Service Order/Service Detail) I had originally had a continuous detail subform but found it didn't work well so I switched to a singe form. The trouble is, you don't get a peek at the other Details of the subform. Ideally I would want to use a...

This probably elementary, but for the life of me I cannot figure out how, though, I have researched the net for an answer. I"m sure it's a pretty easy answer. Have Main/Subform combo. In the subform I have a field, [service_detail] that if left blank I want the user notified. I created a If...

I have this Filter that I use to select the frameID It works fine, if there is a frame Id, I use a if statement to send a msgbox if the value is null or "". This is the filter. Private Sub qstxt_AfterUpdate() DoCmd.SetFilter "", "[FRAMEID] Like """" & [Form]![QuickString]![qstxt] & ""*""", ""...

So I have posted here before about an issue and got a work around, however there was some ambiguities and I'd like to get a real solution. I have a client table. I have a client product table for ski's Each Client has 1 or more products (skis) I have a Service Order table and form that I use a...

Greetings everyone.. first thread. First I"m sure this has been covered to death, but I have no idea how to do a search for this so, If you excuse me I'll explain what I"m trying to do. I have a continuous sub form that I use, that has the ID, Product and I use another field where I hyperlink...