Search results

Thank you very much for your help. While the solution is seemingly simple for you, my skill set is not there "yet". Every little bit helps. I will mark the post as solved.

Thank you so much. Here is a makeshift version.

thank you again for trying to help me. I'm still lost and I guess I'm just not getting it today. I appreciate the time you have given me and don't want to waste any more of it just because I don't get it.

Thanks for the note. I did actually watch your video several times earlier this morning in order to come up with an answer. You do show how to use Ubound to find the first instance of a chosen record. However, I was not able, even after watching it several times, to determine how to get all...

If I understand correctly, then if my multivalue field has the following: ID Name 1 John 2 Sam 3 Karen I would have to check each ID # in the query in order to determine if I get a result? Sorry, I am obviously not getting it. Thanks

Thank you for your reply. Yes, it is of the checkbox type. I believe I also attempted what you suggested but I have always found that in the statement If Me.nameOfControl.Selected(i) , Me.nameOfControl.Selected(i) always seems to return a value of 0. Test DB attached.

Thank you. I like the idea. What do I use as criteria with the Value column to select the items selected vs those that are not? Not Null?, True?

Hi, At the risk of getting yelled at for asking a multivalue combobox question, I would still like to know, how does one cycle through a multivalue combobox to obtain only the records which were selected? Combobox is called NamesList I am using the following without success. For Each oItem In...

I really appreciate everyone looking at this. I did create a new report but was not successful in seeing the report. Would you mind sharing yours that you created? Thanks

Thats very interesting. I opened back up what I sent and can see the pie chart in ProjectCostSummary

My apologies for the delay. I had to re-create in new DB to be able to send. Thank you for taking a look.

Yes Sir. Same results. On the standalone report where it displays with no problem, I don't seem to have any issues. As soon as that report though is inbedded as a subreport in another report, it no longer displays. It is no longer visible in PrintPreview and it does not print out.

I did not until you sent your reply. Printing the report where the Pie Chart displays, works fine. Printing the report where it is in-bedded as a subreport does not work. No error messages are displayed

I have a Pie Chart in a report that works just fine. As soon as I place that report with the chart into another report as a subreport, it no longer displays the chart. I tried look at master/child links, which to me seem correct. Record source for the Pie Chart is a query. I have also tried...

Thank you everyone for your suggestions.

Hi everyone, Background: I am trying to simplify invoice entry. The user enters the activity to be invoiced using form: "ServiceCharges" The invoice activity for each record could potentially be charged across multiple client projects. To do this, the user selects one or various client...

Within the "Report Center" tab, the user should choose a filter to filter the report that is in place. I would then like to be able to print out the resulting report. I can't seem to accomplish this as the SubReport is part of a form on a tab control. Would love some help with the VBA to...

I believe I was able to make it work. It was looking at column 0 which I believe is the checkbox. I changed the column to 2 and it seems to work fine. I'll still take what you have for multivalue listbox please

I like it. Thank you. I'm attempting to learn what you did and as such was looking to first do the single list box example using my db. However, I am getting hieroglyphics for the filter. Would you know why?