> Adding things that I found useful to get started that weren't very obvious here.. Hi @retailcoder I love that the getting started guide is very detailed and thorough 😄 I would have loved it even better if it were a little more targeted towards newcomers like me and highlight some of the cool features here to get me started quickly!! I would like to propose a revamp of this guide to get your guys' feedback 😃 I just tried to give a flavor of my proposal here and can work on it based on...
so, the reference explorer now has its own page on the website - I didn't add a button/link for it in the header, because it's getting crowded in there
whelp, just lost another SO user. He had a valid question "I've never done this before and I don't even know where to start", that, unfortunately, doesn't fit the SO model. Got 4 close votes & deleted his question.
I've created some code to let users fill in a excelsheet with 4 tables. by pressing a button it copies the table data to another workbook. it has to find the last row filled and copy the data below that. Some cells won't get filled so i used .Filldown to get the empty cells filled. In order to ma...
@IvenBach Yeah, I am banging my head against the wall with some ADODB stuff.
May ask a question but making sure I'm doing every single research I can think of before asking.
@IvenBach Good so far - I switched from Python to C# for my language to learn in 2019 because Python isn't fast enough out of the box and we need to go as fast as possible and I don't want to fight our IT team every time I need a Python speed module or whatever they're called.
I have VS 2019 and I'm at the very beginning of converting my most business-critical VBA app to C# for massively-expanded future plans, but currently helping with some dumb urgent deadline because a company we acquired 3 years ago still doesn't have their !@#$ together.
in other news, I'm going to have to write a secure dynamic SQL generator in VBA
@t3chb0t map each "dynamic field name + value" to an object that gives you a @namedParameter with its value, and assuming the field names aren't user inputs then there should be a way to build your dynamic SQL into a parameterized command string that can be safely executed without concatenating any criterion. Heck I bet I could write this in VBA with ? positional parameters. — Mathieu Guindon9 mins ago
These are some pieces of a program I wrote to help my team automatically analyze and fix medical claims that have been rejected.
I thought some people might be interested to see what I have done to allow my team to modify a base query through what is kind of a SQL injection GUI. I had a few obje...
Tried that and just tried it again, but definitely appreciate the suggestion. When I was researching before asking, I saw someone else using double quotes instead of single.
My reasoning was that if you do it in VBA, you have no guarantee that someone can inject malicious code and thus make your engine do things you didn't mean it to do
@this that's right - but the goal wouldn't be to make something 100% secure. Just something that isn't blatantly wrong, and easy enough to use that the string-concat habits stop.
@BigBen not now, unfortunately. that question is bugging me though. you'd think there's a way to use INDEX to get to the actual array without parsing the formula itself... I can't get it to work :(
...but my O365 expired and the email I sent to MVPGA got a reply behind a login wall that wants a login I don't seem to have, so I gave up on it and moved on
select top 10 "NPI", "Provider First Name", "Provider First Line Business Mailing Address" from NPPES_Database
Returns 10 rows of
NPI Provider First Name Provider First Line Business Mailing Address NPI Provider First Name Provider First Line Business Mailing Address NPI Provider First Name Provider First Line Business Mailing Address
@KySoto not unlike "hey can we have a dropdown for the customer accounts", followed by "hey can we be able to enter any non-existing customer account in that field"
@Vogel612 git question. When doing git pull upstream next, git is under the covers really doing git fetch followed by git merge. git fetch first pulls down any changes from the remote to the computer. This means that there's a branch locally named upstream/next that has all the changes, but are yet to be merged/applied?
Idea: setup a webcam device near the impact area, compile video content during the entire year, play the 3-minute finished video at the company xmas party