Search results

Mark, That does help, but it's hard to translate the general principle to the specific problem. I did find a model for a test db on line, but it wasn't close enough to what I need to adapt. I'm going to follow The_Doc_Man's suggestion and look up "Questionnaire" to see if it gives me the...

I’m trying to create a test-taker profile. The test has seventy-five questions, and there are 130 test takers for the current administration--there will be future administrations. The profile should have three pieces of information for each test taker for each question: whether the test was...

Multiple partial records is exactly the problem.

jdraw, Your suggestion is a whole lot simpler than what I tried to do. If I had only thought of it, it would have saved me hours of work, and since I would simply be appending records, I wouldn't need to worry about the 99999s since that field wouldn’t be involved in joining queries. I don't...

Plog, My understanding is that in a union query Access counts the number of fields from each table/query against 255 field limit. That would mean 185 x 5 = 1275 fields. If I’m wrong, I did a lot of work for nothing. The reason for four tables (not fields) to hold 185 fields is that each table...

In a case-reading study, there are 185 fields for five readers to fill in. Our IT department gave each reader a copy of the db to use. Each db has a slightly different name that includes the reader’s initials, e.g. QPR2_MA, QPR2_EF, etc. To bring the data together, I need to go into each...

Thanks to Cronk, The_Doc_Man and static, The problem was to prevent invalid data from getting into the table, and I realized there was a simple solution. Right now each text box that that requires the next text box or boxes to be skipped, depending on the value, has code that makes the boxes...

I googled it, and I took a look at the Wikipedia article and a tutorial for C++. It will clearly take some time and concentration, but a whole new world is opening. Thanks again, Henry

Mark, Thanks for explaining the lines I was confused about. Users will enter data once and possibly return to it if the Quality Control reader flags a wrong entry. Otherwise, it’s a one-off. For another project, I may need to know about bundling set-up work for every record loaded into a...

Mark, I see what you’re saying, and I agree that it’s worth going further. I mostly understand this code (I’ve changed the control names and values to the ones I’m using, and I’ve put my questions in brackets ). private sub ResetForm() 'enforce rule for dependent value AND enabled If...

Dave, this is interesting as general information, but can it also help with data validation? Henry

Mark, Thank you for your illuminating explanation of the mysterious values I've been getting. Clearly it pays to know how Access (or any program) does its work if you want to avoid surprises. I discussed the way forward with a colleague, and we concluded that the probability of more unforeseen...

Mark, This is where it all started. I used Me.TR_3.Value = 0 Or 1 Or 2, but I got 3 when I saved the record, which is not what I expected or can explain. It also isn't a valid value. When I substituted Me.TR_3 = 0 Or Me.TR_3 = 1 Or Me.TR_3 = 2 and entered 1 in TR_3, the 1 changed to -1 when I...

I checked. It's number.

A colleague and I looked over the code in the control and for the form as carefully as we could, and we couldn't figure out what could be causing the problem.

Ranman256: First I changed Me.TR_3.Value = 0 Or 1 Or 2 to Me.TR_3.Value = 0 Or Me.TR_3.Value = 1 Or Me.TR_3.Value = 2 and entered 1 in TR_3. When I saved the record, the 1 changed to -1. Then I realized that your correction left out the "Value," so I tried it without: Me.TR_3 = 0 Or Me.TR_3 = 1...

I need to control invalid data for several text boxes. For example, If a user enters a 0 in text box TR_2, then text box TR_3 becomes invisible and focus shifts to TR_4. However, if the user enters a value in TR_3 first and then enters a 0 in TR_2, then the (invalid) value in TR_3 is saved. It...

On my form if the user enters a 0 in text box TR_2, then text box TR_3 becomes invisible. However, if the user enters a value in TR_3 and then enters a 0 in TR_2, TR_3 will contain invalid data. To prevent this, I put in a sub before update to change the value of TR_3 to Null if TR_2 contains a...

In trying to describe what I believe is happening, I discovered a different problem that is potentially more serious. First, an instance of the original problem: in the table, DropdownDataQPE2, the field 1_S-gui_1_a has an entry on record 9. This entry belongs to case 2, as indicated in the...

I attached a zip file of the db. At this point, I am testing using made up data, which is what you will find in the tables. There are two related tables for entering data named MainDataQPR2 and DropdownDataQPR2 (QPR2 is the name of the project). The other 26 tables feed dropdown lists. Because...