Recent content by EssieP

:confused: erm, what's a "bound column"? -------------- :eek: AH I get it !! The combo was returning a value that was hidden in the drop-down, the ID field.

I've used the expression builder to get the value of a criterium from a form. The problem is that it always returns no records when I run the query via a report which is itself opened by a button on the form. there is a small amount of test data present. If I open the report directly (with the...

Interesting idea but it's one that will be difficult to gather data. When I get home I can remember which towns & villages I rode through, but not what time of day I arrived at each. However if I were to list a succession of villages on each ride I could develop the system later by adding in...

I'm confiused now, Dave UK told me to delete tblWaypoints. I'd be less confused if someone could explain the reason for such pieces of advice.

none the wiser I did that, and it will only allow me to do a one-to-one relationship, but isn't that wrong because one ride can have any number of visited waypoints. In fact some rides will need a placename twice, on the way out and coming back home. I thought it would need a one-to-many? Is...

I just don't get it. I want to make related databases but it rarely works. I have a simple database to log cycle rides. the idea is that I go cycling once a day, sometimes I pass through lots of villages, sometimes only a few. I want to be able to set up a form to enter new rides, and use a...