Recent content by hortense76

I have a Form and a all-records-view Subform each based on tables "Chapters" and "Paragraphs" In Chapter (and Form) I have a field "ParagraphID" which relates to the 1st paragraph of current Chapter. Then field HowManyParags gives the number of paragraph of this very Chapter. Basically I can...

thanks, done it with Dlookup by serializing query.

thanks gemma, your suggestion seems perfect on the side of creating the string. Anyway I have a problem with the recordset object and with the openrecordset method: when I try to open my query as CurrentDb.OpenRecordset("MyQuery") (or in any other way) it calls the debug for...

I have a problem which I think it can be split into different ones. I want to create an event which automatically fill in the textbox AllText in a Form (based on Table1) with the SUM of ALL text strings (in this case all of only one character) found in Field1 of all connected records of Table2...

Once again, THANKS RG :)! It worked. Strange there's no build-in feature like this: an automatic counter field... anyway: fine everything ends fine! Thanks again

Hello. I'm trying to add a counter to the fields of a query. Purpose is to have a second query choose from this a selected record and next x records, which, of course have been already sorted by first query itself. I thought the simplest way was with a simple automatic-generated counter, but...

Nevermind, RG, I made it with problem 2 myself, your help was very useful. Thanks!

...It seems somehow rough but it also seems to work properly. :) Thank you very much RG!

:p it was that simple! Now it all works! thank you Sam!!!:D

Thank you a lot Sam, but I found another problem: your system is great but in some manner triggers the update of table when I'm entering a new record, because it assigns some values to real table fields. The result is quite bad because of some conflict with other processes connected to new...

I have a small problem: I just want my form to update the current record because I'm opening (with a button) a second form which uses the values of some of its table fields. If I open 2nd form without updating, it will use old values, and if the record I was worknig with is a NEW record, 2nd...

Ok, I made it. Only 1 little problem: refresh is done only when I go to the record, but anyway, anything else works. The difference is you made a new field DIRECTLY in the table. That was the simplest way. Thank you very much

Thank you Sam! I've been away from work but now I see your post. I see that your example works perfectly. I wonder why I couldn't. Now I'm trying but now I really can't tell which detail could have made the difference... Anyway, Thanks a lot.

Still STUCK! Please someone help me! I'm completely sure it's a problem so simple to solve but I'm stuck! Tahnk you

Thank you lagbolt, but I couldn't make it work (error in syntax), perhaps because Access don't let me use Dcount in the ControlSource... Back to the start...