How to find brand names?
In column A I have product descriptions. These desriptions contains different product specifics, each product are unique, each produkct has it's own row. The brand names I want to find will be found on several products/rows.
In column B I have a number of words, in this case brand names. All brandnames are unique, there are no duplicates, each brand name has it's own row.
I would like column C to specify if it in the A column with product descriptions finds any of the brand names in the list column B.
/Freddie
Hi.
I have an Access 2010 database that is splitted into one frontend and one backend file. The frontend is saved as an .accde file, both files are stored in a shared network folder.
When I myself opens the database, everything is OK, but when someone else opens the same file, they just get the message
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
Clicking Cancel does not help. It just pops up again. The user HAVE to click OK and by doing so, all VBA code is lost.
Why does this happen? Why is it OK when I run it? Could it be something with user rights both for the frontend and backend file? (seems odd that the code is deleted though, since this action would change the frontend file). Could it be that I have enabled some advanced feature within Access while creating the database, that other users have not enabled?
Anyone who have any idea?