PDA

View Full Version : Help please withActivex control and Microsoft Access VB bug?



Martin Neighbours
12-22-2002, 03:44 PM
I'm developing an application in Microsoft Access 2000 which uses the mappoint activex control. The user selects a branch and the info to be displayed, the map then zooms to that branch and displays the chosen points around it.

I'm creating a new table in MS access for the data to be displayed and then using importdata to show it in the activex control.

The problem is that the first time I run this it works as it should, but then when I try another selection I get a message "the data necessary to complete this operation is not yet available".

Even stranger, when I put a message box on the screen with an o.k. box to click before executing the importdata command, the problem doesn't occur.

I've tried checking the readystate of the control, but this always seems to be 4. The table does seem to be available in MS access.

Any help would be very much appreciated.

Martin

Eric Frost
08-04-2011, 01:40 PM
Hi Martin,

It took me nearly a decade, but I think I might have an answer! hehe. No really I'm just posting a possible solution in case other people like me search and come across this thread.

In my case, I was trying to do a ZoomTo to an empty dataset.


oDS.ZoomTo


This generated the error: "the data necessary to complete this operation is not yet available"