Search results

Perfect...Just what I wanted. Thanks for your help. All the best IC

Hi All, I would like to be able to have a button on a form that when clicked brings up the Colour picker chart like what is used setting colour in Design mode. Then when a colour is selected the colour code gets dropped into a field that can be referenced later by a form to colour code as...

Thanks again for your help with this. All is working fine now as per your help the previous thread. http://www.access-programmers.co.uk/forums/showthread.php?t=209678&goto=newpost IC

Got it this time. Thanks for all your assistance with this. IC

Hi There, I tried both of your options without success, although I am not confident I did all that was required. It did not seem to like Dim xlsRange As Excel.Range So in this case I cut the code down to xlApp.Selection.Subtotal GroupBy:=1, Replace:=True, PageBreaks:=False...

Hi There, Does anybody know what needs to be modified in the following Excel code, so that it can be run from Access. (I have added the xlApp. as needed) xlApp.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False If I just have...

Thanks again, however I do not know how to do this? Could you provide an example?

Thank you. I had tried that without any success.

Hi All, I am running some Excel code within Access after exporting to excel using the code below. All is ok except at the line... xlApp.Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5), Replace:=True, PageBreaks:=False, SummaryBelowData:=False I am not sure what other...

Thanks for your replies. I had tried db.Close which didn't work. I found a work around which has eleminated the need to Alter the table. Thanks for your help. IC

I have an Alter Table command followed by a Transfer Database command which transfers the tbale just alterred to another Access Database. The transfer command works fine as does the Altar table independantly however when the transfer follows the Alter table it cannot find the table to transfer...

I thought as much. I was hoping for something simpler. Thanks for your response. Ian

Hi All, I have a query which outputs a number of fields. SELECT qryTypeofProject_Report.* FROM qryTypeofProject_Report; I have used SELECT qryTypeofProject_Report.* in order to get all the fields from the initial query its based on. I want a final field that merges all the previous fields...

Thanks Everybody. The MkDir (MyPath) worked as I needed it to. IC

Thank you for this. I will give it a go. IC

Hi All, I am exporting a Query to excel to an existing Folder. I would like to be able to export to a new folder that is created before the export ie labelled by the current month. So my question is, is their a way to create a folder say on the desktop, labelled current month before the...

Thank you.

"Run Time Error 1004 Subtotal method of range class failed" The rest of the formating code before this line runs correctly. If I remove this line I do not get an error and the Excel worksheet formats accordingly. I just cannot get this line to run.

Yes that is what I am doing. I have some other formating code around this example that is working fine. Its just this one line I cannot get to run. THanks

Does anybody know how to amend this code so it works in Access. Set xlApp = CreateObject("Excel.Application") xlApp.Cells.Select xlApp.Selection.Subtotal GroupBy:=11, Function:=xlSum, TotalList:=Array(10), Replace:=True, PageBreaks:=False, SummaryBelowData:=True...