Search results

Ok, I got it to stop giving that error message, however I am stuck on how to make it populate the form. The code was orginially made to add criteria to a report. Here is the code below, however I can't get it to populate the boxes with the data. In order to get some of it working you...

In the zip file I didn't see that form name at all, and all the forms you ahve there I didn't see one with any view form button. However that code I gave you is to pull a report, I am sure it can be converted to work for a form too.

Behave Colin deary!! *playful stern look*

\what is the name of the form, I do not see a form with a button to have a cilck even, other than adding new records. I;ve a headache today, so I am not really thinking clearly. You've caught me having female moments deary, so for that I apologize. I'm trying really I am.

I do not see the forms you are refering too with that code?

OMG, that is sooo funny. That also reminds me of the World Series, and the Super Bowl, and the Play Offs....:rolleyes:

Deary, I don't see what you are talking about in your attached database. As for fieldnames, it is a VERY bad idea to have fieldnames in your tables with spaces etc. If you want it to be shown like you what, change the caption to it to have spaces and stuff, but not in the actual field name itself.

Darlin', Brat, Bratty boy, Honey bunches of oats, Sweetie pie, Brat, Honey, boy, Richy Boy, Richard.... Is that enough?

No, refering to you as darlin'. :p Brat!!!! :p

Well considering i've only been married once, I suppose it would have to be my ex darlin'. :rolleyes:

You're very welcome, and good luck. I'll be watching the forum for the next few days to see if you need any help.

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.