SV650.org - SV650 & Gladius 650 Forum



Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick).
There's also a "U" rating so please respect this. Newbies can also say "hello" here too.

Reply
 
Thread Tools
Old 06-09-08, 08:27 PM   #1
mattb200
Guest
 
Posts: n/a
Default IT help please...How do I transfer from Access to......

Ok here's the scenario for all you IT professionals out there:

I have created a database in MS Access at work and need to be able to create a pre-filled MS Word doc from the data in the database. I have used a fair bit of VB code behind the custom forms and whilst I don't do this for a living I can usually create enough code to get around most issues and know some basic SQL.

What my database basically does is let the user log a 'query' and then provide a reference number. At this point I want the user to be able to click the OK button and automatically open a word doc with most fields pre-filled so that they only need to add an address to the letter and then print - which will not be stored in the db as it could be one of thousands of different addresses.

Had a bit of a play with the mail merge in Word but I think I am probably making it more difficult than it really is and just don't know how to do it.

Any suggestions on how to go about this would be appreciated.

Thanks
  Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Synchronising with MS Access andyb Idle Banter 17 30-04-08 08:08 PM
Anyone got or have access to... zedleppelin1981 Soho Massive 0 01-10-07 02:54 PM
direct access Dave The Rave Pennine Massive 30 20-05-06 06:58 PM
Business transfer agents Ed Idle Banter 0 08-03-06 10:58 PM


All times are GMT. The time now is 10:42 AM.


Powered by vBulletin® - Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.