Search results for query: *

I have written a piece of VBA code to automatically generate graphs from a page of data. The code seems to run fine most of the time but occasionally I get a problem with huge font on the X and Y axes. I don't really understand why excel does this as most of the time it runs okay. I think it...

Hello, I have recently had a rather strange problem running code to insert charts. The problem originally started as a memory problem. I am creating about 36 charts from a large amount of data and pasting these in a new worksheet. Up to a point this ran no problem, but with a larger amount of...

Hello, I have been using Active X to control and run macros from my excel file. However, recently when I updated my excel file Active X no longer recognises the macros within it. It as if the workbook has some kind of added protection. I am unsure of what I have done. Does anyone have any idea...

I am attempting to delete lines from an ODBC linked MySQl database using SQL statements from Excel but I am having some difficulty. The use of the line: dbData.Execute sqlClear with the string sqlClear defined as: sqlClear = "DELETE FROM marketdatapx WHERE network = 'IEEE57' and date1 =...

Yes I have authority to delete and I can delete the entries in question using MySQL front from my machine.

I do use a DSN but the 'configure' settings box does not have a 'Read only' option. I do not think it is read only anyway as I am able to write to the database (described above.)

Hello, I am using an ODBC link to a MySQL database. I am controlling this through an Excel VBA application. My VBA code includes the following line to open the database: Set dbData = OpenDatabase("", , False, "ODBC:") I then have no problem adding some record to the...

Hello, This is probably totally obvious to an experienced VBA/Excel user. I am finding this problem increasingly frustrating though and would be grateful of some assistance. I wish to select a group of cells in an Excel workbook using VBA code. I use the command "Cells" to...

Hi, I have a table with various columns. I need access to do a calculation with data from two of these columns and then post it to the end of the row. The reasons for doing this are quite complicated but basically I am using the database with an ASP and it doesn't like calculations done to...

Hi, For people who use ODBC a lot this will seem really obvious. I am using Drumbeat 2000 to develop a website that uses an Access database. However at the moment when I try to load my page I get this ODBC error Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC...

So I would just keep everything in the one database and sort it there according to the time period it refers to and then use a query from the web to get the information that I need?

Hello, I am designing a database that takes input from the internet via a drumbeat interface. In the first instance this data is put into a table called 'data'. The information is for selling electricity and contains the following fields : - user name time of entry quantity to sell price to...