Search results

Hello, This is getting frustrating at the cost of many hours of production. A project i am working on is throwing a compile error on the line: baK(lIdx) = asc(Mid$(sKey, 1 + (lIdx Mod Len(sKey)), 1)) This is true for a few "MID" functions in this project that are entirely unrelated to one...

Uncle Gizmo: With the method i am using which is essentially justdisplaying Maps inside a browser control---not technically. I can do 2 things: 1.) point the browser to a specific GPS cord. (by modifying the control source URL of the browser) 2.) get the GPS cord manually by clicking the map...

Colin, Good info. I played around with the registry prior to making this post but was unsuccessful. I ended up modifying the reg from the stackoverflow post in your link. This seemed to help performance slightly. Performance is bareable at this point but not nearly as smooth as an actual...

Update: I was able to point the new control to the URL using this format: Me.WebBrowser0.ControlSource = "=""" & strURL & """" However, when Maps loads, i get a script error, which i can resolve by clicking no about 5 times (kind of annoying). The browser seems to load OK but its still not...

Hi, Last week i delved into trying to work with Google Maps in an Access form, where i discussed here: HERE To summarize that endeavor: all i really require is being able A) use Maps in the form B) Point Maps to a specific coordinate. Item B can be done simply passing the cords to the...

@isladogs: I'll probably just stick with my "free" method and not have to worry that Google is billing me unknowingly (not that I would realistically meet the quota). The only caveat is not being able to return GPS cords from the map marker, while still being able to point the map to specific...

@theDBguy I have attached a sample. All you would need is an API Key which can be obtain in under 5 minutes for free from this link: HERE Let me know what you think! @Gasman Good info, i didn't see that example. The key i have is for embedded use only. His example requires a 3 service key...

Hi all, Last night i fiddled around and after about 3 hours of fiddling around, some black magic happened and i was able to embed Google Maps into a form. Here is the source i followed: CLICK This code uses the ActiveX control: Microsoft Web Browser control, which for whatever reason...

Update: About a week later from finishing up the class for manipulating Scatter plots. Implementing this into my main project wonderfully brings several thousand curse words to the forefront of my computer screen. Heaven forbid you assign an erroneous value to an Axes.Property and the whole...

Update(s): This will probably be my final post for this, as i've achieved what I need for personal use for now. Here are final points, until next time. Custom Class "ScatPlotFormatter' I have attached a class that is called "ScatPlotFormatter". Note: Can't upload. The file is 1.11mb and...

UPDATE: OK Back again with more information. I began diving into building this class and things are going somewhat smoothly. The class so far can adjust the scaling and units of a scatterplot. However, as we discussed, the documentation is a joke. Therefore, finding all the properties is...

Agreed. What I am working on next is building my own class to work specifically with Scatter or Line charts. That way i at least have a simplified intellisense dialog and can actually write some code. This class wouldn't be as big of a deal had they provided all the properties in chart.object...

Minty, Thanks for replying. Yeah, thats the same properties i accessed above... The more i research this the more frustrating this is. The fact that they've littered the market with about 50 different combinations of charting in office over the last 20 years has really helped matters. What a...

Update: Still doing some investigating. I was able to change the max and min scale of the axes for a SCATTER PLOT. The original issue I had with previous attempts was getting runtime error '1004: "Unable to get the Axes property of the chart class" That error description sounds a lot like...

Hello, Next up on unsolved mysteries: manipulating a chart object via code. I reached out to Access Forums about this issue with no success in solving: here The problem at hand is manipulating a graph/chart via code. Specifically, manipulating the axes (scaling), plot area, other specific...

DBGuy: Hmmm... Thats an interesting approach. I would have to think about that. My guess is it wouldn't work, but unsure until i tried. MajP: The comment of "1000 lines of API Code" is a sarcastic reference--which is that I shouldn't expect to even touch the API with a comically trivial...

DBGuy, If i recall off the top of my head, Excel file dialogs are prompted with the Application object, such as... Application.FileDialog(type) where type is the dialog (open/save, etc). But i'm pretty sure the same object library that i'm using in Access is being inherited by Excel's...

DBguy, Can Excel's SaveAs dialog be implemented in Access?

DBGuy, There is no workaround which is why i've posted here. I know there is API code for this somewhere out there...which i've tried a lot of it and its uselessly outdated. I don't really understand the second question. This has been discussed here...

Hi, If you've ever used the msofiledialog object in VBA, you know that is severely lacking one large component, which is the ability to add a filter to the file SAVE AS dialog, which is sad. Some people tend to think this is possible, which it is not true and I cleared up a lot of confusion...