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...
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 ?
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 ?
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.
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...
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...
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 ??
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
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...
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.
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.