Recent content by seanward

I got it, I had to specify top 100 percent in the query for it to allow sorts.

When I try to specify order by in the view it tells me order by clause may not be used in this query type.

I can't figure out how to get the records in a form to sort automatically on open with a MS Access Project. It is based on a View which apparently only can't be sorted. The SortBy property on an Project is ignored. How do I sort the records on this form?

Checked the references, none were missing but DAO 3.6 was there. Out of curiosity I knocked it down to DAO 3.0 and that resolved the issue. Any idea what would cause DAO 3.6 not to work while 3.0 works.

Fresh installation of Office 2k Pro with sp2 applied and MDAC 2.7 installed - No Built-in fuctions are working at all on this machine. The same functions work on another machine with an identical copy of the database. Message when attempting to display the results is: "Undefined Function 'Mid'...