[AccessD] 2 Client Requests

[John Colby]

The extra lines are likely embedded cr/lf. Strip them out. I thought that
access had an rtf box. If so then that would allow the hyperlink directly
in the box.

On Wed, Jan 16, 2019, 10:48 AM <RockySmolin at bchacc.com wrote:

> Gustav:
>
> Don't know.  I've never done that. But I think that would mean forgoing
> the memo field in the table and moving that to en external file for
> every task, yes?  Which I'm not sure woud find favor with the client.
> But if that's the case I could propose it.
>
> r
>
> -------- Original Message --------
> Subject: Re: [AccessD] 2 Client Requests
> From: Gustav Brock <gustav at cactus.dk>
> Date: Tue, January 15, 2019 11:36 pm
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
>
> Hi Rocky
>
> Could you embed a Word object?
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Rocky
> Smolin
> Sendt: 16. januar 2019 05:03
> Til: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com>; 'Off Topic'
> <dba-ot at databaseadvisors.com>
> Emne: [AccessD] 2 Client Requests
>
> Dear Lists:
>
>
>
> 1 - Client has an app to control tasks in a project with a large text
> box for comments on a task. The task box is bound to a memo field. He
> would like to be able to copy and paste from a boilerplate spreadsheet
> that has steps to complete a task - wants to cut and paste but the data
> loses formatting. Biggest problem is that it inserts 3 lines in the text
> box for every line of spreadsheet imported. But also he'd need to see
> columns a, b and c spaced correctly so they line up in columns.
>
>
>
> 2 - He would also like to be able to create a hyperlink from any text in
> that text box that would link to a document. Easy enough in Word -
> select the text, right click Hyperlink and the dialog box asks you for
> what's to be opened when you click the new hyperlink. But that doesn't
> work in a text box
> - you can select text, right click, but there's no Hyperlink option in
> the context menu.
>
>
>
> I told him the best way would be for me to put a "Find Spreadsheet"
> button on the form which would open up the file dialog box and after he
> selects the spreadsheet, I'd open in in VBA and get the cells one at a
> time and format them correctly. Then of course, he added other features
> - specify which lines are to be imported and which columns. So that
> would make the hyperlink a much easier solution.
>
>
>
> But.can it be done?
>
> MTIA
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 760-683-5777
>
>  <http://www.bchacc.com> www.bchacc.com
>
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
>
> Skype: rocky.smolin
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>