Search results

I'm trying to write VBA code that will update the queries in an Excel spreadsheet when the database they reference is moved. Clients want to be able to share the database and linked spreadsheet across a number of computers as well as a network. I've tried examples on the web that are meant to...

I'm using the below code in an Access form to import XML files. I get an error 31593, "DTD is prohibited". How can I fix this? Thanks in advance, Paul Private Sub Command0_Click() Dim StrFileName As String Dim fd As FileDialog Dim vrtSelectedItem As Variant Dim strprop As...

I'm having problems importing a spreadsheet from Excel for a client. They are using Access 2003 and Excel 2007, 3.5GB RAM It works perfectly on my machine - Excel 2010 and Access 2007-2010, 4 GB RAM. The file is imported in Excel 97-2003 format via a macro using the transferspreadsheet...

I'm facing a few difficulties with a macro to import spreadsheets into Access database tables. Each spreadsheet file represents a different month (e.g. for August-October 2012, there will be different files named 201208.xlsx, 201209.xlsx and 201210.xlsx) and each file contains only one tab with...

Hi all, I'm trying to populate an Excel spreadsheet with information captured by Access queries. I figured the easiest way to do this (as there will be many queries) would be to build a macro for each query and then run a macro that runs all those macros, populating the relevant parts of the...

Hi everyone, I'm trying to run a query that sums information across tables. I have a whole load of half hourly data and want to aggregate it at a monthly level, then report it across months. I have a different table for each month of the year. Each table includes the amount of electricity...

Hi all, I'm a new member, fairly expert in Excel but only a beginner in Access. I'm a consultant in the energy industry and often have to deal with big datasets of half-hourly data. A lot of people in the industry here prefer Excel but it just gets too unwieldy with large amounts of data, so I...

Hi everyone, I'm hoping someone could give me some direction as it's been a few years since I've fired up Access. I'm building a 5-year financial model for an energy company. The kind of information includes the amount of energy produced, and the price it is sold for, for each individual power...