Search results

I am updating a data entry application for a case reading study. In the past, we have found that case reviewers, who do the data entry, sometimes skip certain fields, and we’d like to make those fields mandatory. The easiest way would be to make the fields required in the table, but that gives...

moke123, Your solution gives me exactly what I want. And it's one of those ideas that's so obvious that you don't see it until somebody points it out. Thanks. Now I have two ways of going about it: the way I found on Wednesday, and yours. After some thought, I decided to use the way I found...

Steve, Thank you. I think that's it! I don't have time to try it now, but I will on Friday (Happy Thanksgiving!) I just tried something similar but based on the same idea. I created a query for the row source. The first two fields in the query were from the table, the third was an expression...

The project involves reviewing case records. There are a large number of questions, and the reviewers will be entering their selections on paper data-entry sheets. We're not sure whether they will be transferring the data into the computer themselves or there will be separate data-entry people...

I have a series of combo boxes that show two columns in the drop-down. I want to display the text from the second column in the box after a selection has been made (Access displays the first column by default). I’ve been looking for how to do this, and I’ve found ways to hide the first column...

That explains it. Thanks!

Thanks for the article. It was a challenge reading it while I'm under a deadline, but I get the point. Is there a particular way of handling a very large number of tables, about 30, to avoid confusion? Naming conventions are helpful, but there is still a clutter of tables.

That thread was very interesting. I hadn't thought of having one field for entry type and another for entries. I had thought of the table as having a case ID number to relate to to the main table and separate fields for each question on the paper data-entry sheet. That would have left each...

MarkL, Access changed its mind and went back to making the field too narrow. I used your code, and it worked beautifully. What is 1440 * 2? If I need to make the field wider, what number do I use? thanks, Henry

MarkK, For some reason, after my struggling with the problem for far too long, Access, all on it's own, decided to give me the correct field width. I must have done something different, but I can't determine what. I've compared the field that originally had the correct width with the fields...

Our data entry process requires multiple drop-downs with multiple entries for a single case (one-to-many relationship). The multiple-entry fields are scattered through the form. I've created a separate, related table with a subform for each of the multiple-entry fields. My question is, is this...

Based on more reading, I decided not to use a multiple value field. I've created new tables for each of the multiple value fields, and related them to the main table by an ID number. I don't know why my copy of Access 10 doesn't have the "Allow multiple values" options, but so far as I can...

I have a set of combo boxes that display on subforms in data sheet view. Right now I have four, but I need to add more. One of the combo boxes shows the field for data entry correctly, that is with the correct width. The others are too narrow, and nothing I do to adjust the width changes the way...

I’m trying to set up a multivalued lookup column. I tried using the Lookup Wizard, but it doesn’t have an “Allow Multiple Values” check box. The lookup tab for the field also doesn’t have that option. I'm using Access 2010, so it should have this row, but it doesn't seem to. Is there any way to...

Thanks to everybody who replied. I checked the row sources, as MarKK suggested. Nothing! Then I replaced the SQL statement with the name of the table. Now the form loads and seems to be working as intended. I will still look at the thread Glaxiom supplied the link for. Cheers, Henry

This has happened to me more than once, and it drives me nuts. It usually happens when I work on a post for more than a few minutes. I tried going advanced and periodically previewing my post. that helps, but I have to remember to do it every few minutes. Mostly, I work on my post in MS word...

It does have an explicit SQL query stored in the record source property. I deleted tblMH.4_mh_10 from the query. Now it wants an entry for tblMH.ID. Is it better to delete and reconstruct the subform. It only has 11 controls, or can I substitute the SQL statement with the actual table name?

I made one modification to my db. I removed a text box, txt4_mh_10, from a subform, frmMH. I also removed the control source in the table, tblMH, 4_mh_10. There was also a line of code that changed the visible property for the text box depending on the answer to a previous control, and I removed...

Minty, Part of my reluctance to create a large number of records was that I would have to convert the data from a spreadsheet format, with 75 test questions in the columns and test-taker answers in the rows, to one in which there was one field for all answers for all questions for all...

Hi Uncle Gizmo, I looked over the blog, and the example he gives is right on target. Of course, I would have a table with questions rather than subject, but it’s the same idea. I would have four tables: 1) tblTest_Takers, with a name field, an ID field and a class ID field; 2) tblQuestions...