Search results

OK thanks. In my database, I created an output table the same as your example, and I created a form with a Run button and put your code in the OnClick event. In the code, I replaced the names of the input table and the fields with the actual ones from my database. When I tried it, I got an...

"Does the code create the output table when it is first run, or does the table need to be created separately somehow?" How is the table created when the code is first run?

OK I see now, thanks. I gather the code first clears the output table each time it is run - is that correct? Does the code create the output table when it is first run, or does the table need to be created separately somehow? Could the code be run just from a button on a form, so the...

I have now been able to check out the example database that you kindly prepared. Your help is much appreciated. However, I'm afraid my knowledge in this area is not very advanced, and I can't quite follow how your design works. (a) Your MainTable is similar to the main table in my application...

The business is a successful provider of services in the publishing industry. The application works very well. The contents of the "Back" and "Front" memo fields can be any length but are carefully and consistently structured, with semicolon delimiters, and they are not free-form but are...

Thanks for your reply. This is not a class assignment. I have some experience with fairly basic queries and reports but am not familiar with more advanced concepts. Changing the design is not an option because the database is part of a large business application, where these memo fields are...

Thanks, that solved the problem.

Thanks kindly. However, the link says "SplitMemo.accdb", but when I click on it to open/save it, the name is "attachment.php".

Thanks for your reply. I'm afraid I don't know enough to that without further guidance.

Thanks for your reply, but "I realize this would be easier if the data were not in memo fields ... however, I cannot change the design."

I have a table with a field that lists attributes (say, colours), like this. [Colour] Blue Green Red I have another table with a key field ("Item") and two memo fields ("Back", "Front") that contain these attributes, like this. [Item], [Back], [Front] Item1, Red, Green Item2, Blue, Green Item3...