John, I see how you modified the combo box using the ztblNulls table. That's a different method than the ones I studied this morning. I modified the query with some code I found on the web and everything works great! Thanks a lot.
Brad
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Brad-
>
> See TimeTool_V5All.zip that I just uploaded. The combo box now has an "<All
> Customers>" selection that resets the combo box back to Null. You might need to
> modify your code to recognize the Null as a request for no filter.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bradley
> Sent: Tuesday, November 29, 2011 10:10 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Adding an "ALL" option to a combo box list
>
> Hello, I am having trouble adding an "ALL" option to a combo box list. I have
> spent half the day using suggestions from the web, but with no luck. I put a
> test database in the "PTS Time Tool" folder and named it TimeTool_v5. The form
> with the combo box is named frmIndividualReport3, and the combo box is named
> cboCustomerName. This is what I want to do: The form uses combo boxes to collect
> a date range, Function, and Customer as input to a report. I would like users to
> be able to select "ALL" from the Customer combo box list to show all the
> customers for a particular date range and function. I use Access 2007 and my
> experience level is beginner. Thanks for your help.
>
> Brad
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar