Recent content by syoung4

This is just to let you know that I have now successfully fixed my problem. I had the pastespecial in the wrong place. I put it at the end instead of the begining where the sheets were created. this is my code now. It pastes the logo on to all the created worksheets in position (1,7) and then...

Thank you for your help the code works perfect. The only problem I am having now is that I am exporting to one workbook with multiple worksheets by looping through the data. I am putting the logo onto Cell G1 this works on all the sheets except the last one where the logo is put on to cell A1...

Please can anyone help me. I have a form in Access 97 which has parameter fields that are used to extract data from my database and Export to Excel when a button is clicked. We have Access 97 and Excel 2000 using the EXCEL9.OLB My code is quite long as it loops though recordsets and...

I didnt think their was. I have been using this code on my other queries that uses one query that has place holders eg. 'myWkEnd1','myWkEnd2' the query uses a date supplied from a form and creates a temp table and another query with all the correct details filled in. 'KEY FUNCTION 'creates...

Please can anyone help me. I am trying to supply two variable input dates to an SQL Specific passthrough query from and Access 97 Database. The table is on a remote server. This is the query I have so far it works if the table is in my database but not when I use the linked table. select...

Thank you jerry the code is now finished and works perfect. Thank you so much for your time and help. I didnt know enough about vb to get this going. Best regards Sid.

Thank you Jerry, this works perfect. I get only the qualifications for each employeeID. The last Problem I have now is that my code only makes writes one record to the table. I think its this area where all the loops are written to the table. Do Until rsPeople.EOF rsMaster.AddNew...

I have managed to solve the loops by changing the master table fileds to memo. This fixed the problem and writes the data to the master table now. But it puts all the qualifications from the table into each of the memo fields instead of only the qualifications for each employeeId. thank you...

I have managed to debug the recordset part of the code now " WHERE (((tblEmpHistory.DateFinish)is null))") I fixed the is null problem it only needed ))") the last closed bracket closes the sql part off. I am trying to get the loops working now. Loop rsMaster!NRWSA = strNRSWAQual Loop...

Thank you so much. I substituted the quote markes with apostraphies and that fixed it. I have other errors now with WHERE (((tblEmpHistory.DateFinish)is null") the is null does not work. But at least I have got over the worst. Thank you. regards, Sid.

Thank you for your help. I have put this code behind a button on an On Click event. When the button is clicked to run the code this error message is displayed: Run-time-error '3421' Data type conversion Error. I am trying to get the name, Marconi Id and Personal details to be captured in the...

Please can anyone help me. I am trying to loop through 6 recordsets and write the results to a table which is used for another program that produces badge ID cards. I am using Access 97 and would like to put the code as a module and call it from a button. The problem I am having when I run my...

Please can anyone help me. I have created an Access 97 Database that does a large Sql query stored on a remote server and outputs to multiple Excel Worksheets. It also copies a logo from the access form and pastes it on each worksheet. The code uses two sql inputs one to get the contractnames...

I am trying to send the results of a query that has been sorted by ContractName to Excel and put each set of Contract data on to a separate worksheet. The problem I have is there are 22 possible contracts and when the query is run the data returned may only have 2 contracts worth of data. I...

I forgot to say the criteria for selecting the Certificates each week is the Week Ending Thursdays. and The Organisation name which is the suppliers name. This is supplied through my form. which also makes a table from the data where I am trying to get the output to exel from called...