Search results

Here is the full code so you can try it for the first three combo boxes on your form. Place that code on a click event on that form. Let say. create a button called "View Report" on that click event put that code. MAke sure your combo boxes are named the same as I have them named in the...

IT would need to go in the module for that form. So you can call it once you have the criteria set, and have it pull your report for you.

Here is a start, this will go in a sub routine that you have that will pass the report Name to this sub. For instance ShowReport.Click Event ShowReport("Your Report Name") Below once you pass the report name, it then looks at all the combo buttons and etc on that form. and attaches it to...

Holy cow that is alot of criteria. It will be tomorrow before I can do it. I can start it and see if you can finish it if you like, let me do a few..so you can see.... Give me about 20 min.

I've attached a copy of my menu... I need to see yours so I can see how to do it. I can't follow the info you gave me. :( Sorry honey...

Give me a little bit and I'll see what I can do. I'll try and convert mine for you....or at least give you a head start so you can finish it.... best way to learn it is to do it. That is how I figured mine out. He left..I had no choice but to figure it out.

just change the combo box names I have to the ones you have. If you can give me the names of yours I can try and adapt it. Also, need the data types of the fields it is using. PS, I didn't write this, I can't take credit for it, but I have modified it for my uses. It is good if you can get...

Below is a sample of code that I have in my database. I have a menu with 7 combo boxes that allows for filters on 15 different reports. Below the code checks all the combo boxes to see if it is null or not, and then if creates the string filter at the very end. I hope this helps. Private...

Herte is a link to a thread talking about what you want. This has been asked alot, so if you do a search for Calendar you will fine a large amount of info that will help you with everything.

That horn on the side is precious........:D It truely makes the bike. :cool:

Are you serious Ken?

me.[textboxname].value = Date() or for date and time me.[textboxname].value = Now()

:p You're a brat too Gregory!!!

Sure Rich!!!

Now don't be silly!! I wasn't married to that powerful of a man. He was Republican but not the President silly man!

Yes, well Richy boy, I didn't think you were old enough to remember 3 generations back. ;)

Not married at all anymore. :p :p

Who's line is it anyways is the best. The british version as well as the American version. Monty Python, I don't understand. *ducks tomatos* I just can't get into it. I don't find it funny. Almost remind me of the Three Stooges! :eek:

I do have to admit I find British humor a bit dry. I've had friends die lauging at some of it, and I just sit, head shaking wondering what is so funny. You either like it or you don't I suppose.

Be nice Colin!!