Add picked data to new table for export

[Vrbic00]

Hello, I'm preparing some database for more people something like crm. I used filter for dealing with query in a form and subform and everyone can filter his shops and his cities. But I would like to pick some shops (some lines) from this filtered table and put it in other table as a output. Could anyone advice how to do it practically?
If needed, I can attach my file but for now there is not much for watching.
Thank you all.

[CJ_London]

if by 'picking some shops' you mean say you have 20 rows and you want rows 1,5,6, and 11 (at random rather than being able to filter based on location or type or some other factor) then rather than using a subform, use a multiselect listbox (not the same as a multivalue checkbox) - in the list box properties change the multi select property on the 'other' tab to simple or extended. You will then need some vba code in the after update event to identify the rows selected and take the required action. Google/bing 'access vba multiselect' to find out more.

there are other ways, but the principle would be the same.

[Vrbic00]

if by 'picking some shops' you mean say you have 20 rows and you want rows 1,5,6, and 11 (at random rather than being able to filter based on location or type or some other factor) then rather than using a subform, use a multiselect listbox (not the same as a multivalue checkbox) - in the list box properties change the multi select property on the 'other' tab to simple or extended. You will then need some vba code in the after update event to identify the rows selected and take the required action. Google/bing 'access vba multiselect' to find out more.

there are other ways, but the principle would be the same.

Understand. And thank you.

[CJ_London]

I've just uploaded an example db here which you may find useful as another way to select shops

https://www.accessforums.net/showthr...745#post330745

[Vrbic00]

I've just uploaded an example db here which you may find useful as another way to select shops

https://www.accessforums.net/showthr...745#post330745

Thank you. I check it

[Vrbic00]

I've just uploaded an example db here which you may find useful as another way to select shops

https://www.accessforums.net/showthr...745#post330745

Hello so I moved on. I'm a bit proud of me BUT... I have still some problem. The biggest is adding data, adding new record. I probably missing some quite important basic fact. If I may I add here my file, could you check it or suggest some improvements generally? And let me know where is mistake with adding records?

[CJ_London]

The primary basic fact you are missing (for editing type forms) is the rule of one form, one table - in form Seznam Lékáren you have 3 tables which is why you can't make changes

there is sometimes a workaround where you are only changing fields in one table (in this case Lekarny) by changing the form recordsettype to dynaset - inconsistent updates

However if you do this with your present design otherwise unchanged and you change Jmeno from say Pavel to Alena it will change all the records, not just the one you are selecting (because you are actually changing the name in the Reprezentanti table, not the link which is ID field in the Lekarny table). If users are not going to change these two fields, then change the control properties to enabled=no and locked=true and you can leave as is.

but the better option (or necessary if you want to be able to edit these links) is to just have the Lekarney table in the form recordsource and instead include the relevant ID fields and change the controls for Mesto and JMeno to combo boxes with bound column of the ID field and rowsource to select ID and name from the relevant table Also set column width=0 to hide the first column (i.e. the ID field).

[Vrbic00]

The primary basic fact you are missing (for editing type forms) is the rule of one form, one table - in form Seznam Lékáren you have 3 tables which is why you can't make changes

there is sometimes a workaround where you are only changing fields in one table (in this case Lekarny) by changing the form recordsettype to dynaset - inconsistent updates

However if you do this with your present design otherwise unchanged and you change Jmeno from say Pavel to Alena it will change all the records, not just the one you are selecting (because you are actually changing the name in the Reprezentanti table, not the link which is ID field in the Lekarny table). If users are not going to change these two fields, then change the control properties to enabled=no and locked=true and you can leave as is.

but the better option (or necessary if you want to be able to edit these links) is to just have the Lekarney table in the form recordsource and instead include the relevant ID fields and change the controls for Mesto and JMeno to combo boxes with bound column of the ID field and rowsource to select ID and name from the relevant table Also set column width=0 to hide the first column (i.e. the ID field).

Ok. Well I understand. I replace it. I thought it would be possible and it is main idea of Access to replace some columns by IDs. I'm doing it such because I have a template of database and I do it as they do. I attach it here also. I'm following only form Contact list and Contact details. I see the same situation in table contacts, columns ID stat, ID country.
What is difference?

[CJ_London]

I thought it would be possible and it is main idea of Access to replace some columns by IDs

it is - and your table structure is correct. But data storage and data presentation are two different things - data is in tables, presentation is in forms and reports.

per your original db as designed, the form is a way of selecting a record to edit. So as constructed it is fine. But you want to be able to edit that form, in which case it needs to be as I described - or have I missed the point?

[Vrbic00]

it is - and your table structure is correct. But data storage and data presentation are two different things - data is in tables, presentation is in forms and reports.

per your original db as designed, the form is a way of selecting a record to edit. So as constructed it is fine. But you want to be able to edit that form, in which case it needs to be as I described - or have I missed the point?

No, you didn't. Ok, so do you suggest to replace ID numbers in Lekarny table by exact values (names etc.)?

And is good, let there also IDs because of relation between tables Lekarny and Reprezent? And use it in other form or query?

[CJ_London]

Ok, so do you suggest to replace ID numbers in Lekarny table by exact values (names etc.)?

no. the ID fields in the lekarney table are correct. I'm suggesting on your form, you replace the name control with a combobox control for the ID field

[Vrbic00]

no. the ID fields in the lekarney table are correct. I'm suggesting on your form, you replace the name control with a combobox control for the ID field

Ok, I understand where you're pointing. But what is it for? I need to show the name. No one can remember, what number is what name or what number is what city. I understand that if I use only id from same table it will work but practicaly it is useless. I can't add new record by numbers. Or am I missing something? How to solve this?
1) I need to show an exact names.
2) I need add new records somehow ...any way (same form, other form....) but by names no by numbers.
Is it possible?

[CJ_London]

2) I need add new records somehow ...any way (same form, other form....) but by names no by numbers.

You do this in the combo as outlined in the last paragraph of post #7

[Vrbic00]

You do this in the combo as outlined in the last paragraph of post #7

Aha. Ok so today I have to say I don't understand very much this paragraph. I'm not sure what do you mean by "combo boxes with bound column". Could you expand on that?

[CJ_London]

better you research yourself to find out what a combo box is and how it works

google something like 'access combobox' to find out more. Plenty of links to explain