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!

  • Congratulations Chriss Miller 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 maeling

  1. maeling

    QUERY SYNTAX IS NULL BETWEEN

    Hello, I have a query I am trying to get to work and can't quite work it out. I have a date field called visit_date. Everytime one of my users visits a customer he enters record and the date for the record is create =date() I would like to query for customers taht have not had a visit for the...
  2. maeling

    Outputting to excel

    jeryyklmns the end solution will involve a query however at the moment I am just testing with a table. Do you know of any threads in forum705 dealing with this particular problem ?
  3. maeling

    Outputting to excel

    Hello, thanks a very helpdful thread. It needs to be a memo field the users are inputting between 20 - 500 characters on average however when they are sending the infomation in via the output file only 255 characters are visible. I'm not quite with you on your suggestion could you explain again ?
  4. maeling

    Outputting to excel

    JerryKlmns, I'm not quite sure what you mean but the access table field holds more than 255 characters it is the cell in the excel output file that contains less.
  5. maeling

    Outputting to excel

    Hi, thanks for responding. Yes I'm sure that the data is missing after 255 characters. I've clicked into the cell, exteneded the cell and copied and pasted the cell contents into word then run a word count. I do wish you had of been right. I've got a feeling that his is going to be one of those...
  6. maeling

    Outputting to excel

    I have a macro that outputs a table to excel. The table has a field "objective" which is a memo field so it holds more than 255 characters. However after I have output the table to an excel file and open the excel file some ofthe data is missing from this filed in the workbook in fact the cell...
  7. maeling

    Hyperlinking whole document

    Ian, now have some fyrther information which may help you see thread68-1118133. It provides the code to output an active worksheet to a file. This combined with the detail above should get you somewhere close ??
  8. maeling

    Excel VBA Function OutPutTo

    Hello, yes I had changed the sheet name but still got the error ?? However it will always be the active sheet so yoour second suggestions works perfectly. Thanks
  9. maeling

    Excel VBA Function OutPutTo

    Hello again, I copied and pasted both lines of your code directly into a macro I was editing. After saving it I attempted to run it. I got the following message. "run time error 9" "subscript out of range" Line one was hilighted yellow. I removed the line and the second line worked fine but...
  10. maeling

    EXCEL LOOK UP

    This was available in the past however I'm not sure if runtime licenses exist anymore. I heard of a site having to purchase several hundred Access licenses to accomodate a runtime process they had.
  11. maeling

    Excel VBA Function OutPutTo

    In MS Access there is a function OutPutTo which enables you to output a databse object such as a table or query as a file such as Excel, to a designated location c:\output.xls. Is this function available in Excel ? I would like to create a macro behind a button on a worksheet that will output...
  12. maeling

    EXCEL LOOK UP

    OK thanks for all your help. The reason access isn't an option is because this document is used on customer sites. The customers do not always have access. Thanks again.
  13. maeling

    EXCEL LOOK UP

    The ideal solution for this would be; the end user types in sony and all the multple options are displayed in a list to select from. Once the list is visible, the end user would know which one to select by using a mouse click or keystroke. The industry I am refering to has many names for one...
  14. maeling

    EXCEL LOOK UP

    Thanks - yes I am more familair with access tahn I am with excel however for this solution it is not possible to use access for logistical reasons.
  15. maeling

    EXCEL LOOK UP

    Kelley, the end user that will be entering the data will only know the make of the equipment she\he will be surveying. I have used sony in my example but in reality it will be huge peices of industrial machinery. The end user will not know the function of the machine until she\he enters the make...

Part and Inventory Search

Back
Top