User Profile

Collapse

Profile Sidebar

Collapse
LODIE
LODIE
Last Activity: Jan 20 '09, 04:47 AM
Joined: Aug 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • LODIE
    replied to open Access Form from hyperlink with filter
    in Access
    Thanks Adezii,

    I ended up adapting the Northwind solution that you put up. It worked perfectly once I made some adjustments to my start up script so that it would only open up the form if command existed.

    However, stupid me was thinking that just because I could get the command to work from a dos prompt it would work no problems from Exponare. Obviously this was not the case. Exponare runs as a web browser, and although...
    See more | Go to post

      Leave a comment:

    • LODIE
      replied to open Access Form from hyperlink with filter
      in Access
      Thanks Nico, I will give it a go, sounds simple enough.
      See more | Go to post

        Leave a comment:

      • LODIE
        started a topic open Access Form from hyperlink with filter
        in Access

        open Access Form from hyperlink with filter

        I have tried to search the forum but kept getting blank page so I apologise if this has already been posted somewhere.

        I am a GIS officer and we use a mapping software called Exponare Public which is web based and allows non mapping people to view our datasets without being able to change them.

        Within this software we can do hyperlinks out. What I would like to do is have a link which opens up a form with all the asset...
        See more | Go to post
        • LODIE
          replied to While loop to get start/end values of condition
          in Access
          Rabbit, thanks heaps for that, you are an absolute legend. I wasn't expecting a whole routine written just some suggestions on how to go about it.

          And thank you to everyone else for thinking about it and responding to Rabbits solution, the whole discussion helped me to understand alot more what was going on.

          I had to make a couple of changes.

          First I had to check my data as I had a couple of entries that...
          See more | Go to post

            Leave a comment:

          • LODIE
            replied to While loop to get start/end values of condition
            in Access
            Sorry about that, I should have posted an example.

            Just say that I have the following data for a road

            Road_id start_Seal End_seal treatment year
            100:01 0 100 primerseal 1981
            100:01 0 100 finalseal 1992
            100:01 50 200 reseal 1997
            100:01 125 150...
            See more | Go to post

              Leave a comment:

            • LODIE
              started a topic While loop to get start/end values of condition
              in Access

              While loop to get start/end values of condition

              Hello All,

              I was hoping that someone might have a suggestion on the best way to complete the follwoing problem.

              I have a bunch of roads. Each road has a Start and end Distance (chainage in metres) and may have been sealed in multiple sections over the last 40 years. Each seal section also has a start and an end value and they may overlap each other.

              I have managed to get this information into a stocck...
              See more | Go to post
              No activity results to display
              Show More
              Working...