Search results

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

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

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

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

Applauding computer science --- we've actually counterproductively made what is supposed to be a universal data structure into a PITA to use. I am trying to use the bloated JSON parser to grab a value from a JSON string. Frankly, I don't understand dictionaries that well. And now were gonna...

Hello, I am having a problem with a core UI layout inside my app. The scrollbar/focus glitches when two specific tabs are selected on a form. The UI layout is : MAIN FORM > QUOTE FORM.TabControl > subforms on some tabs Cycling through tabs in the quote form (Costing and Material) causes the...

Unless I've lost my mind, the following property declarations are 100% VALID and the compiler is whining about the property declaration being inconsistent, duplicate, etc... The property is not duplicate, or has any variable of the same name The LET and GET statement are correctly formatted...

Greetings, I am attempting to access vba defined report properties for a specific report. Dev hut has a good article on setting the object to allow intellisense here: https://www.devhut.net/vba-programming-a-form-or-report-with-intellisense/ While intellisense will work after dimensioning as...

Back again. How does one escape special characters, especially the . period/dot operator inside a criteria string? Topics that exists on this discusses enclosing them with brackets "[ ]". That would be a wonderful solution... but lo and behold that would be far to simple to work in Access, as...

Unsurprised, yet again, that escaping quote characters in strings is profoundly difficult. I am trying to escape the glorious apostrophe, aka chr(39). Usage: Sub test() Dim Criteria As String Dim SQL As String Criteria = "Mc'Hammer" SQL = "SELECT * FROM...

Dynamically building unbound queries in VBA (dynamic meaning on-the-fly) can be a daunting task. A common application of this is building search forms. First, all criteria-related controls (inputs) must be built (i.e. search textbox, some checkboxes, etc.), and then tied to the backend, which...

I am trying to pipe the output of a shell command.... Here is a verbatim CMD string that I can copy and paste directly into CMD prompt and execute with success. C:\Users\Dev\Scripts\Script.exe "C:\Users\Dev\input.pdf" "C:\Users\Dev\output.pdf" 256 > "C:\Users\Dev\log.txt" In VBA, this same...

Greetings all, This topic is a long shot and well beyond my skill at the current time-- but a long shot that's worth shooting, as I know how deep the knowledge and experience runs on this forum. Preface: I have a custom file manager form that has a "preview" image control... pretty standard...

Hi, Before I write my own nested nested nested loop, surely someone has something out there already.... I need to list all the files in a single 'base' folder, which includes subfolders of the base folder. and subfolders of the subfolder's subfolders. The nesting of the subfolders is assumed...

Hi, I am struggling to call a function by it's name. The function resides in a form object, but CallByName() is struggling to locate the object. Dim frm As Form Dim val As String Set frm = Form("frmOperations") val = CallByName(frm, "ClearFormHandler", VbMethod) The form...

Hi all, An app I have built and use frequently uses a lot of photos (of varying dimensions). The source of the photos is usually a cell camera. The problem is, the photos are displayed in the control with the incorrect orientation. If the photo was taken "side-ways" (landscape) with the cell...

Hi, Definitely covered before, but curious what the pros are doing... What is the best solution for accessing a custom VBA code base for multiple projects? A single library that is shared across multiple projects on a single local machine. Making changes to a few main projects that share the...

Greetings, Simply attempting to format an unbound textbox as either a date or a time only. A user would rightfully assume that when one formats a textbox as verbatim "Short Date" or "Short Time" in the design mode, the formatting would actually be a "Short Date" only---or a "Short...