Recent content by Dharmesh

Hello Thanks for that: 'select query Set db = CurrentDb sSQL = db.QueryDefs("Hanging_MR").SQL Set rs = db.OpenRecordset(sSQL) For i = 1 To rs.Fields.Count mySheet.Cells(1, i).Value = rs.Fields(i - 1).Name Next i mySheet.Cells(2...

Hello I have written some coding in access, which creates an excel file and exports data to it. I want to create a pivot table based on this. there seems to be a problem with part of my coding in creating a pivot table. can anyone help. Attached is my code. Thanks Dharmesh

Hi I have a command button which is linked to a parameter query. The query runs perfectly when the command button is selected, but i want to add the value of the parameter query into the VBA code so that i dont have to keep on typing the value in. Is there a way of doing this. Thanks Dharmesh

Hi, does anyone know how to calculate the sum of fields in a cell. Thanks Dharmesh

Hi I have set excel to nothing, but a problem still occurs. Dharmesh

Hi I have some coding which runs the first time, but on the second go, it gives a runtime error 1004. Does anyone know the problem. Thanks Dharmesh Private Sub Command0_Click() Dim myExcel As Excel.Application Dim myBook As Excel.Workbook Dim mySheet As Excel.Worksheet Dim rs...

Hi Thanks for this, this is working brilliantly. Can you tell me what the problem was with the code. Thanks Dharmesh

Hi ive put the code in, but im still getting a runtime error 1004. I get the error on line: Range("A1:A8").Select Do you have any ideas. Thanks Dharmesh

Hi, i have some coding which exports a query into Excel and then a graph is manipulated from this. the coding works, but the second time you run it I get a runtime 1004 'global error' Below is my code, can anyone tell me what the problem is: Dim myExcel As New Excel.Application Dim...

hello I have some coding which exports a file and then deletes a certain column. I have some coding which does this, it works sometimes, but sometimes it comes up with a runtime 1004 error. Below is the code, does anyone have a clue why it doesnt work. All im trying to do is delete column G...

Hello I am having problems with some conditional formatting code, can anyone help me. I basically have a piece of code which adds subtotals and totals to an excel file. I have some coding to colour the subtotal and total rows, but its does not seem to work. can anyone help me with it. thanks...

Hi Ive tried to export it, but it comes out as data and not a graph. Does anyone have any code to make the graph export as a graph onto Excel. thanks Dharmesh

Hi i have a form which has a graph on it, i want to export this to excel, is this possible, and how. dharmesh

hello i have a database which creates excel files from queries. Is it possible using some coding to add subtotals and totals to the excel file. I want to add subtotals so that when a department changes, a subtotal is added and then a total is added. Dharmesh

Hello, Ive been trying to use the calendar function, but still with no success. I have been throught the forums to find a simple example, but cannot find one. I have a database which holds various sales information. I have form which has combo boxes and when the criteria is selected, the values...