Search results for query: *

Hello! In Excel I have developed a front end data browser that gives access to a whole raft of survey data stored in the same file. This browser, and the data involved, has value that we sell on to interested clients for a license fee. My concern is that it is relatively easy for one person...

Hi folks, The is a piece of code recorded directly from Excel in creating a bubble chart with 17 points. Using the chart dialogue box ('Source data') works fine i.e. 17 points added. However, running this code by itself results in a chart with only 1 point! Even wierder, going back into the...

Having inherited an MS Access database from the original programmer I have been making some very insubstantial tweaks to some VBA code sitting behind a number of forms. On one particular form it is throwing up an error due to the Option Explicit statement and some undeclared variables. This is...

Is it possible to have more than one procedure running at the same time in VBA? If so, how? In an Excel system I am building, I would like to fire off one procedure that initialises a MySQL database, and without having to wait for that to complete, continue with the loading of my front-end...

Hello, I'm developing a system with an Excel front-end that uses ADODB and MyODBC to fire off instructions to a (local machine) MySQL server. As I step through my VBA code, it sends an instruction to MySQL (e.g. gconMySQL.Execute "DROP TABLE IF EXISTS MyData;" ), waits for the instruction to...

Hi all, I'm developing a system in MSExcel that uses VBA and Excel forms for the front end, whilst using a MySQL server local to each machine to process the data in the background. On starting up the Excel system I want to:- a) (if necessary) check whether or not the MySQL server is running...

Is it possible to calculate the PRODUCT of field values as they are combined using a GROUP BY clause? For example: MyID MyValue 1 2 1 3 1 3 2 2 2 3 2 1 SELECT MyID, PRODUCT(MyValue) AS MyValue2 FROM MyTable GROUP BY MyID; To give MyID MyValue2 1 18 2 6 So far I can only do it by...

Is it possible to open the visual basic editor window from code? If so how?

I have an Access database (call it the 'master' database) with startup properties that close down a lot of the standard options to users. I've also password-protected the code & form design. What I would like to do is programmatically - from another database - open the master database but...

Can anyone suggest a method of measuring the size of a HEAP/MEMORY-type table? This would be useful to set an appropriate figure for the max_heap_table_size server variable. I can create the table on disk rather than in memory and check the file size that way, but is there a more direct method?

I wonder if you can help me with this one? I have two tables as follows:- Firstly VP_JOURNEYS, about 1.5 million records, indexed on (Start, End): CREATE TABLE VP_Journeys (PersonID MEDIUMINT UNSIGNED NOT NULL, Start SMALLINT UNSIGNED NOT NULL, End SMALLINT UNSIGNED NOT NULL); ALTER TABLE...

It is possible in MySQL to implicitly qualify the table names where columns are unique to a given table e.g. SELECT MyTable1.MyColumn1 FROM MyTable1 INNER JOIN MyTable2 etc. can also be written as SELECT MyColumn1 FROM MyTable1 INNER JOIN MyTable 2 etc. on the assumption that MyColumn1 is...

Much as I am loathe to use these excellent forums for debugging, this is all that remains to prevent me from banging my head against the wall. I have two tables:- CREATE TABLE Data_TestPacks (TestPackID SMALLINT UNSIGNED, PosterID CHAR(15)); CREATE TABLE Data_AllPosterData (PosterID...

Hello, I am in the 'thinking' stage of migrating a fairly data-intensive MS Access process to MySQL, in order to improve the performance of the batch of queries. These queries are invisible to the standard user, the only user interaction being a VBA-built front end and an Excel output at the...

Ha ha, I have just had the joys of installing MySQL (Windows binary) and am slowly getting my head around the admin functions. My database learning curve has been based wholly upon MS Access, so I'm very excited about the potential improvement in performance that MySQL might bring. Current...

Hi folks, One stage in a piece of data analysis I'm doing involves ranking an array of (double-precision) values. The array is anywhere between 2 and 2500 items long. So far I am implementing this by writing the values to a worksheet and using the WorkbookFunction.Rank function to return the...

Hello readers. I'm building an application in Excel. One sheet has a fair number of controls (about 50) to help navigate the user through the application. Due to the joys of backwards compatability and the need for a treeview control (which, I have subsequently discovered, will not sit on a...

Hello there. I'm having trouble converting an Excel-based data browser (developed in Office XP) into a version that is useable in Office 97. The problem appears to be the TreeView object. Starting afresh in Excel 97 I can insert the Microsoft TreeView Control 6.0 (SP4) onto a User Form, but...

As I'm sure all you Excel experts out there know, Excel provides an autofill function based upon any column list you are filling. This list is also available through a cell's right-click menu (...Pick From List...). This functionality is really helpful when trying to fill a larger column with...

Is it possible to refer to the properties of an object by name, perhaps as if they were part of an array? e.g. Window.Properties("Caption") = "Data Window" Window.Properties("Height") = 400 Window.Properties("Visible") = True The context:- I'm creating...