Search results

paultax, I copied all the controls onto a new report and it worked. Thanks for the suggestion!

Hi Fifty2One, It puts the brackets around Page automatically. If I take them off it puts them back on. I changed it to = "Page " & Page & " of " & Pages but it still was Page 1 of 3 on every page. I even copied this from another report where it worked. There must be something weird about...

Hi Fifty2One, It puts the brackets around Page automatically. If I take them off it puts them back on. I changed it to = "Page " & Page & " of " & Pages but it still was Page 1 of 3 on every page. I even copied this from another report where it worked. There must be something weird about...

I have a text box in my page footer with control source ="Page " & [Page] This is supposed to give Page 1, Page 2, etc. However every page is coming out as Page 1. Any help is appreciated. Thanks!

I changed the query to find the top value using method 1 from MS Knowledge Base article #153747. The top value query was based on 4 queries/tables but I was able to simplify this to 2, one of which contained the >=1000 criteria. I was able to simplify the report so it was just a main report...

I am trying to print a report with a page for each facility, and each page shows the patient with the top total payments at that facility, and a list of that patient's claims. However, the page should not display if the total payments are <$1000. I have a main report which displays the facility...

I tried it again, and it was faster this time, but still not as fast as the other form. I think it is a little faster than it was originally. The two forms should be getting opened at different times. The only major difference between them are different underlying tables. The indexes of the two...

I have two forms, each with a subform. The two forms and subforms, the underlying queries and tables, have similar structures. One form runs reasonably fast but the other one is a lot slower. When opened it was taking about 12 seconds for all the fields in the form and subform to populate. There...

I tried another copy of the database, and there the combobox showed all the patients. So I copied that combobox to the active db. It still worked, so I solved the problem. I still would like to know what caused it though.

I have cascading comboboxes on my search form. The first selects a year, the second all hospitals with patients who had visits in that year, and the third is supposed to be populated with all patients who had visits at that hospital in that year. When I click on the third combobox, the results...

Thanks for your reply, Pat. I thought that was probably the case but it didn't hurt to ask.

Thanks for your reply, gromit. However, I ended up not having to do this. We are using a simpler method, and it was assigned to another analyst anyway.

Yes, it was bound to the table field. However, I decided to use a similar field (frame) which was on the previous version of this form. I copied the frame and it works OK. Thanks for your assistance.

RuralGuy, thanks for your reply. I tried your suggestion but it did not work.

I have several option groups with options Yes/No (radio buttons) on a form. When the form is opened they should all have a default of No. This was working. Recently I added another Yes/no option group to the form. However, this option group shows no default when the form is opened. This option...

When I create an option group, the buttons or checkboxes appear to the left of the labels. Is there an easy way to make them come out on the right side of the labels? When I move them around manually it is hard to make the buttons align properly with the labels.

Gromit, Thanks for your response, but I guess I was not clear. "M*21994" is not the MLNAME. It is the HeaderID. All the HeaderIDs have the form "M*" followed by a number. The NewbornIDs are just a number. These are the PKs of the respective tables. I am comparing some of the other fields, such...

I need to compare multiple fields in one table with corresponding fields in another table. For each field that matches I will increment a weighted score. Then, generate a report showing all the possible matches above a certain total score, showing the record IDs of the possible matches, and the...

Thanks for your suggestions. I got what I needed though, by putting the union query into another query which summed each field. I also changed the average length of stay field to Total LOS (sum of LOS) and calculated the average in the report.

SamDeMan, Thanks for your reply. I used nz in textboxes on the report which is based on this query (the original query without union). It did not work. I think it would have if these rows appeared in the query with null values. But the rows do not appear in the query results at all. I am trying...