Search results for query: *

I am pulling my hair out on this one. Everytime I use the combo box I get "The object dosen't contain the automation object POrderDetails". The main form is POrder and the subform is POrderDetails. The code below is attached to the after update event of a combo box setting the price of an item...

I am trying to count the number of columns in one query and select all records with a (-1) in all columns.

I am writing a query with 6 tables being included in it. All tables are check boxes except for the key. Is there an easy way to count all columns in the tables and display all records that = yes with out defining "yes" in each field?

I figured it out using code and a login form instead of a query. I just got this working. Thanks Private Sub txtSSN_AfterUpdate() Dim strDuty As String strDuty = DLookup("DutySection", "Personnel", "SSN = '" _ & Me!txtSSN & "'") If strDuty = "Admin" Or strDuty = "Support" Then...

The attached is giving me fits. Is there any way to make this query updateable and still do the some thing? I need to beable to view [Expr1] because it validates a field in my table. SELECT Personnel.*, (SELECT DutySection FROM Personnel WHERE SSN=[What is your SSN]) AS Epr1, * FROM Personnel...

I am trying to refine this query with a list box to select the appropiate result. the form is [emplist] and the box is [choosen](table it sends data to is tblChoose) What is the easiest way to do this filtering the fields StatusA, B, and C? ****NOTE: I DID NOT CREATE THIS MESS I AM JUST TRYING...

That is it thanks for the help. I have been trying this for a couple of days with no luck but it works like a champ now.

What I am trying to do is display all records if after entering the SSN the [DutySection] equals “Admin or “Support”

I am trying to create a query that asks the user to input [SSN] if the [SSN] matches "Admin" or "Support" in the DutySection field display all records if not then only display the selected [SSN]. I don't remember how to enter an if then statement that will override the select query if a the...