Recent content by Fishman

Hi all, hope you can help. I am trying to build a form with a command button which will allow me to build a report and export it to a text file without first previewing it. I am using the Northwind db to try to get this working. I have built a form with a multi-select listbox to choose one or...

That did the trick, renamed and changed function as you suggested. now I run the query and get results that have a 0 in the Expr1 column against records with no match to the rivers list, and a -1 against records with which do match. So I now have two ways to identify my non-matching records. I...

Thank you very much gemma-the-husky! That find unmatched query did just what I needed. I just wanted to be able to spot these unmatched records and now I can. Never used one of those before, as I said, bit of a novice (the name of the query type should have given me a hint I think :p) I would...

The reason I have not gone with a combo box is that I want to enter hundreds of records at a time by pasting into the 'new data' form in datasheet view. As I said am an a novice with access, but as I understand it the combo box would have to be selected for each record entered on the input form...

Thanks for the help. I'm sorry, but I think I may have not been clear in the OP. There is no forwardslash in my data, I just used this as a way to show two fields. The data is: A01 Dee A02 Don A03 A04 Esk A05 Don with the A0x ID codes in one primary key field [Sample ID] and the river names...

Hi all, I have a problem I hope I can get some help on. I want to be able to validate data when entered using a list of valid entries stored in a table, but can't seem to work out how. The main tables in my (simplified) example database are: Tissue Samples Sample ID/River (and lots of other...