Problem with append query for multiselect Combo Box (has 2 table)

[ahmadrezaahmad]

hello
"I have 1 "main" access file and "Portable".
in the form of main I creat buttom to open and apped the table of other access file-portable.accdb- to the main table!"

I had a problem before about attachment field appending anj JHB solved that problem in this link.
"I have 1 "main" access file and "Portable".
in the form of main I creat buttom to open and apped the table of other access file-portable.accdb- to the main table!"

plz see that problem and download attachment of that topic.
but I want to append a table with multi select combo box.
that combo box field has query from table "list" and i want to append this 2 table (asli & list) to a main database!!!
what can I do?
attachment instruction:
1-solved pervious problem(OK)
2-problem with combobox query(has ERRROR)

tnx!!!

 

[ahmadrezaahmad]

JHB please help me!
tnx

 

[ahmadrezaahmad]

these link mybe help for solution of this problem but Im amature in vba codding:
http://www.tek-tips.com/viewthread.cfm?qid=1654446
http://allenbrowne.com/ser-42.html
http://www.access-programmers.co.uk/forums/showthread.php?t=204915
http://www.accessforums.net/programming/how-update-multi-value-field-via-vba-21259.html

 

[Cronk]

I can help but I need to understand what you are trying to do step by step.

Can you guide me through the steps one at a time and explain what is supposed to happen.

I can see Main.accdb and Portable.accdb

Step 1
?

 

[ahmadrezaahmad]

Thanks for the answer.
Well I hope to be able to explain my problem.
My project is to process the information in the file format of multiple users is taken portable.accdb.
After portable.accdb the files that the user has to be aggregated in a file called Main.accdb.
I was able to append functions to do the attachment field (Appendix I)
Now my problem is if the table has a field that contains a select list of the query combo_box_multi_valued other tables are formed, what should I do? (Appendix II)
Many thanks

 

[Cronk]

You did not answer my specific question.

What do I do? I have main.accdb and Portable.accdb.

What is the next step in the process? Do I open one of theses and do what?

 

[ahmadrezaahmad]

sorry...
please open main.accdb in folder:"2-problem with combobox query(has ERRROR)" and on bottom append in form of the main.accdb insert a code that can append 2 table of portable.accdb in to main 2 table!!

in folder "1-solved pervious problem(OK)" I have 2 file that OK and appending in successfull!(=without [from] field that multi select combo box query)

 

[ahmadrezaahmad]

in folder "2-problem with combobox query(has ERRROR)" [from] of form of portable.accdb has a bug .
please open the file with shift key and see table and ignore form of it

 

[JHB]

Try it now.

 

[ahmadrezaahmad]

tnx jhb for yout reply!
but the file that you attached has a one big bug that is when appended table asli to main file the value of field [from] select from table list of main db not table list of portable db.
for example user in file portble select [from] id=1,2 of table list of portable.accdb={aa bb &cc dd} but main.accdb append record show from id=1,2 of list table of main.accdb={main main/sub sub}
tnx

 

[JHB]

tnx jhb for yout reply!
but the file that you attached has a one big bug that is when appended table asli to main file the value of field [from] select from table list of main db not table list of portable db.
for example user in file portble select [from] id=1,2 of table list of portable.accdb={aa bb &cc dd} but main.accdb append record show from id=1,2 of list table of main.accdb={main main/sub sub}
tnx

Hmm - I don't think it has any bug - I think it is the values in your table "list" which make it.
Do you not agree?

 

[ahmadrezaahmad]

I attach bug pic!!!
please see to know your file bug!
the bug is:
I want append bottom at first append table list of portable.accdb to table list of main.db then append record of asli table of portable.accdb to asli table of main.accdb so the [from] field of appended record is from the value that user enterd in "list" table of portable.accdb!!!
basically the list table of tow data bas not same!!!!
tnx

 

[JHB]

I attach bug pic!!!
please see to know your file bug!
the bug is:
I want append bottom at first append table list of portable.accdb to table list of main.db then append record of asli table of portable.accdb to asli table of main.accdb so the [from] field of appended record is from the value that user enterd in "list" table of portable.accdb!!!
basically the list table of tow data bas not same!!!!
tnx

First - sorry, it isn't my file - it is yours, I'm only trying to help you!
The problem is that you have set the lockup value for the "from" field to "Query2" and "Query2" is getting the rows from table "list" in the actually database.
The "from" field doesn't store the actually value, but only a reference ID.
It doesn't help to append rows to the table "list", because the references in the "from" field will point to the reference ID in table "list". In this cases no. 1 and no. 2 no matter what the value is.
To overcome this problem, type in all values in the "list" table (and don't change it afterwards), which can occur in the "from" field.
Or rethink the structure in your database.

 

[ahmadrezaahmad]

I cant type all value in "list" table because the value of list is fill by user in my original portable.accdb file!!!:-(
how I restructure my databes??
plz help me!!
TNX

 

[JHB]

What is the problem with the solution you had before - without the multiple value field?
Can't you use a "child" table instead, (this is more or less what multiple values field is)?

 

[ahmadrezaahmad]

Unfortunately, not enough without multi valued for our database.
Let me explain the situation more clearly.
There are several users, each of our user has projects and staff members!
we give portable file to each user and he fill project form and in field project staff he can select staff by multi-valued combo box or by cllickin on button (Add Staff) can add staff in list table the return to combo box and select his project staff.

then all portable.accdb are returned to us and they must be integrated in the main file!

so we did'nt knew any thing about "list" table record!!!

 

[JHB]

In you main database, you need a field more in the tables "list" and "asli" to keep track on from which user the data are coming.
Because a staff member no. 1 for user no. 1, is not the same staff member for user no. 2.
No. 1 staff member's name for user no. 1 is Peter Peterson
No. 1 staff member's name for user no. 2 is Hans Hanson.
Do get the point?

 

[ahmadrezaahmad]

1-How I Create a field that can keep track????
2-what is the child table"???

 

[JHB]

1. No knowledge about database/MS-Access?
2. A child table is the table on the many side of a one to many relationship.

 

[ahmadrezaahmad]

1.plz help JHB...Im begginer in English language and ACCess
you say add field in main db to save the track of list appended table to know from which user???
2.in my problem how I can solve my problem by child table?
tanx aloooot JHB...