Search results

Hi, I am trying to filter a subform based on the values in 5 different combo boxes. The boxes can be empty or filled and can be any combination of the selections. I have the following but some of the combos don't generate a filtered list. To clarify, this query is based on another similarly...

Hi all, I have a form with a subform. On the subform I change the details in one field in a record and then want vba to change that field in other records where certain other criteria are the same (from other fields). I have managed all of this but then the loop doesn't stop. I have looked...

Hi all, I need to create a query/report that basically allows the user to see data where there are 2 header rows. something like criteria 1 a b c item 1 item 2 Does anyone know if this is possible? Apologies if the 'table' above does not look right, I'm not sure if it can be created on a...

Hi all, I have created a form which sends an email when the button is clicked. However, I want to use multiple criteria for an SQL string which selects the recipients of the email. Basically the end user selects criteria from one, two or three combo boxes with the idea that the SQL is build...

Hi, Please could someone point me in the right direction. I would like to learn how to deploy a database project to others who are not in my organisation and then have it split itself once it installs onto their network. Problem is, I don't have a clue how to do this. Could someone point...

Hi, I hope someone can help me. I have looked all over the internet for a solution to this (including here) and can't seem to find a solution to my problem, I am certain that what I want is possible. Basically, I have some code (i can't attach it for some reason - something to do with email...

Hello Everyone in Database world! I have been using access to create solutions for almost 15 years and have often found fantastic advice on this website for a lot of them. I just didn't join...stupid me. Anyhow, I am here now!!! Hello! :)