Recent content by dafne

Hello, Pat! Mea culpa, then. I should have explained myself better. In my continuous subform AbstractAuthors, I want to make sure that the first author entered gets the label "1" automatically, the second author "2" and so on. For example, for abstract ID 46: (first combo) José Teixeira (ID 25)...

Thank you, Pat! I tend to agree with Galaxiom, though, when s/he says But I'm embarrassed to say I haven't been able to implement Galaxiom's solution. :o I've created a Priority (integer) field on my AbstractAuthor junction table and linked it to a control on my AbstractAuthor subform. I'm not...

Dear Galaxiom, Thank you. I do have a Unique Composite Index (AbstractID + AbstractAuthorID) on my AbstractAuthor junction table. Does that mean I have to change your code?

Dear ridders, Thank you for your reply. No, I don't have a 'date entered' field. How and where should I add it, if it's not asking too much?

Dear all, I've been working with (what I hope is) a normalized database I've created to help me organize a conference, and in which I've had to establish many-to-many relationships through junction tables. For example, one abstract may have multiple authors, and an author may have submitted...

Oh, wow! I'd never been thanked before! :cool: I wanted to save this salience score into my underlying table, so here's what I did (maybe it'll help someone else): used a text box (txt_salience) instead of a label (lblResponse) and linked it to a field in my table changed "lblResponse.Caption"...

OK, I think I got it to work (kind of). I tried clicking on one of the check boxes and the event fired. Maybe I'll try another kind of event because I don't want to go through every check box all over again. Also, I had to change "scores" into "score" in the code above. Thanks a lot...

Hi, arnelgp. Thanks! OK, done that. So I tried to paste "=ShowResponse()" in each check box's AfterUpdate but it wouldn't let me. I wrote "ShowResponse" instead. Done that. All I did was replace "checbox1" etc with the actual names of my check boxes, I used the same names as you did in your...

Thanks. It’s probably number one, I guess. I tried changing a few things, but something’s still missing. Here’s what I have: three tables (one containing my records, another containing my features, and the junction table), a main form showing the record_ID and the text of the record and a...

Hi, Ranman! Thanks a lot! I removed the relationship between tbl_NP_feature's "NP_feature_ID" and tbl_RecordsNP_Features' "NP_feature_ID". I was still getting the error, though, but basing myself on what you said ("1 Record owns many RecordsFeatures") I linked tbl_Record's "record_ID" to...

Hello all, I come from this thread and perhaps you'll be able to help me. Basically, I want to analyze sentences according to different semantic features: for instance, in "My mother loves cats", "my mother" is "definite", "referential", "concrete", etc... all at the same time. I have three...

Will do. Thanks for everything!

Yes! 2276 of them. I'm uploading a sample DB with only 10 records. Thank you very much for your help!

Thanks for the articles. I'm still getting a little error: something like "You can't add or change a record because the associated record is required in the table 'tbl_records'" (this is a free translation from French). Where is this coming from? My "master field" is record_ID from tbl_Records...

Thank you! I created a junction table, as you suggested. I'm uploading a few snapshots so you can tell me (if you're willing, of course!) if I did it right. As for the subform: I never had to use one before, so my questions might seem silly. Here's what I did: I created two forms: my main form...