Search results

Thanks Mark, much appreciated. The DoCmd.RunMacro refers to a macro I have in the xls worksheet to refresh connections and save, then close the xls... In any case, should I be doing something else to make it work?

You could try... Public Sub RunExcelMacro() Dim wb1 As Object Set wb1 = CreateObject("Excel.Application") With wb1 .Workbooks.Open ("XLS path") .Visible = True End With Set wb1 = Nothing End Sub

Hi All, New to VBA and managed to get this far with some code... Option Compare Database Public Sub RunExcelMacro() Dim wb1 As Object Set wb1 = CreateObject("Excel.Application") With wb1 .Workbooks.Open ("XLS name") .Visible = True .DoCmd.RunMacro...

Hi All, I have a form that I want "refreshing" i.e. requerying to update the graphs that sit on it. I have the following but for some reason it's not working and I've tried multiple ways to solve - any help would be much appreciated: Option Compare Database Option Explicit Public Sub...

Hi all, I'm trying to create a list of months based on two dates, start and end date. I can't for the life of me work out how to do it! The information the formula would use would be the dates from when a project begins and when a project ends. This would list the months including and...

Hi John, Thanks for taking the time to post and share your experience! This is probably the best alternative solution there is! It makes a lot of sense to make it a static file and then upload the data as it is updated. The only constraint there is, is that it would not record holidays...

Hi all, I'm building an access DB which has a linked table to excel, which is working and all is fine on that front. What I need to be able to do, is build in functionality that can edit the linked table. As I understand, I can't do this because the data is dependent on the table and...

Thank you both! Much appreciated, I tried Minty's approach and that worked a charm. Merci!

Hi All, I'm trying to run a top 10 query where I ignore the names of 5 people but include the rest. The sql I've got so far is: SELECT TOP 10 Sum([All Combined].SumOfTotalCost) AS SumOfSumOfTotalCost, [All Combined].name FROM [All Combined] WHERE (((Month([Month]))=Month(Now())-1)) and ((([All...

Hi All, I'm building a DB chart in a form and I can't for the life of me remember how to add a secondary y axis to a chart. The wizard for 2010 is useless. I'm trying to have the total costs of the X axis values on the left and the total count of the x axis values on the right. Any help...

Great! Thanks so much I tried and it worked. For clarity, what do you mean by "do the summing"? Also, would you mind giving me an example of what I should be doing to sum columns? I.e., what the SQL would look like. In the actual database there are a lot of columns being summed in different queries.

Sorry - rushed through that to make an example. Attached is a DB and the test data. As you'll note, the Graph "Previous Month's Spend" is over £1000 less than the data date the query is feeding from, the ALL AB query. The data is there, for some reason it's being ignored though.

Thanks! Data is attached along with mock DB. The total should be over 10k but the charts are pulling in way less than that.

Probably obvious though how do I upload data?

Apologies, I should have said in the original thread. All of the charts feed off queries, built from the linked data. Some of the charts are combining up to six queries in Union. The underlying data in the queries is correct and all totals are there. It just seems that for whatever reason...

Hi All, Apologies in advance if this is a) the wrong place to post and b) it's been solved - I've looked for 2 days and can't see anything - only how to hide duplicates. I'm creating a spend reporting database that feeds data from excel into an access DB. The link works and the...