Replies

Thanks, Tim.

I am sorry, Tim. You are right.

between 90% and 94%, color is yellow.
below 90%, color is red.

Thanks,

Hi Tim,

If the cell volume between 90% to 94%, the color is yellow.
If the cell volume below 94%, the color is red.

No, the cell volume won’t ever over 100%.

Yes, all cell volumes always rounded to a 2 digit percentage.

Thanks,

Regards,

Well, I can’t format all cells to red since some cells have volume for 0%. I will need it with no color.

Yes, those are the numbers all begins with 0, then name.

I have uploaded excel file with two separate worksheets, one is the format before the filter, and another one is what I want after filter.

Thanks again for your help.

Regards,

Are all the names preceded by a space?

Thank you so much for your help, Andrew.

But I have the last question regarding this filter request, I have another similar report that have to be filter. The only difference is it has the difference number with name in column A. What code s that I can use to filter it as you did before?

Thanks in advance.

Let’s hope that is the format then.
Amended Code Routine below covers this..

Thank you so much for your help, AKW.

I just find out the format I have on the report is a little different with what I listed before. I have attached it updated demo. How can I filter column C = 2 and list all Column A for each row? Below is what I want after applying the codes:

Below is what I have now:

Thanks in advance.

I agree with John, you ought to get the query data if you can, because this is the result of some sort of report.
But if this is all you can get, you could use the code below, assuming the layout is consistent,
although rows 1 and 2 look a bit odd.

I have also included an additional line that will apply a filter for TYPE = 2

You will need to insert a module into the workbook to apply it.

Also attached is an example workbook with code in.

Thanks, RG.

Can also provide me the VBA program to deliver what you suggest?

Thanks in advance.

Gary,

You could write a short VBA program to loop down through the sheet and if Col A is blank replace Cols A & B with the information from the record/row above.

Other than that I don’t see how you could do it.

RG

Have a look at this threadjust down the page a little.

Thanks, this works.

Just one further point…if there are any other criteria in the query, you need to repeat them on the line where you have put ‘is null’ under Outcome.

To avoid doing that you can put “Refer” or is null on the one line.

Thanks,. This works: put “Refer” or is null on the one line

Page headers (unfortunately I guess in this case) apply to every page in a report. There is no way that I know of to have it print only on selected pages. You might be able to achieve what you are trying to do with Group Headers, but we would need a fair bit of detail about your situation to be able to determine whether that would work. Is it absolutely necessary that your chart be in the page header? Moving it to the detail section or to the report header might work…

Thanks. Just find the solution for my case. I have added the following codes under “On Format” event of PageHeaderSection:

If Me.Page = 3 or Me. Page = 6 then
Me.PageHeaderSection.Visible = False
Else
Me. PageHeaderSection.Visible = True
End If

One more questions, what codes should I add to make Me.page = “auto increase three pages”

Page headers in subreports do not display in the main report. One option you might consider is to set the property of the chart to invisible, and then change it to visible if the subreport (ReportB) has no data – that is one of the code events that will fire for a subreport.

Thanks. The simply question to address my issue is: Is there a way to make a page header apply to a report without applying it to the third, six, nine page of the report?

This is likely to be a function of the verison of Access you are using, and the size of the text file. It is possible that the Transfer Text function locks the text file which would prevent UserB from opening it, though it should be necessary, since the file is only being read. So I’m afraid testing your version is likely to be the quickest way to find out. And it may be difficult to test if the file is small, as the transfer would only take a second or two for small files. Let us know what you find.

Yes, you’re right. It’s very difficult to test since the file is 2.11MB. I have tested more than 10 times, which open the two databases at the same time. I wasn’t able to produce any error. So can I assume this should be a issue, since the file is only being read when it is imported?

Thanks

You need to replace the Control Source with a conditiional expression something like:

=IIF(isnull([Responds]),”No Responds At All”,”Have Responds”)

The builder can help you construct something if you have trouble making it work.

Thanks.

Me.Name refers to the built-in Name property of a form – it’s the name that you see in the database window. You can’t change this property while the form is open in form view.

For that reason, it’s not a good idea to give a field or control the name “Name”. It causes confusion. But if you won’t or can’t change it, you must put the word Name between square brackets if you want to refer to a control named “Name” instead of to the name of the form:

Me.[Name] = varName

(I wouldn’t call a field or control Date either, since Date is a built-in VBA data type.)

Thanks, Hans. It works after I rename the control of the name “Name”.