[AccessD] 2 Client Requests

RockySmolin at bchacc.com RockySmolin at bchacc.com
Wed Jan 16 09:47:16 CST 2019


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 

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list