Search results

Ordinarily yes, that's what I'd do. But the problem is that the [ingredients] field is a great long string of text, so I don't think it would match like that. For example, I'm trying to 'hazelnut' in a much longer string of text, rather than a discreet field which would match nicely.

I'm writing a database to check an ingredients list for allergens. I was rather pleased with myself to have used the InStr function to search for allergens. For example, this code searches the [ingredients] for the word peanut, and compares it to whether the respondent (a manufacturer) has...

Thank you both. Just in case you hadn't already anticipated my next question... What's the code to show/hide tabs on a form? Or perhaps better still, can you point me in the direction of any resources that will show me how? Thanks, Alex

Hi, I'm struggling to settle on the best way of doing things in this scenario and could use some help. I am building a simple electronic sign in system for Reception. The user completes a form (Form A), providing their name, car reg etc and also indicating which warehouses they'll be visiting...

Thank you so much for the offer. Give me the weekend, as I've spent today in an incredibly dull meeting, which has at least given me time to think about how to do this better. If I'm still stuck by Sunday then I'll be back for help!

@sneuberg - it's still very much a work in process, but as I need to add a file header line, and a file footer line, I'm anticipating doing this in a report that would then be output to a pipe delimited text file. There's no stipulated order to the input. It's just a requirement that the output...

Hi everyone, first post in a while, and first one on a new username! The background is that I am trying to create an order import file for a legacy system, which is very rigid in terms of what it expects. The specific problem is that for an order which has multiple products on it, each product...