Search results

  1. C

    Opening Excel... HOW?

    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)...
  2. C

    Help Required! Opening Excel not as easy as i thought!

    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)...
  3. C

    HELP NEEDED.. Beer to anyone who has the answer!!

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

    Read only excel file

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

    Opening read only excel file

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

    Opening Excel with a command button

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

    Run-time error 94

    Can someone help me debug this. I have found the error leads to this line but how can i stop the error? Run-time error '94': Invalid use of Null. Option Compare Database Option Explicit Dim Msg As VbMsgBoxResult Dim StartText As Long Dim TextToFind As String Dim TextToBeSearched As String...
  8. C

    Using a calendar to control a test box

    I am trying to allow a calendar to search through a text box with a large amount of data in which will have headings using the date so i wanted to use a calendar search. Hopefully this will be be like the find function in word where you type (or in this case select a date) then click search or...
Top Bottom