Search results

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 =...

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.

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...

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...

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)...

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

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...

Static, any help on this please? Many Thanks

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

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;

Hi Static, any help on this please? Thanks

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

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

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...

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

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...

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

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...

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?

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