Search results

Ok, problem solved. @arnelgp had it right. The two computers I tested that it worked for had default Windows dates showing as "2020-02-11", whereas the two computers that it didn't work on had default date displays of "02/11/2020". So the "/"s were messing those up. Thanks everyone for the help!

My friend has been using a copy of the file on his Surface Pro, not accessing it from my system. I tested it this same way on two more PCs now. It works perfectly on one of them, but the other one gets the same error.

I have a working database on my computer that lets me add expense items, employees, work entries, etc., then output into reports (e.g. Employee Expense Report). Everything works fine on my computer, but when my friend tries to run reports on his Surface Pro, he gets a Runtime error 2501. Here is...

Got this working with the extra bracket--and you're right it is cleaner. Uncle Gizmo's code works great too. Thanks for all the help and tips everyone!

Returns syntax error when I try to save query. Seems to be highlighting ORDER.

I've gotten a slight variation of this to work! Thank you so much! I was trying to simplify it, but what I have on the form is a combobox that selects employee, then two date picker fields for start and end date. Then I press a button that generates a report. So I created two queries like you...

ComboBox name is: EmployeeEntered The Bound Column is: 2

Ok, been trying to adapt arnelgp's code and no luck yet. Here is the exact code I have currently for ComboBox Row Source: SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] ORDER BY [Employee Name] UNION SELECT Null as AllChoice , "(All)" as Bogus...

Ok, so here's more info about what I've tried. I can get an (All) option to appear in the ComboBox with this code in the Row Source for the ComboBox: SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] ORDER BY [Employee Name] UNION SELECT Null as...

I've seen this question posted elsewhere, but I can't make any of the answers work (I'm a beginner with Access). I have a combobox that lets you select an employee, which gives the selected employee name as the parameter for a query. I want to have a "Select All" option in the combobox that...