Recent content by pacgoncalves

Hello I have several tables (relational) with one field - ID. I receive many DB (it's like a form but with structure mdb, just like the one i have) with one record. Now i have to append my master DB with this record. I have a small problem: how can i append all the tables with the same id...

Hi I have tabcontrol with 2 pages ( with 1 subform each ). I need 1 value from the subform in page 1 to work it in main form. Help needed. Pedro

Hello Example: 1 car have N pieces. 1 piece is in N cars. I have 1 table for register the cars bilt. From the form of this table i must have to update the records Wheels = -4, windows =-4,... in the table MATERIAIS. ex. 3 cars are made then in the field wheels = - (4 wheels) * 3(cars)... I am...

HI Rich No and i don't know where to search. I will be appreacheated. Thanks

Hello Example: 1 car have N pieces. 1 piece is in N cars. I have 1 table for register the cars bilt. From the form of this table i must have to update the records Wheels = -4, windows =-4,... in the table MATERIAIS. ex. 3 cars are made then in the field wheels = - (4 wheels) * 3(cars)... I am...

Hi Rich I'm sorry. Example: 3 cars are made then in the field wheels = - (4 wheels) * 3(cars)... I am using 4 tables in this, with this structure (the letter T is for Tables): T_carsmade N - 1 T_CARS 1 - N T_carpieces N - 1 T_PIECES This is the real structure in Access. 1. From the start : N...

Thats correct Rich. I already done that. I have a form(table) to register the number of car made in one day that its linked to my table cars. My problem its that when - in this form - i put 3 cars i want that in the table of pieces (like you explained) it will update the record of the wheels =...

1 car have N pieces. 1 piece is in N cars. I have 1 table for register the cars bilt and here i must have to update the records Wheels = -4, windows =-4,... Thanks

1 car have N pieces. 1 piece is in N cars. I have 1 table for register the cars bilt and here i must have to update the records Wheels = -4, windows =-4,... Thanks

Hello I have a one field in the form A and i would like to update two fields in the subform B. I have in both forms an ID thats equal. I programmed and everything looks good on the first record but it doesn't update the second record. I've tryed Nextrecord, recordset... but i believe i'm not...

Hello 1. Your field is just for screen - don't you want the field save the sum? 2. If yes, add one field to the table and one text box (ex. text88)to the form (not the subform). Add another field (ex. text99)to the subform. Text99=Expense Reports Subform].[Form]![Expense Totals]+[Expense...

My relationships are almost done. I have a form that update a field of stock material. N to 1 relation. Very fine... but i want that the stock field update the several materials of my stock. Like cars - you have a stock field that determines the number of cars made but you need that the fields...

My relationships are almost done. I have a form that update a field of stock material. N to 1 relation. Very fine... but i want that the stock field update the several materials of my stock. Like cars - you have a stock field that determines the number of cars made but you need that the fields...