Ok, still nothing. I have a form with a combo box on it. The combo box correctly displays the contents of the Source: Industry table. I have that form, IndCombo, open. In my query I have a column with a field name "Prim Industry" from the table "Data - Job Data". In the Criteria field I...
Ok so now with =[Forms]![IndCombo]![IndComboBox] in the criteria and with the form open when I run the query, it no longer gives me that second dialog box. However, it doesn't bring up a combo box, nor does it use the selection I've made in the open form. Should I have to choose the industry...
I don't know enough about SQL and what the commands above mean to even edit them to my own use. I don't even know which kind of SQL-Based Query to choose on that menu.
Yes, and it comes up with my first criteria question, then the combo box should appear in the second, but instead I get the normal Enter Parameter Value dialog, with "Forms!IndCombo!IndComboBox" in text and an emtpy white box beneath. No combo box appears.
Ok, for some reason I'm still in the dark after reading all of that!
I have a query that I want to ask the user for an entry from a combo box. I've created a form called IndCombo, and on it is a combo box, IndComboBox, with all the data linked to a table. I know the format for referencing...
In my query, the user must input which company he wishes to view information for or leave the field blank to view all.
Here's what I'm working with:
=IIf(IsNull([Input]),{CODE TO DISPLAY ALL RECORDS},[Input])
I checked the code and if I make the true value one of the company names, it works...
Seriously, that's amazing thank you. I can't believe after all I read and searched nothing in the Microsoft help mentions this. Or I'm blind. Either way, thanks!
I want a report to display only the year of my [Contract Date] field from the table [JobData]. I've read all the help files Access 2003 provides and I've tried a thousand things that don't work. What works?
And if you give me code to enter, please tell me in which field it should be entered...
I'm pretty new to Access, and I've gotten far, but conditional formatting is too far beyond me.
I have a field [Customer] in a table [JobData] that I want to turn Bold if the field [BioCompany] is = "BC". The BioCompany field is not displayed on the report, but is in the JobData table...
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.