Search results

Uncle Gizmo, Thank you -- apologize that I didn't quite understand your first suggestion -- so I tried to implement the second one -- obviously didn't perceive the intricacies. Appreciate your patience. Regards, tmc

Hi Dave Oddly enough, I tried a query to pull the records I need for this user and made the LastName the only sorted field (A to Z) and when the form opens, the LastNames are not in alpha order. Then I changed the query to Make a Table with the LastName sorted and again -- not in alpha order...

Thank you Uncle Gizmo, The statement I placed in the On Load line for the form is: OrderBy = “[USCustomerReps].[LastName]” – where USCustomerReps is the name of the table that is used by the form and which contains the field LastName. This gives me the “cannot find” result. Then I...

Thank you Uncle Gizmo, I am pretty new to Access and am having trouble getting the OrderBy instruction to be accepted -- I wrote it OrderBy = [tablename].[fieldname] and then when I open the Form, I get a message saying the database cannot find the Object OrderBy = [tablename].[fieldname]. and...

This may be a very naive question, but ... I have a Form that has a table source -- I need to present certain data elements to the user who will work with the form in a sequence (e.g., alpha by CustomerLastName). The underlying table is sorted in CustomerNumber and PlantCityZIP code order...

Brilliant!! Many thanks, sir.

I built a Form "donor information" from a table containing just that info. I added a Subform to it that contains information about the "donation" that the donors provide -- a donor can make multiple donations. After building the subform, I display the Form in form view (it's fine) but the...

Mr Schapel Now I get it. And thank you for the solution -- I've tested it in all the ways I can and find it 100% on. Very much appreciate the assistance. tmc

Mr Schapel Thank you for that insight and I also thank you very much for the solution that I have tested in many ways and find spot on. I appreciate the assistance very much. tmc

While I was trying to comprehend and digest Mr Steve Schapel's initial posted solution after which I decided to post an intervening comment, Mr Schapel's "simpler solution" has come across to me. I'll incorporate that into my analysis also. Many thanks again. tmc

I am absolutely humbled by the advice and responsiveness to my inquiry. And the answers -- WOW -- no wonder I couldn't figure out how to solve this problem. Mr Steve Schapel -- your restatement of the problem is correct, but I would like to clarify that the service requests can be effective...

I need to select service requests for the current week -- beginning Sunday and through Saturday. The service requests have a StartDate and a Duration value which is a number between 1 and 35 representing the number of days the service is required. Can't figure out how to use the...