Recent content by Mecha

No i am still having problems with the many boxes. i have about 7 as well. Still having a go at it myself, but i have a feeling i have no idea Tell me if you have any luck Carly

Thanks Jeff, you code worked, I wont put it up here cause it is the same as the one Nate published. Thanks idd for all your help too. Carly

Hi, been looking after sick boyfriend all weekend, jerby, will send you mail very shortly thanks Carly

Okay, i have had a play with the new code, thanks Vince, but..... the parameter boxes still remain. I was reading that they can be caused by something in the report like sorting and grouping, not the form. I dot have and sorting or grouping so that was not the answer, so I tried playing...

Sorry guys, havent had a chance to try this out yet. Will get back to you! Thanks Carly

Okay, i decided to fiddle some more and i think i have got it working better, at least it will generate the reports now Here is the (almost) working code. It will now do report when nothing is selected in the list box. Thanks Idd Private Sub OK_Click() Dim RepTo As String Dim frm As Form, ctl...

Hi I am having a similar problem I tried the removing all instances of my "country" field and then replacing them, but the same "enter parameter value" comes up I am using a list box to enter the criteria. When teh pop up comes up it has the name of the selected criteria...

Hi Well, i think i have been fiddling with the code too much cause now it doesnt work at all. The annoying thing is i kept a copy of it before i started to change it but even if i put it back to the original it still wont work I am not getting any error messages at all now, but clickling the OK...

Hi I tried just removing the lines, but then the report doesnt run at all then. If there a way to say If ctl.ItemsSelected.Count = 0 Then "select all"?? Would it be better to use another control that when you click it, it automatically selects all? I tried doing like a keypress...

Hi Rick I am also trying to use listboxes to run a query and generate a report, i can get it to work when selections are made, but when no selections are made i want the query to use all the items in the listbox. I tried just removing the whole If statement, but then the report wont open As you...

Hi idd Thanks for all your help, but it this code doesnt seem to work for me. when i push the okay button on the form, instead it asks for parameter values for the choices i made in the list box. If i push Ok with nothing enetered, it does at least open the report, but it is empty. If i type in...

Hi I am trying to do a similar thing with my database. i have a number of country names and other critera that i would like to be able to select more than one of to generate the rpoart with. I dont know much about code and am using a SET VALUE macro for the okay button on my form. Does this...