Search results

That does not seem to work either. See attached.

Can you use a wild card (e.g. *) in conditional formatting. I have a report that has prirority codes. I want to highlight any that are *1a with yellow and any *1b green. So for example, any items that have a priority code I1a, O1a, P1a, Z1a, etc would be highlithted yellow and any I1b, O1b...

Wow....that seems to have fixed all my problems. I was getting error messages on other things and it would take me into debug the code, but this simple change seems to have fixed everything. Thank You! Jim

I have a database I originally created back in 1997 to manage recurring tasks for my group. As versions of Access have come along I converted it and had no problems. Now however, after installing 2007 and converting a copy of my database to 2007, it has problems. First of all, I get an error...

I have made a subform before but not a subreport. How do I create a subreport and how would I configure it to show the combined data (e.g. EventCode A1, A2, A5)? Thanks, Jim

I want to end up with the information in a report but I thought I would have to build a query as the engine to support the report. If it can be done in a report without a query, that's fine. I may need a little help understanding how to do this. An example would be as follows Record 1...

I am just reposting becasue I still don't have an answer about how to do this. Just to clarify, I want to view only ONE record, but having that record list all of the possible codes associated with it. Thanks, Jim

5 days with no response, so I am just replying to get back to the top. Thanks, Jim

I have an Access database where we grade reports. At the end of the grading form I have a memo field [Comments] for the grader to enter comments about why the report received the grade [Grade]. Each report is graded by multiple people. So for example, ReportNum 08-001 may be graded by 5...

Thats what I am doing now. Let me be a little more specific. The data fields of importance in the query are Report Number Status Approved Date When a report has been approved, the status is changed to Approved and the approval date entered. However at times someone will need to update the...

I have a query based on an SQL database that our company uses to document problems and resolutions. I need to run a report that will show all the reports that were completed in the last 30 day. The field that the approval date is documented is called dbo_approved. Sometimes a report is...

I have tried this and it has no effect on performance of the query. I may have misled you on the number of records. The results of the query is about 1300 records on the high end but the actual number of records that the query has to plow through to get there is probably closer to 6000. The...

I don't think so because the query is looking up the records for "duedte" and counting the number of times it has a different date. I am not sure how I could do that in the report itself.

See attached image. I am looking for ways to make my query run faster. When I run this query for small groups which will return less than 100 records, the query takes about 30 seconds. However I have some groups that have over 1000 records and that will take 3-5 minutes to run. Actually...

I tried a validation rule like the one below but it does not work. [PI_Score]<[PI_Max] I would really like to say the score has to be between 1 and [PI_Max]. Any ideas what I may be doing wrong? The combo box will work but it does not prevent someone from manually entering a number that...

I have a grading form where we grade reports on a 0 to ___ scale. The scale varies for each section of the report. I have a field for each section that specifies the max value. So for example for the Corrective Action section I have a grade field and I also have a MaxValue text box to...

Something makes this example progress bar slowly progress then go away. Is there a way I can slow it down, then not go away until my query is complete? The reason this query takes so long is that it is calculating the number of times each record's "due date" has been reset. So sometimes there...

I am afraid there's not just 3 comment fields but more like 10. It would be a mess to combine all of these into one and difficult for the end user as well. I am afraid I am stuck with the comment fields being separate.

I am trying to implement the progress bar from this post. I have a form (frmMain) with a button to launch my report (rptRoutineCA). The report is based on a query (qryRoutineCA). The query / report usually takes anywhere from 15 seconds to 3 minutes to run depending on which group I select...

I am not sure if this is the correct section of the forum, but here goes. Lets say I have a database with the following filelds Site Group Date Section1Comments Section2Comments Section3Comments I ultimately want to build a report to show the Site, Group Date and comments from only one...