Recent content by marklenel

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...

Wierd, isn't it. Still trying to replicate the 'tweak' in code, though, as it's still sticking. It's still only showing 1 bubble/point, so trying to manipulate the DataLabels for point 2 etc. make it go Pete Tong.

Bubble sizes are currently between 0.3 and 0.7. I don't think that matters too much - Excel chooses a scaling that suits all the bubbles on the chart. However, having just changed one cell in the bubble size range, all points on the chart suddenly appear!!! It appears that the series is being...

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...

Many thanks sostek. I've got the ODBC drivers and am implementing healthy connection strings to the MySQL server when it's running . I need a way of ensuring that it's up and running and accepting connections in order to avoid nasty nasty error messages filtering back into the VBA. Since...

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...

That's very nice rac2 - thank you - but I'm going to have to hold half of your star in reserve I'm afraid... When MyValue is zero or negative, LOG(MyValue) returns an error. How would you find the product of e.g. -2, +3, -4 and -5 (with a result of -120)?

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...

I agree! We started looking at copying only new and updated objects to the original system, then came across this problem. Our current solution is to replace the entire front-end, and copy relevant data from the old system to the new one.

Many thanks Martin, That's one of the things we've tried. However, if I give you a little more context you'll see why it's not working for our particular situation. I've password-protected the code and form design in a database that is distributed on a number of computers. I need to update...

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...