[AccessD] 2 Client Requests

Gustav Brock gustav at cactus.dk
Wed Jan 16 12:15:51 CST 2019

Hi Rocky

Yes, but he is demanding a word processor off a memo field …
So, either reduce demands or use a word processor - and Word is probably free for him to use.


Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af RockySmolin at bchacc.com <RockySmolin at bchacc.com>
Sendt: 16. januar 2019 16:47
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] 2 Client Requests


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.


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


-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Rocky
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?


Rocky Smolin

Beach Access Software


 <http://www.bchacc.com> www.bchacc.com

 <http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin

More information about the AccessD mailing list