Help Maintenance and call center

[Ahmad93]

Good day all , I want to make the users enter their comments in access form and press a button to submit his comments and it will automatically generate word document and save it on my shared folder. I already have the word document, the word document contains : Villa # Zone # Contact# Date Ticket# And table for comments with s/q.

 

[HiTechCoach]

To do what you ask for, you will need to write a lot of VBA code to use Word automation to either perform a mail merge or use bookmarks to fill out the document. Warning: This will require Word to be installed on the workstation running Access.

If I were doing what you ask for, I would use an Access report. Use VBA code to automatically save the report as a word document. Very little code required. Bonus: Word is not required to be installed.

 

[Ahmad93]

Thank u for replying , but if I made a report will the users be able to add their comments and will it merge with the word document

 

[Dreamweaver]

Hi why use word it sounds like it would be an ideal job for access no need to complicate things with word automation
Mick

 

[Ahmad93]

I work in housing maintenance around 300 villa , I have a ticket.docx when I receive an email from the home owner with their comments I enter the comments in word. And then record it in access. That’s why I need a word to be on access so the homeowner can enter his comments.

 

[zeroaccess]

I work in housing maintenance around 300 villa , I have a ticket.docx when I receive an email from the home owner with their comments I enter the comments in word. And then record it in access. That’s why I need a word to be on access so the homeowner can enter his comments.

If you create this document as a Report in Access, it will be the better approach.

Otherwise, here's what you're in for: