Export to Excel
Automated Export

Access Expert Level 19

Hi, I'm going to try to briefly explain what the intention is. We are currently working in an Excel file for the construction of kitchen cabinets. We currently have about 7000 different modules and this is being expanded to double that. My boss told me to make this excel in access with all codes and 100 price groups. My question now, each cabinet module has a description e.g. "1 door" ' "1 shelf" ' 2 fronts etc... So basically the description of the cabinet.This description can go up to 10 lines and each description must be in a separate cell " field " because it has to be imported to Excel afterwards.  The structure structure is important because it has to be read into other packages via Excel. The Excel must be exported with all data in 1 line. Sometimes I have 3 descriptions, but sometimes I have multiple descriptions. When I export these, there should be no empty cells in excel. What is the best way to construct this description? I now have a Cabinet DescriptionT with 10 fields for possible description, but if only 3 lines are filled in, only 3 fields should be visible. Kunnen jullie mij hierin advies geven voor de opbouw van de beschrijving van de kastmodule.

Can you give me advice on how to build up the description of the cabinet module?

I'm guessing you need a function that can convert this:

     Description 1
     Description 2
     Description 3
     Description 4
     Description 5
     Etc.

to this:

     Description 1, Description 2, Description 3, Description 4, Description 5, etc.

I believe the "code vault" of this site has such a function.  Maybe other posters can help you with it.  

Basically, the methodology behind it is that you need to create a "recordset loop" to retrieve all the different records, and combine them into one string, delimited with commas or any delimiter you specify (a line break can be a delimiter too).  If you know your combined description is only one entity, you don't have to worry about how many descriptions there are beforehand.

Ok, that could be a solution, now let's hope someone can give me the link where I can find this video and build on it. Thanks in advance

Access Developer 17
DLookupPlus
Code Vault: DLookupPlus Code

Hi Kevin, I've looked at the DLookupPlusCode but that's not what I should have. I have 10 fields as an extra description of the cabinet, but each description has to be in a separate field. Depending on the number of fields that have been filled in, we should be able to see them. Is there another solution there. Unfortunately, I'm only on Expert 16 for my knowledge.

Sounds like what you need is a Junction table and a Subform to display the descriptions.

Show an example of what you HAVE NOW in Access and what you need the exported data TO LOOK LIKE.

Hi Ludwig, see the picture below.  This is what I had in mind for you, and DLookupPlus would be helpful.  You have plenty of room to fit 10 or even more descriptions on one row.  Add an extra row for separation, and you have only 2 rows in between tables, if a neat display is what you want.

Richard:  View 1 I have to convert to access, view 2 is the excel that I have to export from access to load into a drawing package Winner and WIDOOCA to read in. View 3 is my tables

weergave 2   :)

display must be separately in the description, must be separately in an Excel cell afterwards  weergave 2

Why can't I put a default value in a Combobox field that refers to a text field on the form. It would be to copy the previous value so that you don't have to type in again every time you have the same description several times.