Search results

I have other drop down boxes on my form with similar duplicate fieldS (eg Country) but they just show one instance. The only difference I can think of is that the query below is pulling from two tables. I've modified the SQL to remove the specific criteria and to Group by Customer: SELECT...

Unfortunately, I cannot post a copy of the db because it contains proprietary data.

Hi John, I've tried and tried but cannot figure out how to use the Group By option so that the drop down list just shows 1 iteration of the customer name. My list still shows all instances of the customer name. SELECT QrySupplier_Customer.Customer, tblFactory.FactoryName...

I have a query of factories and their customers. My search form has a drop down box that performs the query by customer. The query is looking up the factory by customer: A, B, C. How can I have the drop down box just show the choices of A, B, C instead of A,A,A, B,B,C,C,C,C. I added Distinct...

Thanks RG, I imported the db as you suggested. The splashform imported as well but at least it works now.

In Access 2007 I have set the Display form to my frmSplashScreen. It worked for a while but then I changed the timer event from 7 seconds to 10 and now the form won't even open in design view. I've redone the form thinking it was corrupt. When I try to delete the form it says I cannot because...

Hi All, I'm familiar enough with Access to create questions to which I do not have answers. Looking forward to learning from more experienced users! ;)