Search results

Thanks for this!

accessnarrator, I stuck with this and got somewhere: use this code: Lou

I never got to solve this. However apparently Access 2010 has a better way of exporting with formatting. I am currently using 2007. Thanks Lou

This works great - "Also, just for anyone searching and might run across this. I have code that will send a subform or form's recordset (filtered recordset) to Excel. This works when the DoCmd.OutputTo does not. See it here." Is these anyway to not export hidden fields? Lou

I thought I had made it clear that each user DOES have a front end See earlier posts "No each user has the front end on their local PC." and "Please see attached a front end and back end database. and "For example open the front end on two pc's," :-)

For info this response from JDetman on another forum and my response. Still got a problem any ideas VERY welcome!! Jim said: "If I'm understanding this correctly, then unfortunately this is a case of "that's the way it works". Memo and OLE fields > 32 bytes are stored on LVP (Long...

I have tested this out. It is absolutely nothing to do with having the notes open on each pc. I changed to Record Locks edited record on the notes form and this works fine (if another user has made the record Dirty the record is locked - you can't change it - and thats fine) . BUT you still...

No each user has the front end on their local PC. They have been using it daily for 7 months with no problem - until the length of the notes became an issue. Although I am not convinced that its not something to do with the refresh rates etc on the Access Options Advanced? Did you look at...

Please see attached a front end and back end database. There is only one table and one form. On the form there is only one field - which updates a memo field in the table in the back end. When two users have the form open (displaying the one and only record, 356 chars counted in Word) if...