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