Search results

Hi all, In the attached access file there are two issues that I tried to resolve without success... therefore would like to ask your help. 1) In STUDENTS DETAILS form -> GRADES page I would like the combo box in the subform to keep the teaching unit instead of IDtu. 2) The value of IDtu...

Craig thank you very much for helping! Also, I apologize for my late response... I was away from my work for a few days. Your reply helped me to realize better the structure of the base as well as the relations of the tables. All these days I was trying to create a relation that will...

Ok, here is the file attached... Many thanks for helping guys!

I cannot upload the file, I get the message invalid file...

The db is not in English, however, I created the attached sample in English that shows the main idea.

Any help would be most welcome....

Many thanks for helping! Using the usual many to many relationship approach the two IDs (StudentID and TeachingUnitID) fields of the third table must be filled in every time we want to relate the teaching units to a student. Thus, every time I open the second page not all teaching units are...

I have already tried the approach many to many, it does not give the expected results. It looks like i need a mechanism where each student is automatically related with all teaching units from table GRADES.

Hi, I try to create a student administration database and need some help… I use two tables, table STUDENTS and table GRADES. Table STUDENTS stores all the usual info (name, address, tel, email, etc). Table GRADES has about 10 fields, the first has the manes of the teaching units (about 10) and...

oh yes! Thanks Rich and Brian!

Cheers Rich, i am not sure what you mean, please help further...

Thanks Rabbie, so is there a way to have the function output as date format and at the same time not to display the #error when the interval field is null?

Hi, what's the way of using DateAdd function to return blank instead of #error when the interval filed is null? I did try the following expression but the results is string instead of date. NewDate: IIf(IsNull(n)," ",DateAdd("m",n,date)) regards, pavlos

eventually i choose the easy way, both tables in one and it works fine! thanks guys for helping!

hm... let's say the table eventually reaches to have about 40 fields and more than 5000 rows, will it be ok?

well i deleted the 2nd page of the tab control, still the key in the second table does not update! i wonder why is this happening??!!

Bod, The pk field name of the Master table which is CustomersId. I use a tabbed form with a 2 pages, the 1st page displays fields of the CUSTOMERS table (master) and the second page displays fields of the DETAILS table. Both tables feed a query (cause i need to perform calculations) and in...

sorry Bob i had to leave my office for an hour...

Bob, i am not sure if i can undrestand you here... do yiu mean the value of the master pk?

Correct each record from CUSTOMERS table relates only one record from DETAILS table. I thought of using one table for both of them but I am a bit hesitant cause that table will have more than 30 fields! it's a dilemma...