Search results

closing the form wouldn't be a problem could you give me some instruction where that be code on how to do this? Thanks for any help!

Is there a way of opening the excel within Access as read only this way i would be able to open and edit the file. Hope that makes sense! Thanks

I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs)...

Yes the Access is bring data from the Excel file but i also need to open the Excel file as well.

Yes i can access the file no problem the file is stored on my desktop with the access files. I have the excel displaying data within the access program which is where i think the problem lies as i the access program i taking data from the excel but when i want to open it, it does not allow me to.

I am currently not using any code just a hyperlink to open the file. Each time i try i get two error messages one saying the hyperlinks can be harmful do you want to continue -> Yes.... Then second error message Cannot access 'file name.xls'

I am trying to open MX Excel using a command button. I have tried using a hyperlink and various codes that i have found online with no luck. The Excel file is being used by Access as it bring data from the spreadsheet and displays it within a subform. (I think this is where the problem occurs)...

Does anybody else have any ideas about this problem?

Hi Apr, i have tried this with no luck i have tried removing the subform which is importing the excel file and the button then works but, when i put the subform back in it stopped working.

i have completed removed the subform and my button worked fine. - Here is the code for my subform Workbooks.Open filename:="C:\Documents and Settings\cjacobs\Desktop\CustomerDatabase\Quote.xls", ReadOnly:=True thanks

i have tried what you have suggested still with no luck i have done everything as explained when i have the excel file open first then open the database i can view both but as soon as i want to edit the excel i'm met with an error "the file is locked" the code you suggested to use only gives me...

How can i do this? I have posted this on a forum and nobody seems to be able to help me! I am able to view the excel file through the database but when the database is running i am unable to open the excel file using a command button or going directly to the file and opening it there i get the...

I have already created my bound object so i can see the excel file, this is not the problem the problem lies when i try to open the excel file from its original location (whilst the database is running) - trying to open the excel file gives me the error: "Cannot access excel file.xls". I get...

hi apr i have tried what you have suggested this only allowed me to open excel. What i am trying to achieve is to be able to open the specific file but as i am already running the excel file within my database it does not allow me to do this so i am lookinf for a way around this. i thought...

Can you add a new user and give this user all admin rights - make sure you change this user to owner as well. - Tools - Security - User groups and permissions - Change owner tab. Hope this helps

I'm currently running a database which is bringing data from an excel file. I want to be able to open this as a read only file as i am having problems opening the (excel) file when the database is running (It will not open when you click the file but does display the file in my database (The...

I'm currently running a database which is bringing data from an excel file. I want to be able to open this as a read only file as i am having problems opening the (excel) file when the database is running (It will not open when you click the file but does display the file in my database (The...

I'm currently running a database which is bringing data from an excel file. I want to be able to open this as a read only file as i am having problems opening the (excel) file when the database is running (It will not open when you click the file but does display the file in my database (The...

Help.......... LOL

I can am unable to open the file at all when access is running so this is why i think the fact that the database is calling data from the excel file is causing the problem. Thanks for any help!