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 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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.