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

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

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

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

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

Hi, I'm new to Access. I'm trying to do a very simple thing but I can't. Let's say I sell a lot of cars, every day so I need a database only to collect info about selling. I need a table (SoldCars) which need refers (read: field) to 2 other tables: 1.Constructor and 2.Model, or only to Model...