[AccessD] 2 Client Requests

[John Colby]

No but it is generally a bracket code.

Read this?

http://www.echoecho.com/htmllinks01.htm

On Wed, Jan 16, 2019, 12:53 PM <RockySmolin at bchacc.com wrote:

> John:
>
> It is an rtf box - can accept bold, underline, etc. But I don't see a
> way to select a word and make it a hyperlink nad identify the target.
> Do you know?
>
> Thanks
>
> Rocky
>
>
> -------- Original Message --------
> Subject: Re: [AccessD] 2 Client Requests
> From: John Colby <jwcolby at gmail.com>
> Date: Wed, January 16, 2019 9:40 am
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
>
> 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
> >
> --
> 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
>