Recent content by jj44

Following Solo's banning, I took the problem to StackOverflow where it was solved... I can't post a link but google this for the answer: "Using a form to display previous entries and add new ones" site:stackoverflow.com

Hi Jiri, I am using BeforeUpdate (which is what you had suggested) I think in this case it would be OK for the DB to not ask questions (i.e. for it to always assume that entering a value is an intentional action and to assume that a user did not make an error). The only code I have for the...

Thanks for the help. Based on that, with a bit of tweaking I've now got it so that when a duplicate value is entered, it lets the user know. That's great. I'm getting pretty close now. I have a subform set up to simultaneously enter sighting info. Can you help me with the code for the...

Hi all, I'm trying to design a simple wildlife tracking DB, so that when myself or my colleagues spot an animal we can enter its ear tag number via a form. That will either bring us up a list of previous dates/locations that animal was observed, or if it's not in the DB, allow us to enter the...

Thanks guys - it was changing the "Totals" column that I was missing!

Hello, I am trying to write a simple query that references calculations in the same query - but I keep getting the "enter parameter value" box. Basically, I have some columns in a query calculating average and sum values for a column. I would then like to multiply some of those columns...