Recent content by ironfelix717

1-10-23 - 2 small 'bugs' were found. Both were present in the .Build() function. They are... 1.) The code would log a debug string of a warning indicating: ".Build(): Warning. End cord for path should match start cord. Ignored..." When the path (linestring) placemark type does not require...

KMLPlacemark Object This object allows one to easily read/build KML placemarks in VBA. 4 types of placemarks are supported. Point, Path, Polygon, and Photo Overlay. Other types of placemarks are NOT supported. These include, MultiGeometry, Screen Overlays, etc. This object attempts to be in...

KML File Object for VBA It is my pleasure to release the KMLFile object. With this class, you can read/write KML files with ease in VBA. Features include reading/writing the main sections of the file, extracting placemark objects and querying xpath on the file. This object is unique because it's...

@Uncle Gizmo I was unable to solve this issue validating against an XSD. The closest I came was by removing the atom namespace and all the atom elements, within the XSD. The code then at least did not throw any runtime errors. However, the validation did not pass saying 'multiple root items in...

Hi all, I am attempting validation of a XML (KML) via MSXML2 against a cached copy of the official XSD Here is validation code. The runtime error I receive complains about an 'undeclared XSD element' and then the atom namespace in the schema/file. The KML validates against the XSD with web...

Hi all, I have a personal split DB that has proprietary information in. (Lets not go down the rabbit hole of integrity of Access secuirty) or any other hypotheticals related to security. Let's say in the event that a hacker compromises this database and steals the file, I would like to at...

Hi, You did not understand me. You must delete that form. Corrupt. See attached picture above. I fixed issue with DQB code that was giving me an issue. Also, Russian (or whatever language you speak) gives unpredictable results on my computer because fields are not named as they appear. See my...

@axionvb I am getting error on your form about ActiveX control. You need to wipe that form and make a new example. It is corrupt or something. Also you need to use OPTION EXPLICIT and write your code accordingly. Re-build and attach. Code looks fine otherwise.

@axionvb I will look at this for you within next 24 hours. Reply if I don't get to it. Also this version of DQB is out of date. I haven't passed the update up to the community yet but it has some bugs.

@plog I'll have to revisit this manual script another time, but yeah I see your logic now. @The_Doc_Man I appreciate you looking into this, as well as the lesson on astrology 😁. I decided to go a different route. I found a python resource HERE that is apparently backed by some credible...

I'm not following your logic. 50 days after 1-6-2000 would be: 50/29.53 = 1.693. .693 is the remainder.

I am not an astronomer. Nor is this discussion point a matter of Access VBA, as much as it is an astronomy/science discussion. I set out today to implement a simple way of calculating the moon phase (percent of illumination, 100% = full moon). Originally, I found a PHP script here...

Hi, I am revisiting to clarify my solution, which uses a 'hook' method in each child class to reference the parent... First lets look at an example of how we want the end result to look.... Sub Test() dim cls as new ClassParent debug.print(cls.Child1.myfunction)...

Hi all, good discussion. Thanks for chiming in. @MarkK We're on the same page with what you commented. My inquiry was related to the ability to access the instance of a 'parent class' properties through it's 'member objects'. Terminology is varying but I think my point is getting across...

Greetings, Can someone help a dummy with improving/understanding OOP in VBA... I have a main class that has some properties, which are "inherited' by it's child classes.... Here is a sudo-description of the structure: Main Object ParentClass Property Let/Get ID Property Let/Get SystemType...