Search results

Hello, Many thanks for your reply. I think I may not have been clear. The code you sugguested would bring the value of .fields(6). What I need is all the values in colunm 6 in the recordset. Each colunm in the recordset has 12 rows so if im selecting column 6 is would only paste in 12 row of...

Hello All, I am wanting to know if is at all possible to create a recordset via SQL statement and then select the data from 1 of the columns in that recordset which in turn will be paste on an excel sheet. Code I Have so far below: Sub getscorecard(thing2 As String, thing3 As String...

Hello All, I have a problem. I have an excel document that link to a SQL Server and I need to figure out how to do the following; I have a bit of code that simple Select data from a table and copy the recordset in an excel sheets. Simple. Next part is the bit causing me some problems. The data...

Hi, Thanks for your reply. I know that you can add 3 conditional formats but I need to add at least 4, more in some fields. Any other ideas? Bantler

Hello, I am currently developing some scorecards for work which monitor and collate people performance score. So far these scorecard have been developed in Excel using VB code to assit in the condictional formatting. I am now thinking it is time to more these spreadsheet into access under one...