Search results

Matthew, I would like to help you with your issue. I took a look at the sample Access file you posted today. I would like to confirm a few things. I believe we are working with the following objects: Form: Calendar List_F_C Record Source: Calendar_Strata_1Q I need more information to...

Sorry, Gasman for misunderstanding your post. I can relate to you my experience trying to reproduce the OP's issue. When I used his code, which included Me.FilterOff, Me.Filter = <criteria>, and Me.FilterOn, I got parameter prompts all over the place. None of the prompts were appropriate. It...

I agree with Gasman. You're trying to do too much with the filter properties of the form. You don't need to set any property other than Me.Filter. If you mess around with Me.FilterOn, Me.FilterOff, Me.FilterOnLoad, Me.Requery, it will only lead to trouble. Follow the example I posted...

I think I got it to work for you. You are trying to set a filter on your form. The SQL behind the form is fine. You only need to properly set the "Filter" or "where clause". Your event should look something like the code below. I copied your code and commented out what is unnecessary. It...

I like to reset the form's recordset when doing what you're suggesting. This doesn't answer your specific question. Sorry. This is a suggestion to consider as an alternative. I think your form looks something like the below image. There is a button and a text box to hold search data; the...

I’m having a little difficulty visualizing how you have designed this form. You mentioned it is a continuous form. It would be very helpful to look at a screenshot of the form. Would you please forward a screenshot?

Anything you ever did with the organ is way beyond anything I've ever done with a piano. You see, I don't know how to play the piano. The reason for the nickname is I love Harry Truman's famous quote, “My choice early in life was either to be a piano player in a whorehouse or a politician...

Hi Pat, Thanks for the comment. I understand your position. The point of the post was to respond to the OP even though the date of the post goes back to last December. I wanted to give him some ideas on how to use data objects (either DAO or ADO). I worked on this some more (only for fun)...

Hello Access World, I am new to the forum. I was a full-time MS Access and VBA programmer in a previous life. I cut my teeth on Access 2.0 and Ken Getz. I moved on to other endeavors after this roughly fifteen-year period. I still get the urge to try new ideas out once in a while although I...

Access is meant to be used with linked tables and bound forms and reports. That is the advantage of the platform and should be used in that manner to enjoy its benefits. However, some like to adapt Access to using dynamically generated data for unbound form controls. I have played around with...