Search results

  1. ironfelix717

    Prevent code execution after Click_Event

    I have been under the impression that a click event was not fireable until any current code execution was complete. I.e. If a button once then again, the click event cannot be re-fired until execution of the first instance is complete. Apparently this isn't the case. That is improper and...
  2. ironfelix717

    BAD form Flickr - Loading image to Image Control

    Hi, Usually I can find a way around the painfully annoying flickering Access is consumed by. Dynamically loading an image to image control in Access always causes this, but I am hoping someone can help solve this. Attached is an example that mirrors the full project. Any ideas? My only other...
  3. ironfelix717

    Solved Access Query - From 2 different tables, without IIF!

    Hi, I have a reasonably complex query I am hoping to get help with. Essentially, I need to match an order containing CustomerID and Version to a record that may exist in one of TWO tables, and get the STATUS field of the record. I have worked around this in the past using an expression field...
  4. ironfelix717

    Code: VBA WeatherUnderground.com SCRAPER

    Description: This is a VBA scraper for pulling historic weather data for a specific day/month and location/station. WU is supposed to be a quite accurate data source for historic weather. In the past, they had an API. Since IBM bought them out, the API has since been restricted to a premium...
  5. ironfelix717

    SQL - INSERT INTO / SELECT FROM, one field with SET value

    Hi, Is it possible to provide a SET value in an INSERT/SELECT-FROM query?? EX: SQL = "INSERT INTO ToolingBuilds " & _ "SELECT ToolID, ToolVersion, ToolCompID, ToolCompVersion, " & _ "DateModified FROM TempTable;" In the above, I need to insert all the fields from...
  6. ironfelix717

    Access Continuous Forms: Row highlighting + DBLclick functionality

    Hi all, I've finally delved into continuous forms and am enjoying this new discovery. What led me here was the need for a Data Grid / Editable listbox control that i've been dancing around with a lousy (but functional) custom form control. Therefore, my end goal of this form is to simulate...
  7. ironfelix717

    Unbound Multi User DAO Recordset locking

    Hi all, I'm trying to ensure I fully understand how locking will work in a multi-user access environment (5-10 users) and to plan my code around it before I continue development. This question is in reference to unbound forms. How do you pros write your code to handle conflicting updates, etc...
  8. ironfelix717

    Code: VBA Google Earth KML File Placemarks

    Finally after some long hours, I was able to cobble together some code to work with KML files in VBA/Access. The attached example includes an object that allows for the following features.... **this code is focused on placemarks only and does not support any other GE geometry (i.e. paths)**...
  9. ironfelix717

    Solved Google Earth KML Parser - Ignoring irrelevant header/fields

    Hi, I'm not well versed in XML. But I need to parse a KML from Earth, mainly to extract the following data: *Only extracting placemarks - no paths or other geometry -Name of Placemark -Lat/Long Cord -Description of placemark -Placemark style ID Side Note: I have been able to parse the Name...
  10. ironfelix717

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

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

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

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

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

    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...
  15. ironfelix717

    Access VBA: File picker with filters - SAVE AS

    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...
  16. ironfelix717

    Solved Complex query: GROUP BY EACH Latest account balance

    HI, I need to write a query that finds the "closest" account balance to a specified date for each account in the system. I've tried this for hours. I'm done messing around and getting nowhere. There are 2 tables: Accounts & Transactions. I need to group the Transactions by each Account in...
  17. ironfelix717

    MS Access - Insert Text at cursor with SelText

    Hi, The preferred method of inserting text at a cursor position in a textbox appears to be setting the Textbox.SelText property.... This doesn't work for me under any circumstances (RTF or Plain format). It simply erases the entire text box. See attached. Thanks for any help. Regards
  18. ironfelix717

    MS Access: custom control built in another language

    Hi, I have a need for a specific control to be built for an Access application. I have built this control in a rather crude way with the existing built in controls using VBA. But performance is rather poor due to lots of looping. Some of the performance can be improved with some code...
  19. ironfelix717

    Sort by MAX Version query - Very slow

    Hi, I am experimenting with a query over the network for an in-development application. FE is access and BE is access. With a test of 100,000 records, this query is very slow. Fields of concern are: PK autonumber, OperationID, and version. OperationID can be duplicative. Each record with a...
Top Bottom