Search results

Here's what my AI would say, assuming I ever made one, which I won't: "It's not that deep bro." 😂

It took them so long to add tables. Correct me if I'm wrong but I could not find a decent way to have a dynamically resizing range before then which bummed me out. But when they came out with tables, I made a little spreadsheet where I track my gym 1 rep max weights and calculate the weight I...

Yeah and that's just too bad honestly. How long has it been since there's been a significant update to VBA? I only started using it a couple years back and it's basically remained the same. I always wished they'd implement the ability to write VBA in other IDE's than the visual basic editor. I...

I've been coding in python for awhile and discovered semi-recently that you can use python in Excel. Not to the extent of VBA, which has the ability to run code with side effects that can modify the spreadsheet, but anything formulas are capable of doing, Excel's python feature is also capable...

Didn't know that, too funny. Sorry I should've been a little more specific. I can add a record and know the added record's ID, I'm just unfamiliar with the technique you're referring to to navigate to a row in a continuous form using its ID. I tried setting the continuous form to the ID like...

Hi DBguy, thanks for your answer! What you said about listboxes makes sense. Haven't been messing around with multi-select listboxes yet, but for a single select one setting it to null deselects whatever has been selected. So then, in the same vein, setting a listbox to the bound value of one...

I must confess I don't hail from any of the above mentioned places, but now that I've learned that, I kind of wish that I did 😂

Hi there, I wanted to ask this question because I was curious if this is possible for both listboxes and full on continuous forms The thought of how this might be useful came up when I wrote some code to add a new row to a continuous form. Of course, by "adding a new row", I mean add a new...

Hi everyone, My name's Jonathon. Feel free to refer to me as that, Johnny, or SPARKLY SPARTAN, whichever feels the most natural ;D I've been programming solutions in VBA for the office suite for a bit, not as long as most people on here, though. I've become in charge of my company's MS Access...