Thanks Dave, I'll give it a try. (FredNurk was me on a temporary account).
I had been hoping to find some feature that would do it for me, but with no other responses in well over a year, I suppose there's no point holding my breath.
Will post here how it goes.
Killer42
Joined: Oct 11 '06
Location: Australia
-
How does it do the geocoding? I don't recall VB6 having any sort of geocoding built in (remember how old it is!).
So my point still stands that it would most likely be done via an API call to some mapping product; looking up that interface info for the product may provide what you're after.
Can you provide info on how the geocoding is being done?Leave a comment:
-
I believe you're in the wrong forum. That looks like VB.Net code, and this is the VB6 (very old pre-dotnet version) forum. That's probably why you haven't seen much of a response.
Speaking strictly from a VB6 perspective, I would have suggested using the DateDiff() function to get the difference as a number of known units - most likely seconds. But I have no idea what the VB.Net equivalent would be. Perhaps a search for something like...Leave a comment:
-
Could you please provide more information? What do you mean, precisely, by "calling" another form? Could you show us the part of the code which has a problem?
Also, in what way does it not work? Do you receive an error message? If so, providing us the details from that might help.Leave a comment:
-
The Access database is a completely separate thing, having nothing to do with your VB project. You would need to ship it along with your EXE file.Leave a comment:
-
I think we would need to know a lot more details about the controls involved, what code might be triggered by events happening to them, that sort of thing. Just as an example, if you are changing the colours in the LostFocus event to indicate that the control no longer has the focus, perhaps you used the wrong colour.Leave a comment:
-
Yes, probably you have some code being executed each time the text box is updated, to perform some sort of query and update the contents of the list box. Putting a square bracket into that query is probably what caused the error. But it's hard to say anything definite without seeing what that code does.Leave a comment:
-
When you say "latest" - is this based on the name, or the update date/time?
Also, are you sure it's a listbox you want to use?Leave a comment:
-
Could you please provide more specific information? What sort of problem?Leave a comment:
-
I don't think any VB reference will tell you how to do this. It would have to be some product (for example Google Maps) which converts one to the other. What you would need to find is the API information so that you can use VB to interact with the product.Leave a comment:
-
Thanks ServerThemes. Although it's probably a bit late to help India777, any information added here is potentially helpful next time someone comes along with a similar question.Leave a comment:
-
That's the great thing about these archives, of course. Here it is almost three years later, and this answer is still helping people.Leave a comment:
-
Yeah, I find that if you make a habit of putting in that little extra effort up front to keep your code tight, you often save time fussing with it later.
A bit like the old "measure twice, cut once" rule in building. :-)Leave a comment:
-
Looks good.
I do have a couple of small suggestions, though.
First, put a DoEvents inside that loop to allow Windows to do other things.
Also, while the impact would be tiny in this case, as a general rule I recommend avoiding unnecessary calculations. In other words, rather than doing a calculation every time around the loop to determine the elapsed time, I'd just calculate the ending time once, and check...Leave a comment:
-
Nice.
But shouldn't lngStartTime be a Double?Leave a comment:
-
Ok, I know nothing about MBAL, whatever that is. However, and this is just a guess based on what seems like a possibly similar interface in MS Word, have you tried SaveAs in place of SaveFile?Leave a comment:
-
Not in VB6 you can't.Leave a comment:
-
I recommend posting as a new question. This is a very old thread, so not many people are likely to read it.
Also, can you try to expand on what you mean? I don't really understand what it is you want to know.Leave a comment:
-
I don't think Cells(x + y + 4, "D") is correct to address a cell in VB code. For the two coordinates you're providing a numeric expression and a string.
It seems as though you are still having a problem incorporating variables in your expressions. If I remove the quotes around the "D" in this latest line of code, leaving this...
...Code:Cells(x + y + 4, D).Formula = "=sum(cells(x+1 , 4) : cells(x+y+1 , 4))
Leave a comment:
-
Oh, and a general tip. You'll probably find more VBA expertise in the Microsoft Access / VBA forum.Leave a comment:
No activity results to display
Leave a comment: