+ Post New Thread
Results 1 to 5 of 5
Web Development Thread, Year Book in Coding and Web Development; Hi Last year, I embarked on a small project for Sixth Form Leavers and produced an Access database [flat file] ...
  1. #1

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    21

    Year Book

    Hi

    Last year, I embarked on a small project for Sixth Form Leavers and produced an Access database [flat file] and front end in Delphi. That all worked really well and we mail merge all the data in a nice big word document which created a Year Book!

    However the program was only avaliable in school as we don't have remote desktop. And the database was flat file as I you can't seem to do Relational Mail Merge in Word... [but SIMS.net does some how!!!??]

    My question is... is there a simple but good way to create a database on the web, maybe use PHP, [not sure] and extract the data and mail merge into Word. It would be nice to mail merge relational data as Sims does.

    Thanks

  2. #2
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75

    Re: Year Book

    Would coppermine do it?

  3. #3

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,807
    Thank Post
    3,320
    Thanked 1,056 Times in 977 Posts
    Rep Power
    365

    Re: Year Book

    since you originally mail merged the data into word, wouldnt it be easier if you just rename the images with something that relates to the students record so that you can use ASP or PHP to pull out the info from the DB and then just load the image based on say there first name or ID in the db ?

  4. #4

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    21

    Re: Year Book

    I will have a look at coppermine ... looks good

    But... I think i might not off explained myself; the kids fill in details about stuff in categories... with a paragraph of text e.g. Interests & Hobbies, Most Mememborable Moments, Ambitions, etc...

    That gets merged together with their picture. We then Merge into Word and send it to a professional printers.

    Have a great Christmas!!

  5. #5

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,807
    Thank Post
    3,320
    Thanked 1,056 Times in 977 Posts
    Rep Power
    365

    Re: Year Book

    If you had the database in a folder that you have access to , couldnt you just point word to that database on the server and merge it that way ?

SHARE:
+ Post New Thread

Similar Threads

  1. One DVD & Book
    By russdev in forum General Chat
    Replies: 14
    Last Post: 22nd January 2008, 08:55 AM
  2. php book
    By PEO in forum Books and Manuals
    Replies: 4
    Last Post: 14th November 2007, 03:01 PM
  3. Best Time Of The Year.
    By russdev in forum General Chat
    Replies: 13
    Last Post: 13th September 2007, 08:37 AM
  4. New Year 7 Induction
    By DSapseid in forum School ICT Policies
    Replies: 7
    Last Post: 18th June 2007, 10:42 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •