I am needing an equation to Concatenate all files with a specific text string in it with another field that is always the same. The file names can sometimes differ in name slightly if there is more then one file per product. But the file names will always have the SkuID (IE: VH51UN45JK0) in it somewhere. Say I was needing all file paths with VH51UN45JK0 in the name. I would like to generate a Concatenate values like below.
If you select multiple files, you will need to loop through the selected collection and insert a separate row for each item selected.
I thought the code was doing the selection rather than an individual.
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …