Recent content by ironfelix717

  1. I

    Access VBA Encryption - AES256 Cipher for Text strings?

    worst case scenario Correct. That's the point of a hash - to be asymmetric, which is not encryption (as you know). Would that be using the Binary data type, you are saying? Never used that data type so this might be a first. However, whether or not controls (listboxes, etc) support full ASCII...
  2. I

    Access VBA Encryption - AES256 Cipher for Text strings?

    Update: Colin, I examined the code in your example for RC4 encryption. It was one of the many i came across while searching for a sufficient algorithm. Albeit, one of the least favorited of the bunch... The mistake the author made was 1.) not fixing his error 2.) superficially patching a...
  3. I

    Access VBA Encryption - AES256 Cipher for Text strings?

    Colin, Thanks for sharing. Fair points about RC4. I don't find the file system weakness of Access really that big of a deal with security if the encrypted data is very strong and well designed (hash the pass with a randomized salt as the key, keep field names unspecific or under a unique...
  4. 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...
  5. I

    Solved VBA - Inconsistent compile error - Type declaration

    Great info. Lessons learned.
  6. 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
  7. 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...
  8. 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...
  9. 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.
  10. 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...
  11. I

    Solved VBA - Inconsistent compile error - Type declaration

    I attempted remove the declaration '$'. Then the compiler complains "Expected array".
  12. 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...
  13. 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...
  14. 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...
  15. 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...
Top Bottom