Search results

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

Just to explain better: Let's say I'm God and I have the table AnimalFamilies which is linked to the table AnimalSpecies: 1-to-many of course. I build my Form AnimalFamilies and I want it in the "all-records-consequent-view" to keep track of every family I add and modify. But I also want every...

Thanks Sam for your help, it was really interesting BUT it didn't work. Perhaps I forgot to tell you my form is a "all record view form" (sorry, I'm trying to translate italian Access words in English) and I want that txtbox for EVERY record to have a fast glance of this stats. The way you...

I already posted this in FORMS but I don't know if the problem could be in the query. Well, I made a query in which appears every record of a table and a simple new field that counts related records from another table. It works perfectly. But when I want to build a Form to modify or add records...

I modified a form and now it seems it's impossible to modify/add records. It seems that all comes from when I modified my record source query to add a a field in which it COUNTs all related records in another table. Now the form can't modify anything else but I need to change other fields or add...

Thanx!!!!! It works!!!!!!!!!! I was sure it was that simple.... bye