Recent content by zebrafoot

Thank you for the explanation of the reason for the syntax error and for the above. I appreciate there is a LOT of data in the listbox - my boss likes to be able to see everything at the same time! You will appreciate that the listbox font size has to be very small.

Thank you very much for this. It works for me, and it's also nice and simple to follow.

I'm not familiar with this approach. Could you expand, please?

Hello everyone. Hoping this wasn't covered elsewhere. I have a listbox in a database form, which shows all products in the database according to various search criteria. Currently, the rowsource is based on an underlying query, ordered by several different things (Supplier name, Product ID...

Hi Pat, and thank you for your reply to my question. I'd been reluctant to use currency, because due to the international nature of our business, we deal with dollars, pounds and euros, and the currency seems to default to my local currency (GBP) if I set the datatype to currency. I had not...

Many thanks both for taking the time to reply. I think I've been regarding the numbers as a kind of numerical string, rather than considering the issues with storing them. I appreciate your help. Pete

Good morning. I'm looking to provide totals in a query that has some calculated fields in the following way: If the user has entered a one-off price, use this, otherwise calculate the value based on retail price and dealer discount using the following type of formula: FinalPrice...

First up, thanks to plog and Doc Man for helping with this. I really appreciate your time and effort. I think I've solved it by applying the exact same logic as was discussed in an earlier question I asked in August 2022:oops: This doesn't work: like "*" &...

...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...