Search results

CJ_London, I found the following code that seems as thought it would do what I need, 2_syn_1 subform.SetFocus DoCmd.GoToRecord , , acFirst My subform is called 2_syn_1 subform. It’s one of a number of subforms, each containing a combo box, that I’m using to enter data into a table related...

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

Now I see what you are suggesting. My initial reaction is that it will take up a lot of real estate on the data-entry form. I'd prefer to solve the problem another way. but if I can't find that solution, this is what I'll use. So many thanks. (BTW, I haven't been on this forum for a long while...

Thanks, Uncle Gizmo. I actually did look at the questionnaire video a few days ago, but, unfortunately it doesn't apply, and the next video also doesn't tell me how to do what I need to do. Thinking about the problem some more, I think what I need is some code for each of the subforms that...

"my original idea was to split the responses to the question to give each response its own row, which seems to me to more normalised, and which I think would be relatively easy to analyse. (I think this is a similar idea to that suggested by other posters, too)" Gemma, Splitting the...

So you're saying that it isn't really poor database design to wind up with many rows with empty fields and that I shouldn't worry about it? If I wanted to make a more compact data table later on to facilitate analysis, say to spot potential relationships by eyeballing the data, could I use a query?

Yes, but very soon the table will have so many rows that it will slow everything down. That's what I'm trying to avoid. If I use a separate subform for each of the multiple response questions, Access will create a new row for each answer for each question. Say there are four multiple response...

Mark, I’m not sure I follow your suggestion. The Question table would have fields for both types of questions—single and multiple response. If the form was attached to the Question table, how would the answers populate in the Answers table? I’m also not sure about the other two tables. The user...

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

Thanks Uncle Gizmo for your three suggestions. I was actually using tabs for sections of the core module. It never occurred to me to use tabs for the subforms for the other modules. That would make it much easier for the case readers. I think that solves my problem. I'm about a day away from...

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

datap, Sorry for taking so long to get back to you. I didn't check my e-mail for a week. It was very simple. I opened a new query in design view and added the fields I needed from both tables, which are related. Then I created a new form bound to the query with the fields from the query.

Unfortunately, I'm using XP. I can do a screen shot of the error message, but I quoted it a few posts ago, and I don't think the actual message is different. What I'm thinking of doing is rebuilding the db starting with the file you returned to me, which works, or possibly with a new Access...

Khodr, thanks you so much for your help. I checked what you did, and it worked. Great! But! The way the data entry works is that the rate is filled in automatically when the user selects a language on the parent form. If the code is in the rate text box, there won't be anything in the...

I am uploading a sanitized version of the db. Thanks for looking it over. I'll check tomorrow morning. Henry

Thanks, Khodr, Rate, Hours and Total are text boxes. that may or may not make a difference. I didn't have a format set. I set the formats and tried again, but I still get the error message I got to begin with: The expression you entered as the event property setting produced the following...

I've never compiled code before. How do you do that?

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'd be curious to see what went wrong, but I decided to try it a different way. I set up a query uniting the two tables and used that query as the record source for a single form. I was able to add records to both tables, and the problem is solved. Thanks to anybody who considered answering...