• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Recent content by ontopofmalvern

  1. O

    Hi

    Welcome I wish I had read this old thread before I started my first Access project. https://www.access-programmers.co.uk/forums/threads/the-ten-commandments-of-access.172363/
  2. O

    What ever happened to Courtesy & Good Humour?

    This forum has been ace for me, the regular contributors give good understandable advice and have helped me greatly either in response to my idiotic posts or through finding someone else with the same problem. Just in case I haven't done so before Thankyou to you all, my school has a better...
  3. O

    Using Access remotely online

    okay I think I have to go on for now, the only problem I have with our network admin is that I run it alongside about 2,000 other jobs - at most for the foreseeable there will be no more than 5 remote users requiring a few minutes a day. Inputs from remote users will not be time critical, any...
  4. O

    Using Access remotely online

    Many thanks for all inputs, I think I am now in firmly in the RemoteDesktop with software VPN camp, I can live with the restrictions and can set it up quickly (and I understand how it works which is always a bonsus).
  5. O

    Using Access remotely online

    I like the use of the word I don't doubt you on this but I'm interested what benefit does the VPN give me (I presume it's a security thing) Many thanks
  6. O

    Using Access remotely online

    I believe ‘Windows RemoteDesktop' is windows version of TeamView? Citrix/Azure look a less straight forward. I am drawn towards WindowsRemote/TeamView type solution, I think I can live with the user limitations and I can implement it quickly. What steps do I need to take to ensure best practice...
  7. O

    Using Access remotely online

    Does anyone have any experience running an Access application online. The problem I have is I run an Access database that is central to the running of our school for children with significant emotional difficulties. All was great back in prehistory (February) when all staff and students were on...
  8. O

    Solved Search for all uses of a key in entire database

    If any one stumbles accross this thread I did find a solution (which is very much in line with The_Doc_Man's suggestion), in the end I sorted my problem with a brute force method as I do not expect it to be a recurrent problem, the truth is the best solution to these problems is not let them...
  9. O

    Solved Search for all uses of a key in entire database

    Hopefully it won't happen often, I'm going to try theDBguy's solution mainly out of interest, for today's problem brute force I think it is. Tah
  10. O

    Solved Search for all uses of a key in entire database

    Lucky I did which is a big surprise as when I started this project many moons ago I did break just about every golden rule out there. I was hoping for something a little more automatic, it is obviously in access somewhere because when you delete cascaded records access finds them all. However...
  11. O

    Solved Search for all uses of a key in entire database

    Hi I'm doing a bit of house cleaning on a project I use to manage school data. I have come across a duplicate record in my student table (i.e. same student entered twice each with its own auto number PK). Obviously I want to delete one but before doing so I wish to check the PK hasn't been used...
  12. O

    Solved Why does this piece of code give me an error?

    I'm guessing the undo command is leaving the form in a state it doesn't like, i.e. something like a required field is is empty or something isn't valid. I think I'd comment out the DoCmd.Close line and see what form looks like when you go back to it, i.e. do any of the controls have contents...
  13. O

    Solved Why does this piece of code give me an error?

    It is a little long winded try If msgbox("Přejete si uložit data?", vbYesNo) = vbNo Then 'no button selected DoCmd.RunCommand acCmdUndo DoCmd.Close Else ' The yes button was selected. DoCmd.Close Globals.Logging "Zapujceni" End If Should work and is easier to...
  14. O

    Access Relationships can't see them all

    That looks just the ticket. My follow up question was to be how to edit links without the relationship window but you've answered that before I got there. Many thanks
Top Bottom