Replies

Thanks, Charlotte
I have this database for personal use. I have all sorts of contact info in it: Family, friends, Business , firms that service equipment at home etc.
I use the memo facility to record details, perhaps the cost of parts or the solution to an IT query etc. At present I have made several calls to Belkin support, details in the memo field . I would like to be able to highlight a particular part of the memo text and print it to the default printer. Its nothing elaborate, I would simply highlight that part of the text that I wished to print. I hadn’t thought of using the context menu: my approach might have been through a button’s on dblclick event. A context menu solution sounds much more elegant though. (Because its essentially for personal use, I try to get a simple solution first and then maybe refine it at a later stage. I know, the project should be fully planned before the code is written!)
You’ve helped me on several occasions in the past. Thank You
Mike

Thanks for your help and advice. I’ve successfully got the macro ResetLinkPath. I’ll follow up the reference to Hyperlink Base in the Word help.
Many thanks to both of you. It’s good to know that there are so many helpful folk around. I’ve subscribed to the watches since the early days when there was only WWW, despite the fact that yesterday the system failed to recognise me and called me a ‘new lounger’.

Thanks for your help and advice. I’ve successfully got the macro ResetLinkPath. I’ll follow up the reference to Hyperlink Base in the Word help.
Many thanks to both of you. It’s good to know that there are so many helpful folk around. I’ve subscribed to the watches since the early days when there was only WWW, despite the fact that yesterday the system failed to recognise me and called me a ‘new lounger’.

Phil, Thanks for your suggestions. I could only get the notes on the Word Field Link Updater, I couldn’t find the Macro (resetLinkPath). I’ll go and have another look now.
Thanks
Mike

Phil, Thanks for your suggestions. I could only get the notes on the Word Field Link Updater, I couldn’t find the Macro (resetLinkPath). I’ll go and have another look now.
Thanks
Mike

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was still giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was still giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was staill giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike
I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was staill giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike
I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

(Edited by charlotte on 09-Sep-04 19:41. to add link to MSKB)

Article 209653 Microsoft Knowledge Base Article 209653
Record source a table.
Originally an expression as per the KB example applied throught the control source.
However the error repeated without any data other than the text box name on the form. I repeate I have had the whole thing work properly on an earlier db which has been deleted
Clearly this is something to do with the form (I’ve tried a virgin form-same result) and not with the sample code.
Mike

(Edited by charlotte on 09-Sep-04 19:41. to add link to MSKB)

Article 209653 Microsoft Knowledge Base Article 209653
Record source a table.
Originally an expression as per the KB example applied throught the control source.
However the error repeated without any data other than the text box name on the form. I repeate I have had the whole thing work properly on an earlier db which has been deleted
Clearly this is something to do with the form (I’ve tried a virgin form-same result) and not with the sample code.
Mike

Thanks Charlotte,
As I was thinking after your earleir email I realised that might be the solution. I have to say that the various occasions when you add a second instance of a table are non-intuitive.
Further in this example if I am going back several generations (>5) the query becomes a little cumbersome. Thank you anyway. I shall play with your solution and see how it works out. I had also used a tree control to show the various generations, though I programmed it manually. I hope to get some spare time once I have finished teaching this 12 week course and then I will experiment a bit more.
Many thanks for all your time and help. Something like not seeing wood for trees…I may be back!
Best wishes
Mike

Thanks Charlotte,
Maybe its me that’s missing something. I am replying immediately on reading your post. I shall think about it overnight, but I can’t see immediately how I can write a query to display My Father’s details and his father’s details unless his father’s ID is in my record. Yet something in the back of my mind says you are probably right, but I can’t see how to display father and grandfather (or more precisely how to set up a query which will do that. Hope you are right as it will simplify the whole db considerably.
Many thanks for your time
Mike

Two answers: 1 As in Excel, ctrlC copies the info from the same field in the previous record.
2.Helen Feddema I think wrote about this and suggested using the tag property of a control , maybe that was only for a single field. Have a look under Access Archon on helenfeddema.com
Hope it helps
Mike Trotter

Thanks Pat but with 900+ entries I wanted Access to do the work automatically , once I had made the basic link between son and father