Recent content by Mark Richardson

I've tried to attacha a screenshot but not sue how to reference an image that is held on my machine thorugh URL address. To try and explain it a bit better, here is an example of what I hope it should look like: 11/2010 12/2010...

Hi, It has been a while since I used Access and I've come to a point where I'm struggling. I am trying to create a report from a query that I have created which looks at the total hours individuals have done on a month by month basis, the hours have also been split into the different project...

I am trying to stop access displaying the "You are about Update 1 Record" etc message when i run an update query. I know i can do this in Tools/Options screen but the problem is that the database is going to be used by multiple users, and rather than changing each persons Action query option I...

I am trying to create a form that is based around a league table. When it opens i would like access to extract specific information from one of my tables and then display the records in a specific order. This order will depend on how many check boxes have been ticked. The form will be used to...

Cheers thats perfect.

Right my problem is this. I have set up a form where the user inputs a information regarding a train journey. At a certain point they need to enter a start mileage for the journey. Once they have updated the field a macro is run which queries another table identifying what journey they are...

Right sorted that. Rather than comparing the finish mile with next Start Mile. I have compared the Start Mile with the previous finishMile. Cheers for help

Of every little section. In basic terms the final piece of the ELR Section is being numbered as a new track section. It is very difficult to explain. Cheers for any help.

THat works great. Cheers. The only problem is that when it is run the trackid increases on the very last mini section of the Track. When you reach the end of a link, the mileages will not be the same but i need the code to recognise that and still enter in the old trackid. For example for AAV...

Yes, thats correct.

Thats is what i am after. Thanks for any help you can provide. Much appreciated.

Cheers, hadn't thought of having self join but i do agree i need to use VB. Not overly great at it but hey if you don't try you'll never learn. Mark

Yes that is what i am trying but i am struggling to write the code which makes access pull off the start mileage and end milage for specific length of track. The extract of the table in my initial post shows how the overall Track ID sections are split up into tiny sections. I need to be able to...

Geogis Id ELR TRACKID1 START MILES FINISH MILES 1 AAV 1100 29.0110 29.0154 2 AAV 1100 29.0154 29.0215 3 AAV 1100 29.0215 29.0550 4 AAV 1100 29.0550 29.0638 5 AAV 1100 29.0638 30.0000 6 AAV 1100 30.0000 30.0001 7 AAV 1100 30.0001 31.0000 8 AAV 1100 31.0000 31.1694 9 AAV...

Can someone help?? I am trying to allow a user to input a zero into a field as the first character. At present i have changed the fields property to text which will allow the user to achieve this. However, i am also using the entry to make another field visible/invisible. I had originally set up...