Search results

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

@MajP My head is rusty. Haven't been writing VBA in a week so i'm foggy. But if I am able to wrap my head around this, i'll resume the discussion. Thanks for contributing. Interesting.

Thank you very much!

SOLVED The tab control width and subform width was too large for the form basically. Decreasing the width of the subform and tab control solved it. Thanks to @KitaYama who solved this for me!!!!

@KitaYama That is fixed! How did you solve this?? tab stop??

@arnelgp Thanks for looking at this. That improved the issue but the focus is still trying to grab something prior to when the tab change event fires so there is still a glitch. Its quite annoying. i'm going to play around some more. If anyone else has any suggestions, that would be great...

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

Understood. However, there may be instances where the caller wants to pass an array on top of other parameters. This seems silly, but in practice has some logic.

UPDATED CODE: Here is an update to the code after some months. 1.) Code now supports ability to pass an array as a parameter in the param array. Ex: RunCMD(mypath,false,false,MyFilesArray) 2.) Code has improved debug.prints to make troubleshooting more understandable to new users of the...

@cedar Some more thoughts just thinking about this.... First, ensure the arguments you are passing meet the requirements I describe in my update above. The basic format for allowing whitespace characters is: ""Path to Script.exe" "Argument1" "Argument 2" "Argument 3" Please not that this...

@cedar Glad you found some use to the script. I'm still using it for one specific .exe in an Access app. My brain is extremely rusty right now, especially on this topic. Which is why I tried to make the script as bone-head proof as I could at the time, so that when my bonehead returned to...

I already attempted to make the args the same type (as per MS docs) and it wouldn't compile. Now it does. Whatever. Update: Incorrect above. It still will not compile if the argument is the same data type in both LET and GET. Not spending any more time on this petty issue. I could replace it...

At least you have helped me gain my sanity back...

Replacing it seems to not have worked. I'm going to have to sift through this. This problem did not show up until i decided to put a LET declaration for this property. It was read-only until now. Keywords are keywords because they're GOOD words. Its a shame MS locked down half the English...

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

@MajP Yep, you may or may not remember me inquiring some months ago about achieving a 'dialog' form for use in VBA to grab form info and the way I was originally doing it was with arguments and temporary table values. It was absolutely reprehensible and a troubleshooting madness. You provided...

@MajP You've answered all my questions that I had, including the ones I didn't ask! Bravo. As for delimited strings. This is exactly what prompted this question. I have half a dozen reports that take an uncomfortable amount args via OpenArg string. I'm talking functions to just handle passing...

GREAT INFO! Opening the report was cumbersome. I'll play around with it and see what is the easiest/cleanest to implement. My idea was this... Dim RPT As Report_Rep_PurchaseOrder DoCmd.OpenReport "Rep_PurchaseOrder", acViewReport, , , acHidden Set RPT =...

Update: Found the core issue. I was passing the report object as an index to the Reports collection, therefore it was throwing a type mismatch. Silly me. Thanks. Public Sub SomeFunctionName() Dim rpt As Report_Rep_PurchaseOrder DoCmd.OpenReport...

@MajP Thanks for your reply and good insight on polymorphic behavior of VBA... This doesn't solve my issue though. The object will not set. The report is spelled correctly as "Rep_PurchaseOrders" and the full module name being "Report_Rep_PurchaseOrders". The intellisense is visible and I can...