Search results

  1. E

    Very Weird Problem

    Thanks again Pat...i'll use this method in future
  2. E

    Very Weird Problem

    Thank you. I actually tried that code but the error was still coming up. Actually i've put some of Pat's code in instead of what i had and the error doesn't happen anymore. I'm now getting a different error when i move on to the next form. I think this database might have had it :oops:
  3. E

    Very Weird Problem

    Thanks everybody for the help and suggestions as always. Em x
  4. E

    Very Weird Problem

    Yes i think my sloppy use of the OnOpen and OnClose events may have caused this. Still, i'll make a note of it and not repeat the same thing again
  5. E

    Very Weird Problem

    Thanks a lot Pat....it never occurred to me to simply hide the initial form. Sounds like a much cleaner way of achieving the same outcome with less risk of causing this kind of error in future.
  6. E

    Very Weird Problem

    I wasn't aware that parameter was for saving design changes....i thought it was data. Yes i'll remove it and replace the code and see if it works. Thank you
  7. E

    Very Weird Problem

    Thanks Minty....yes the OnClose event had code which was the reverse of the code above (it opened the form Frm_SearchMulti)
  8. E

    Very Weird Problem

    Ok so i managed to get the form in question to open. In the OnOpen event of this form, there was a snippet of code which simply closed the previous form to keep things neat. When i removed this code everything started working again ??. This is the code DoCmd.Close acForm, "Frm_SearchMulti"...
  9. E

    Very Weird Problem

    Hi All....just trying a few things here. The database was actually split into a FE and BE but i admit i didn't have a copy of the FE on each User's PC. will be back to you shortly
  10. E

    Very Weird Problem

    Ok thanks all for the recommendations. I'm back in work on Sunday and i'll try a few things. * There are about 50 users approx so do i have to put a copy of the FE on each machine ? * Pat.....how do i trap the 2501 error ?. Even i i change it to a more user friendly message the issue will still...
  11. E

    Very Weird Problem

    Hi All, I have a form in a database which has been working without any issues for several years. The form contains a text box and a list box which i use to perform a keyword search. When i type into the textbox, a set of results appear in the list box and i can then double click on the one i...
  12. E

    Image Display

    Yes the map will be on a form and transparent command buttons would work well. Thanks moke
  13. E

    Image Display

    Ok thanks i'll go ask Mr Google and see if i can find a good example
  14. E

    Image Display

    HI moke......i'm working with a map which has a series of locations marked on it (using large red dots). The idea is to click a dot and make an image of the location appear
  15. E

    Image Display

    That would be ideal isladogs but i wouldn't be capable of writing the VBA to male it happen
  16. E

    Image Display

    I did a bit of investigating and found a way to do this using PowerPoint so not a disaster. Thanks everyone for the suggestions
  17. E

    Image Display

    This actually works great but it's a lot of work creating a separate form for each image
  18. E

    Image Display

    Thanks for the suggestion Doc Man but API calls are miles out of my league :)
  19. E

    Image Display

    Thanks Gasman....i've been asked to make the image open to about half the screen size so i don't really want to make it bigger. Could i create a separate form to hold the image ?....i could then control the size a bit better. Although i'm not sure how i would get the different images to load in...
  20. E

    Image Display

    Thank you i'll be looking into everything if i can't get Access to do it
Top Bottom