Search results for query: *

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

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

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.

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...

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...

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...

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...

Hmmm not sure about that let me ask the IT guys

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

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...

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.

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

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

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...

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...

Hi PHV This is the actual code Private Sub Label129_Click() Dim strDB Dim appAccess As Access.Application ' Initialize string to database path. strDB = "\\Server\common\CSC\Contact Management\CSCContactManagementSystem.mdb" ' Create new instance of Microsoft Access. Set...

Hi Guys Just a quick error question I hope someone can help me with. In thread702-1332179 I asked a question about opening up a report from another database on the same server. Remou answered and supplied me with a great piece of code that has done the trick. Up until now. Now when we try to...

Oh PH Thats awesome. Just what the doctor ordered. Thank you so much. Cheers Tones

Ok and how do I make that module work from a button on my form. Have never used a module before.

Ok PHV Im really confused Let me tell you what I did. I added the code that you gave me to the "Event Procedure" section of the properties of the button to send the path to the path text box. Is that where it is supposed to go or should it be in some other part of the database first before I...