Search results

Thank you RainLover. I am sure I will face some more problems in the future. I think my database is too simple to show it everyone here. If I get much better one I will post it here. Now I think to build database controlling home budget. See you soon. PS Apropos previous database about Magazine...

I've changed everything and I made it easier. I moved 2 fields from table Magazines (MagazineYear and MagazineMonth) into main table Articles and I left table Magazine for field MagazineName and Branch. And I redirected 2 combo box controls into right locations and I could use RowSource as list...

Yes, RainLover, I mentioned this before that I am going to split table Magazines into 3 separate tables and associate them with main table Articles. And in this way all those 3 table will have unique values and I will build 3 combo box controls using RowSource as those 3 tables.

RainLover, I think you did not understand it. There is no problem with relationship between 2 tables and all values are passed on properly. I had only problem with displaying those repeated values in combo box controls from table fields where are really some have the same values but I said ID...

I think I will do it simpler. I just create another 2 tables for MagazineYear and MagazineMonth and tie them with main table with their IDs and each table will have unique values and then create combo box controls based on their tables. And I think it will be the simplest idea without any other...

RainLover, I think you understood me wrongly. I did not want to edit combo box controls and insert something new which is not row sources of this control but probably I will do it later. Now, I wanted to list unique values in combo box. This combo box has row source taken from query based on 2...

I think I've found solution and my data base works properly. I did it myself because nobody was able to help me in it. I can tell you what I did wrong. When I built combo box I should tie it with Magazine ID in the table. Before I tied it with other fields like Magazine Name, Magazine Year or...

Jdraw, I did not know this forum and another one you dropped the link are connected in any way. I thought those forums are completely separate. So I am sorry for dropping the same posts in both forums.

Maybe it is a good practice to do that, mate and I am going to change my habits about it but what you said did not help me in any way to solve my problem which still remains unsolved.

No, I have just made mistake writing about it. I should write ......ID magazine is not selected at all!!! You reckon that naming with space is wrong? Maybe I can change it because I doubt if it will fix my problem.

I've created simple base with 2 table related each other. Then I've built query with the fields taken from both tables and finally I've made the form with some combo controls. There are 2 tables: Table articles with following fields: ID (main key), article Article name Article type First...

In which view? It was design view and I've done it already. Thank you, mate.

Which option in property window is responsible for group lining up of some controls vertically? And how to ungroup them to allow resize one individually. I could not also find option in menu for removing pre-formatting of those controls.

But I've done the form based on fields taken from tables and it works but before you must make query having fields of those 2 tables and then I create the form based on this query.

I have partly solved my problem. I have just build another data base from scratch and new works now. I don't know what was wrong before. What I changed was I set type of primary key for second table as autonumber.

Here is my data base and please help me to find solution to fix the problem. I can not add new records into the form.

I still have different problem. I can type values in the fields of form now but when I select value from combi controls which is fixed with field of name instead of its id I get error message now that this key can not have null value. I can not understand this if I select name so associated its...

Its really nothing there. I meant all options in property windows for any form control. There are plenty of them and I don't know how to use them.

Thank you mate for your help. I have really forgotten to include one relational key in the query and after adding it all works!!!

To understand better how to set all controls in the form I would like to get complete information about all property options. Any suggestions where to get them? All tips and links are very welcome. Thank you in advance.