Results 1 to 2 of 2
  1. #1
    Gadai is offline Novice
    Windows 8 Access 2016
    Join Date
    Jun 2016
    Posts
    1

    Exclamation linking word document with access database


    hi everyone,

    i am writing a book with more than 80,000 words in MS Word. the book has more than thirty chapters, and a table of contents.

    i have created an access database with a table = 'Chapters'. with these fields --
    1. chapter name
    2. Hyperlink
    3. chapter word count
    4. notes

    data in 'chapter' table will look like this --

    chapter name // hyperlink // chapter word count // notes
    aaa // aaa // 4000 // lsldkf
    bbb // bbb // 5000 // saifdouw
    ccc // ccc // 3000 // oiuoiuwe

    here clicking on aaa hyperlink will open chapter 'aaa' in word file. 4000 is the total words in chapter 'aaa'

    my question is

    1. how to add hyperlink of a chapter in 'hyperlink' field
    2. how to insert word count for a 'chapter in chapter word count' field

    thanks in advance

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    to count the number of words in a field you can use vba

    dim strSplit()
    Strsplit = Split([fieldname]," ")
    msgbox "spaces found = " & ubound(strsplit) + 1

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-18-2015, 08:08 AM
  2. Replies: 3
    Last Post: 12-18-2013, 02:23 PM
  3. Replies: 1
    Last Post: 02-28-2013, 02:41 PM
  4. Create Database from Word Document
    By jwtasu in forum Import/Export Data
    Replies: 4
    Last Post: 06-15-2012, 02:12 AM
  5. Replies: 0
    Last Post: 06-14-2010, 07:19 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums