Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tontenn

  1. tontenn

    Issue with "LaunchCD" in code

    Thanks guys Cant seem to understand how to do it, so i will just move on and just do it manually. Thanks for your thoughts and efforts though. tones
  2. tontenn

    Issue with "LaunchCD" in code

    Oh Ok Sorry This is the code in my button Private Sub Command2245_Click() Me!Path = LaunchCD(Me) End Sub Maybe I have put it in the wrong place. Not sure. Cheers Tony
  3. tontenn

    Issue with "LaunchCD" in code

    Oh i was hoping you would be able to answer that. It was a code I used for another form just like this, but from the response you gave me it obviously doesnt mean anything to you guys. Ok I'll go and try something else. Sorry to annoy you.
  4. tontenn

    Issue with "LaunchCD" in code

    Hi Guys I want to use the code Me!Path = LaunchCD(Me) In a form associated with a button to open up a folder dialog box, find the file that the record associates with and then save the path in to the text box "Path" so as I can click on that in future and be taken straight to the file on my...
  5. tontenn

    How to make name or initials auto populate into a form text field

    Hi Guys Been a while since I have needed to come on and ask a question. I am updating our database and many staff have asked if when a record is changed that not only does the timestamp change but they want to have their name or initials be saved to show the last person that worked on the...
  6. tontenn

    Error and locking when opening report from another database

    Hi Found the solution to my problem at last in thread68-53433 It was all to do with installing office as administrator and then opening it the first time as a user. I just went back in as administrator, accpeted the end user license agreement and it has fixed the issue of opening up the other...
  7. tontenn

    Error and locking when opening report from another database

    Hi PHV Ok I have checked with the It guys and they have now just updated all the latest patches for office and access and still the contions box appears. Obviously this is the issue as the first time after the update we tried it, the box didnt appear and the database opened fine. So I think i...
  8. tontenn

    Error and locking when opening report from another database

    Hmmm not sure about that let me ask the IT guys
  9. tontenn

    Error and locking when opening report from another database

    Hi PHV yeah we have checked that and all our copies are registered and have actually all been reinstalled just recently and it still occurs on a few machines. Must be an error with the software, I might try microsoft and see if there are any solutions there, thanks for your time
  10. tontenn

    Error and locking when opening report from another database

    Hi PHV The conditions box is titled "Microsoft Office End-User Licence Agreement" and it has lots of conditions to scroll through and then at the bottom 3 buttons Print Accept and decline. Every time, whether in this situation or just opening Access it comes up and says if I dont press accept...
  11. tontenn

    Error and locking when opening report from another database

    When i open it it normally it opens straight up and then I just choose the report and off I go with no errors what so ever. The only thing that does still come up is some stupid microsoft conditons box which I have to accept before I can see the database.
  12. tontenn

    Error and locking when opening report from another database

    Yeah its very weird. And I have found it is not happening on some machines but it is on mine and a couple of others. It may be individual machine or software issues But thanks for your help
  13. tontenn

    Error and locking when opening report from another database

    The line of code highlighted when you hit debug is appAccess.Visible = True
  14. tontenn

    Error and locking when opening report from another database

    Hi PHV The error message pops up on the screen just after the other databse is opened and when you go to cancel the error message, in the previous version the database was locked and couldnt be shut down. Now at least it can be shut down via normal methods but it still will not allow us to view...
  15. tontenn

    Error and locking when opening report from another database

    Hi PHV When adding this code it still comes up with the error message and the same line of code is highlighted to be debugged. The only thing it does do is unfreeze the opened database which wasnt happening before so there is a small success, but unfortunately still wont allow us to see the...
See more

Part and Inventory Search

Back
Top