Search results

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

Thanks, plog. How do I do this? Do I create a relationship between tbl_record's record_ID and tbl_features's record_ID? Or is tbl_feature's record_ID a lookup field? I'm uploading a snapshot of the feature's table.

Hi, I've been reading this tutorial and I've already made a few changes on my DB (I already had separate tables for most of my categories but no relationships). Here is an example of what I got: 1) a table "tbl_records" containing the fields a) record_ID, b) record_text, c) variety_ID 2) a table...

Dear all, Thank you, thank you for your precious advice. I'll try to make the changes you suggested and I'll get back to you!

Hi, Pat. What I meant is that if I add a new category to analyze, I have to do it for every record in my DB. This is not something Access can do through a calculation - e.g. it can’t tell that “cat” in “My cat died last week” is “referential”. If it could, they wouldn’t need me to do it! :D

Thank you! Yes, the entire sentence is stored in a specific field of my records table. New records may be added later (I'm done with it for now, though), but the list of categories is pretty much closed (I already have more or less 40 criteria to analyze and my DB contains 2300 records, so every...