Search results

Got it! I am using a between and statment. In searching through more of the postings I found the field:datevalue(datefield) option and this has worked like a charm so thank you, this site is fantastic! I find most of my answers searching through others... Thanks for your quick response!:)

I have a date time field in which I want to remove the time but nothing seems to be working so I'm trying to live with it. So I need to search for a range of dates in a query: between [enter start date] and [enter end date] If I want to get just today's dates I am entering 8/5/03 in both...

If you use a GoTo Control it you can create the movement for them. ON Lost focus GOTO Control and they are in teh next location. No scrolling necessary unless they want to. Good luck!

Jennifer, You could do this with many forms or try seperate pages in one form and use goToControl on the lost focus of an object. If you use seperate forms you have to make sure each form is open to pass the value of that form to form that collects all the data. I'm not sure how many tables...

You can have your subform based on a query that takes in the value of control on the main form. i.e: The criteria of the query for the subform would be: Forms![mainFormName].[ContolOnMainFormName] Hope this is helpful!

Adding word "None" to combo box list I loved this article, any way to use this for access 2000? I found an article 208707 to leave a blank in the combo box. Fairly simple, you are asked to create a union query but no references to adding a word. My goal is to have the word "None" appear at...