Search results

I cannot thank you enough. I need to tweak the concatenation of the sql, which is within my abilities, but it now works just as intended. I've removed modsamplecode, I've been recycling a lot from a db I wrote about 15 years ago and digging as deep as I can to try to remember stuff I learned...

More than ready, if you don't mind doing so. Just don't give me a hard time on how scrappy or badly designed it is. Originally I set out to do a codeless, very simple db on the fly to track my team's projects rather than do monthly reports in Word, which I expected to do in a one evening. But...

Becoming blind as well as stupid. Though this isn't working at this end, returns that there are no records.

I didn't, actually, as while I understand the movefirst/movelast logic, I can't figure out where they go, and there's a movefirst and movenext in the function which I figured were meant to do just that. So if you could tell me which line it needs to go after, I'd appreciate that. I'm passing...

.... but, having reflected on all that I've read around this over the last couple of days, I think the need for this is a product of flawed db design on my part and I'll look at making life easier by getting all of those long text fields into one table, with type categorisation to drive subforms.

Well, almost but not quite! It kind of works, but appears to only return the first match found in each table. Any suggestions?

Yep, coming back to me now. I think my habit was to have it on new lines so (ironically) I could see it clearly closed when indented. Leastways, looking back at some evry old work that's what I seem to have done.

I'm afraid that's too programmy for me, I'm just a code end user, the equivalent of a car driver who knows just enough to do a DIY service every 12 months. But if I had to guess I'd say it's through creating the class called 'SearchResults'? (Back at the beginning of the thread). There is one...

All I can say is that I've used code written by Dev Ashish on and off over the years. His code is always clever stuff (to me anyway) which I don't necessarily fully understand, but it always works and that's good enough for me. And I will indent, promise.

Perfect, much appreciated. I wouldn't have got there myself. Yes, it wasn't indented, just copied and pasted off the web this morning. I do indent normally, honest! For the benefit of others, I didn't need the subsequent three lines, just the first one.

Yes, apologies for that, it's quite a while since I did any coding and had forgotten that etiquette. Hopefully I've got it right below. You'll have seen in the immediate window that, for every match, it gives you the field names (columns) and values for every field. All I want to do is narrow...

The code does actually return all matches from every table. The code is free-standing, if you paste it in as outlined you'll see the results via the immediate window. I know I could do this via queries and forms etc but Dev's is such an elegant solution I'd rather use that, if anyone can tell...

Probably best if I describe this. Bear in mind that I am simplifying here, to avoid it becoming too long winded. I have 3 tables with an hierarchical, one-to-many relationship. They relate through foreign keys etc. Each table contains at least one text field. The first table captures topics so...

The question, boiled down, is how do I reference a specific table field in VBA? If I use something like fieldname(0) I get an error as it's looking for a function.

I'd be embarrassed to do so; I'm a rank amateur, trying to do something quick'n'dirty and both the structure and coding is scrappy, and this is the very last problem that needs solving!

Hi, I have found some code, appended, written by Dev Ashish many years ago that allows me to search all tables for a string match. This is great but I now need to return the value of one field from the results. Longhand, what I want to do is specify that if the result comes from Table X, return...

Hi, I dip in and out of access programming from time to time and usually manage to find my way by googling sample code, but have no underpinning training or knowledge and only a thin understanding of coding principles, so do sometimes get stuck!