Computer Learning Zone CLZ Access Excel Word Windows

Our passion for learning, evident in the behaviour of every toddler, is the tool for our survival.

-Carl Sagan
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Visitor Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Custom dictionary
Mick Webb 

2 years ago
I have a custom dictionary that works as it should until I sort it. Then on the first run it will get overwritten with a new blank (apart from my name) file. Any ideas on this?
Adam Schwanz  @Reply  
           
2 years ago
Can you elaborate more? I don't understand the question or whats happening, pictures might help
Richard Rost  @Reply  
          
2 years ago
Hi Mick. Like Adam said, this is nowhere near enough information for us to be able to help you. You don't even tell us what software you're working with. Is it Access, Excel, Word, or something else?
Mick Webb OP  @Reply  

2 years ago
Thank you for your interest in this which, I am glad to say, I have resolved.
This is a MS Office custom dictionary which I am using in MS Access ' although it is seen and recognised in all Office apps, working as it should with any of the spell checking dialogs.
I am actually using it with a custom Spell Checker form, which exposes the MS Word spelling objects and works with them ' just as it should.
New words are added to the dictionary via FSO which appends them to the column within the file, obviously in the order that they are created. My problem was that if I programmatically sorted the dictionary, the first time that the CheckSpelling method was called the file got overwritten with a new version ' this containing , as the Office user, just my names.
To sort the dictionary file, using FSO I read the words into an ADO recordset, sort it and then write back from the recordset into the file. As I could manually sort the file in Notepad ++ which did not create the overwrite issue, I deduced that my problem lay here.
My first pass had concatenated the words from the recordset into a string with a vbCrLf between and then wrote the whole string to the file ' no success.
I then wrote each word separately into the file ' no success.  
I tried deleting the file and recreating it before I wrote to it ' no success.
I tried writing a zero length sting to the file to clear it and then appending the words' no success.
Finally I returned to my first pass but used a vbLf only ' SUCCESS.
It all now works as it should.
Richard Rost  @Reply  
          
2 years ago
Very interesting, thank you for sharing.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 9:41:09 AM. PLT: 1s