Search results

  1. D

    Display the answer of each question in word document from Access form

    Static, As the code is on click event of a button. so when I click the button first then it gives me runtime error '462',The remote server machine doesn't exist or unavailable? When I press debug then it makes the following line highlighted: r.Borders(i).LineStyle =...
  2. D

    Display the answer of each question in word document from Access form

    Also please see attached the word doc , we need to adjust the table so some alignments needs to be made .. Many thanks for your help so far. Please can you help me in displaying the headers and adjusting the alignments now. I am almost there so need your help badly.
  3. D

    Display the answer of each question in word document from Access form

    Static, sorry to bother you but I want some tweaks in the code. The following code now works but doesn't display all the Headers. The code displays RefID,Document name and Score . But I also want it to look for Header field in the Query and display appropriate headers for the records...
  4. D

    Display the answer of each question in word document from Access form

    Static, I can't upload the database because of security restrictions so see attached the PDF format for the tables tblQAMatrix and tblQAStandard. And also I do need headers for all the Records which are in "Headers" field because for each Form the header is different. e.g for Health check...
  5. D

    Display the answer of each question in word document from Access form

    Static, as discussed in the previous posts I am getting "Subscript out of range runtime error 9" in the code: Do Until .EOF CurSec = Split(.Fields(0), ".") Set wr = wt.Rows.Add wr.Cells(1).Range.Text = CurSec(1) & "." & CurSec(2)...
  6. D

    Display the answer of each question in word document from Access form

    Yes Aman and I are in the same team working on the same task but nobody is able to figure it out :(
  7. D

    Display the answer of each question in word document from Access form

    Static, there was some formatting issues when the data gets copied across word document. Doesn't look like the actual word template as attached. So I am just looking for another alternative so that the template remains same with everything (all the formatting etc..) and just copy the Scoring...
  8. D

    Display the answer of each question in word document from Access form

    Static, any help on this please? Many Thanks
  9. D

    Display the answer of each question in word document from Access form

    Static, is there any way to keep the word document as attached . And just add the scoring in the next blank column ??
  10. D

    Display the answer of each question in word document from Access form

    Please see attached. The query qryQAMatrix is as below: SELECT tblQAMatrix.RefID, tblQAMatrix.StandardDoc, tblQAStandard.Score, tblQAStandard.QAID FROM tblQAMatrix INNER JOIN tblQAStandard ON tblQAMatrix.ID = tblQAStandard.StandardID;
  11. D

    Display the answer of each question in word document from Access form

    Hi Static, any help on this please? Thanks
  12. D

    Display the answer of each question in word document from Access form

    refID is in the following format: 1.1 1.2 1.3 1.4 2.1 2.2
  13. D

    Display the answer of each question in word document from Access form

    I got 3 fields in the query named "RefID","Standard Docs" and "Score". RefID has Text datatype StandardDocs has Text datatype Score has number datatype
  14. D

    Display the answer of each question in word document from Access form

    Static, I am getting "Runtime error 9 Subscript out of range" in the following line: wr.Cells(1).Range.Text = CurSec(1) & "." & CurSec(2) The following is the complete code: Private Sub cmdSummit_Click() Dim CurSec() As String, PrevSec As String With...
  15. D

    Display the answer of each question in word document from Access form

    And also just wondering Can we have just one column for score instead of 3 separate columns (Yes,No,N/A)?
  16. D

    Display the answer of each question in word document from Access form

    Hi Static, I tried the code and I'm getting runtime error 5992, Cannot access individuals columns in this collection because the table has mixed cell widths at the following: wt.Columns(1).Width = 40 wt.Columns(2).Width = 400 wt.Columns(3).Width = 30 wt.Columns(4).Width...
  17. D

    Display the answer of each question in word document from Access form

    Hi Static, The code is giving me compile error "Sub or function not defined" at Rowformat line. :( Can you pls help me in this? Thanks
  18. D

    Display the answer of each question in word document from Access form

    Thanks Static, Just have spoken to my manager and he said it will be nice if I display 3 sections 1. Passed 2. Failed 3. N/A so in the Passed section, all the questions will appear whose answer is Yes. in the Failed section, all those questions will appear whose answer is No in the N/A...
  19. D

    Display the answer of each question in word document from Access form

    Thanks Static, As I have already designed the word document with appropriate header and footer and Title etc... Can we insert the table automatically after the Title and Objective section as attached?
  20. D

    Display the answer of each question in word document from Access form

    Hello Uncle Gizmo I want to get this done using VBA. So basically when the button is clicked then populate answer to each question (Yes, No or N/A) in word document and print it off. Thanks
Back
Top Bottom