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...

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...

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...

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...

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...

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...

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...

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...

I have a series of combo boxes on subforms whose control sources are fields in a table that has a many-to-one relationship to the main case-information table—meaning that there will likely be several records for any case. I need each combo box to open onto the first record for each case rather...

I am designing a data-entry system for an ongoing clinical case-reading study. There are two kinds of questions for case readers to answer and input data: about 60 that require a single answer and another approximately 25 that can have more than one answer. An example of the latter type is...

I am designing a data-entry system in Access 2003 for a clinical case-reading study. The questions that the case readers have to answer are divided into modules, and different batches of records use different modules, but all batches use a core module which includes identifying information and a...

I’m trying to have a text box display the result of a calculation based on two other text boxes. The text box, txtIntptotal, should show the result of the contents of txtIntpHours multiplied by the contents of txtIntpRate. I used the following code, in the After Update property for txtIntpHours...

I have two tables with a one-to-one relationship. I’m using a form and subform to allow the user to enter data. When I test it by adding data in the text boxes on the main and sub forms, I find that a new record is added to the table bound to the main form, but not to the one bound to the...

On a form I have a set of dependent combo boxes. I want to the user to be able to use these to edit the information in the underlying tables. I set the row source in each box to the appropriate table, but when I set the control source to the table I want the user to be able to edit, the same...

I’m trying to have a report where the user can specify a reporting period. I set up a form with a command button to run the report and two text boxes for the user to enter the start and end dates. Then I added the following parameter in the date field of the query that feeds the report...

In a report I need to calculate a total amount spent for a time period (a quarter) and the remainder available for the rest of the year. If I’m creating a report for the first quarter, then the problem is easy, simply subtract the amount spent from the amount budgeted for the year. The result is...

I'm setting up data entry through a a combo box. The data are names of social services agencies. Some of these agency names have apostrophes in them, for example, Children's Aid Society, or St. Vincent's Services. In testing the combo box, when I come to one of these agency names, I get this...

I need a set of cascading combo box on my form. The user will be entering data about cases belonging to social service agencies. The user needs to enter the name of the agency and then the name of a program run by that agency. The names of the agencies and their programs are in a table called...