Search results

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

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

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

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

Hi. I hope this is a quick one! I've made a split database for the company I work for. We have started using it and I decided to make some changes in order to streamline the forms, so did so on a local copy of the front end, with my data tables coming from a copy of the tables as linked data...

Hi all, Hope this is a quickie. I have a subform that may contain quantities of stock, or no records. I need to take an average value from this subform. I'd like to return a count of the number of lines in the subform because if there are no records, I can't obtain an average. Doing a count...

Hello everyone. A quick one, I hope. I have a calculation in a form that should give me the discount percentage of an item calculated from list price and arbitrary "one-off" price input by the user. The control the value is to be displayed in is a "general number", set to 2 decimal places...

Hello! I wonder if anyone can answer the following: I've got a search facility on my Welcome screen. I wish the search term entered by the user to trigger the opening of a popup form, which contains a listbox of results; the user can click on the required result, shutting down the popup form...

Hello all, I have a split database, the back end of which I'd like to have sitting on Sharepoint, so as to be accessible to two users remotely. I've managed to export Sharepoint lists from my Database but I have hit a snag. Access seems to only create sharepoint lists for a subset of all...

Hi all, I know lots of people have had similar questions, but I've been unable to find a solution that works in my instance, so please be gentle! I'm developing a database in Access 2016. I have a form called frmContacts, which contains contact info (plus a sub-table with a snapshot view of...