Recent content by SpaceEd

Hi KMP585, I've been experiencing the same problem. So you're saying when you "Auto Order" the tab order again and then reset, it worked for you?

Thanks! I actually implemented a solution somewhat similar to that nanscombe. It seems to work great so far. Thanks for all your responses :)

Thanks Alan! That worked great! But is there a way to run several cases at 1 time? In other words, is there a way for it to check if any of the criteria have a 1 or 2 in it, then disable? ie. Select Case [Crit1] [Crit2] Crit3] Right now, I have this, but could I change the top line to do this...

Hi, I have 5 categories that need to be ranked from 1-5 with an A, B, C, or D attached. For example, Crit1 could be ranked 1A, or 1B, or 1C, and so on until 5D. However, there are fields later in the form that I want to blank out unless any of the 5 categories is in the 1 or a 2 rankings. I...

Correct, which is what I did in the attached database. I've been playing around with the order, but it still doesn't seem to work with many fields. Any ideas?

I apologize. That report should show all the levels that are required. So for Fun 1, Fail A, Effect C, there should be a "Cause" in the next column, and a "Control" in the following column after 6. Below that between the 3 and the 2 there should be another "Control." Between Effect F and 4...

Hi vba, This is almost the perfect solution! Except when there are several more fields, there the same problem occurs (in report highlighted numbers indicate missing fields when they should appear). Is there just a few morel lines of code to completely solve this issue? It seems like this is...

so as you may see in the report: for Fun1, FailB, "Effect C" disappears when it shouldn't for Fun2, FailD, "Effect F" disappears when it shouldn't

hmmmm... I've been trying to save it into Access 2002, but for some reason it removed my report and won't save it. The pdf attached is the report output that Access 2010 provides. the "tester.mdb" file has the tables that the report pulls data from.

Well it is actually a string of maybe 8 fields. They are all on one table. The reason I didn't use queries is because it was difficult to create a form to append the query that referenced several tables. I can provide a sample database. It is attached. If you go to "search", then click "15" and...

Thanks for the response :). Yes. I grouped each one of the fields (there are actually more than three fields) with the text in the detail section and the labels in the header. Each group section header is minimized to zero. I experimented with vba code on the input form creating a numbering...

Hi I'm trying to make a report that hides duplicates. I have several categories such as "Function," "Failure" and "Action." They have something similar to a one-to-many relationship in that there are several Actions for each Fail, and several Failsto each Function. I have the report in block...