Search results

...one step further ahead on this. If I modify the criterion to this: [forms]![frmContactSearch].[Form]![txtContactForename] OR Is Null I can at least return the records with a null value for forename when searching for somebody by surname. However, if I search for a forename, "Pete" for...

After a bit more playing, I think what you say about the Nulls is right Doc Man. Here's a worked example: If I use Like "*" & [forms]![frmContactSearch].[Form]![txtContactForename] & "*" and [forms]![frmContactSearch].[Form]![chkContactActive], I can filter on part of the forename and the...

Hi both, Many thanks for your paitience. I'm trying to explain this in very simple terms, so I'm sorry if my goal is not clear Doc Man. My boss is a big fan of Filemaker, and he wants to be able to search all fields within a record in the same way as it is possible in Fm. So for example, I...

Hi The_Doc_Man, Here is the SQL of the query: SELECT tblContacts.ContactID, tblContacts.ContactActive, tblContacts.ContactReportsToID, tblContacts.DepartmentID, tblContacts.ContactSurname, tblContacts.ContactForename, tblContacts.ContactTitleID, tblBuilding.BuildingID...

Hi Plog, I have a form with lots of unbound controls in it, for things like: Name Organisation Department etc I want the user to be able to enter some text into the controls (partial names etc). When the search results are displayed they are filtered using criteria like this: Like "*" &...

Hello. I'm trying to design a search form whereby a user can search through all the contacts in our customer database using a number of criteria. The idea is that the user can enter partial data, like surname (or part of surname), organisation name etc. I'd also like to include a checkbox to...

Thanks Doc Man, To clarify - I do want to return all records if theres nothing in the search string. An example: Search for city = "paris" nickname = "old department" In the above case, I'd want to see all the departments in paris, where the nickname = "old department". However, if I put...

Wow, that's quick! Yes, that works. Thank you, you have saved me hours of mucking about! Pete

Hello, I would like a simple search form to return a set of results based on what I enter in a text box on another form. The query underlying the results form has criteria such as: Like "*" & [Forms]![frmSearch].[Form]![txtSearchString] & "*" so that if I enter "fred" in the box...

Thank you, Minty. I think we have an older PC that hasn't yet been updated. I'll check with that and/or roll back my version of Windows, if that is possible.

More confusing behaviour from the database now: This morning I got into work and fired it up to discuss the issue with my boss. In my Contacts form I have a subform with a button alongside each data entry with the following code underlying it: DoCmd.OpenForm "frmOpportunity", , ...

Thank you both for your continued patience. Access is behaving quite strangely for me as I think I have demonstrated - now it's changing between "property not found" and "no current record" and I'm not seeing a pattern of why. Taking the example that Minty gave, if I force the form to open to...

Sorry, to clarify my earlier reply, opening the form DIRECTLY from the panel on the left hand side works without error.

I have a form with a subform in it. The overarching form is for a customer "opportunity", the subform lists the quotes we've made to date. Clicking a button on the subform adjacent to a quote takes me to a detailed overview of that quote. The error flashes up, but the data appear to load...

I've just opened a version of the FE from 16-02-2022. I deleted all the linked tables and re-linked them using the tables that I saved on the same day. Both files are local. I'm getting the error again, exactly as I did initially with the newest version. Going into design view also causes the...

Hi jdraw, Thanks for taking the time to answer. I can't with real data as it's confidential. If I can put together a smaller version of the db with mock data, I will. Pete

Hi Minty, What I mean is that versions in April/early May were working, without showing any error. The errors first appeared while I was making changes to a stable version. When I ran out of ideas on how to sort the issues out I went back to a previous version and that gave an error....and...

Hi Minty, I'll check the office updates now. Yes, I've copied the back end from our remote server to my computer and I'm still getting the same issue when I link to those files.

Thanks for your reply. It's a couple of actions that I do that trigger the error, but the data display ok as far as I can see. I've already done the relinking as you suggest, so pretty sure it's not that. All databases open directly from FE, yes. Pete

Hi The_Doc_Man, Many thanks for your reply. That is exactly what I meant initially, but I've just been in touch with him and it seems that he is also seeing the same behaviour, but less frequently than I do. After a bit of further testing, I can also add that the error can be "no current...