Error with macro, actualization

[Vrbic00]

I think you would be better to find a template available in access that does what you want. Had a look at the video link and looks like it is building a search form.



Suggest google 'access search form' to find an example - there will be plenty on this forum

Understand and thank you very much.
If I may I have last question I managed it. My query reacts on 2 text fields. But these are connected. Lets say in first are cities and in second shops. Is it possible to link it in such way that if I select some city I can choose only such shops which are in this city not all of them? I tried it...I created query with cities and shops and as table it looked good. But if I linked it as a source of list for second text field it doesn't work...I see only shops in this city but many times. There are duplicit shops. I tried change orde cities <->shops but it was same... Any suggestion?

[CJ_London]

sounds like what you want is what is called 'cascading combos'

be aware that normal design rule is one table, one form. At the moment your subform has three tables

[Vrbic00]

sounds like what you want is what is called 'cascading combos'

be aware that normal design rule is one table, one form. At the moment your subform has three tables

It seems that I have bad structure of my database So what would you suggest? Is some general rule how to avoid this problem?

My problem is probably in my thinking. I believe I'm quite good in excel but I need more. Here I have to think other way and it is not so easy. Especially if you get in trouble, you use your experienced procedure.

[CJ_London]

excel and access are completely different

Excel stores and displays data horizontally whilst Access stores data vertically and displays as required in forms and reports. i.e. 'tall and thin' rather than excel's 'short and wide'.

Google 'normalisation' to understand more but basically it boils down to a) store data only once, b) do not store calculated data and c) do not build data into the structure. Excel 'breaks' all these rules

[Vrbic00]

excel and access are completely different

Excel stores and displays data horizontally whilst Access stores data vertically and displays as required in forms and reports. i.e. 'tall and thin' rather than excel's 'short and wide'.

Google 'normalisation' to understand more but basically it boils down to a) store data only once, b) do not store calculated data and c) do not build data into the structure. Excel 'breaks' all these rules

Understand. These 3 things, I probably know Maybe you noticed in my database. Or I'm trying to understand, but I don't have idea what is wrong with my displaying of data in subform. I understand that I need 3 tables but I can't see other way to solve it. You do? Have you dealed with such situation? How would you solve it? And if I may, are you Netherlander?

[CJ_London]

And if I may, are you Netherlander?

nope - English with a bit of French and Welsh thrown in!

but I don't have idea what is wrong with my displaying of data in subform

what I don't understand is what exactly you are trying to do. Originally I thought it was to filter the records based an a specific value in a specific control on your form, then two form controls on two separate fields. But now I don't know

Data does display in your form if you filter for a value that exists so I think you are saying you want a method to filter the data - but have not explained (or I have not understood) the basis you want to filter.

here are some links to a search forms for some ideas

https://www.accessforums.net/showthr...ht=search+form
http://www.access-programmers.co.uk/...ht=search+form

[Vrbic00]

nope - English with a bit of French and Welsh thrown in!

I asked, because of your nickname.


May I have another question? I created special thread for it so if you have time and mood, don't worry to write there
https://www.accessforums.net/showthr...703#post330703


Thank you for all.

[Vrbic00]

Heh only problems I have here...Why I'm not able to add new record in this form? It writes "it is not possible to add a value to free field on side "one"..." or "it is not possible to add a record . A linking key of table is not in a set of records". I guess problem is in relations yes? But I don't know what is wrong or what should I to do to fix it.

[CJ_London]

I guess problem is in relations yes?

sounds like it - sounds like you are trying to enter a child record when the related parent does not exist

[Vrbic00]

sounds like it - sounds like you are trying to enter a child record when the related parent does not exist

I feel something like that but what should I do? I want to display a "names" not primary key. So I have relations between tables and in query I display data from different tables. How can I add new record in such case? I attach my file maybe better to try it.

[CJ_London]

the error is not about what you want to display, it is about adding a new record

So parent is a table called say Company

and child is a table called contacts

you cannot add a contact without first adding a company

you db is not attached - compact it then zip it

[Vrbic00]

you db is not attached - compact it then zip it

Oh sorry. Here it is.
Generally I understand but I added a "name" which is in this table. Not new.

[CJ_London]

I think you are moving away from your original question.

Note it will only display records if a record exists with both selections.

I have modified both your forms - see attached

I have modified the recordsource in LekarnyPodleMest podformulář form

I have modified the rowsource, column count and column width properties in both combos

There are other, more flexible ways for doing this, but I'm not sure of the detail of what you now want to do - e.g. is the list in the second combo dependant on the selection in the first combo? Do you want to see a list of records where a value exists for combo1 OR combo2?