Search results

  1. I

    Access VBA Encryption - AES256 Cipher for Text strings?

    Hi, What are you guys using for good 'data access' level encryption? There are a number of RC4 and XORC Ciphers out there for strings. While they work OK, i have a few issues with everything i've found using these... 1.) I'm not convinced a 40-50 line Function is all that secure of an...
  2. I

    Solved VBA - Inconsistent compile error - Type declaration

    Great info. Lessons learned.
  3. I

    Solved VBA - Inconsistent compile error - Type declaration

    Update: 2 seconds of searching, I had an Enum value as "Mid" (Google Maps APIs, one of the marker size arguments is "MID" - what a dumb way to describe size, am i right) . Problem solved. Silly me! What a waste
  4. I

    Solved VBA - Inconsistent compile error - Type declaration

    Except its hard to debug when your debugger needs debugged. Turns out my speculations became conclusive. This project has something going on where the MID function is not cooperating. Furthermore, intellisense doesn't even recognize MID, but it will recognize Left, Right, and every other...
  5. I

    Solved VBA - Inconsistent compile error - Type declaration

    This isn't my first day writing VBA... I just exported every single forms, module, and table in this DB to a fresh DB. I then used a third encryption algorithm and the MID function still flags as a compile error in a completely different function that is entirely unrelated to the one in...
  6. I

    Solved VBA - Inconsistent compile error - Type declaration

    My next step is to copy the Module to plain text and re-import manually in a fresh module.
  7. I

    Solved VBA - Inconsistent compile error - Type declaration

    Yes byte array, never considered there's actually 256 values being stored... Regardless, like i said, this function executed several hundred times and the fact that I had other MID functions in this project flag randomly at the exact time this started (functions i never touched), this is...
  8. I

    Solved VBA - Inconsistent compile error - Type declaration

    I attempted remove the declaration '$'. Then the compiler complains "Expected array".
  9. I

    Solved VBA - Inconsistent compile error - Type declaration

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

    Browser Control: Displaying Google Maps in Form

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

    Browser Control: Displaying Google Maps in Form

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

    Browser Control: Displaying Google Maps in Form

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

    Browser Control: Displaying Google Maps in Form

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

    Solved MS Access - Google Maps API, On_Click get Cords

    @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...
  15. I

    Solved MS Access - Google Maps API, On_Click get Cords

    @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...
  16. I

    Solved MS Access - Google Maps API, On_Click get Cords

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

    Unsolved: Manipulate chart object via code (MS Graph) on a FORM

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

    Unsolved: Manipulate chart object via code (MS Graph) on a FORM

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

    Unsolved: Manipulate chart object via code (MS Graph) on a FORM

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

    Unsolved: Manipulate chart object via code (MS Graph) on a FORM

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