VBA Rubberducking - 2019-05-28 (page 1 of 2)

« first day (1817 days earlier) ← previous day next day → last day (1363 days later) »

12:01 AM

RELOAD!

[banane-io/pdb-frontend] 5 commits. 3 issue comments. 1219 additions. 366 deletions.

[rubberduck-vba/RubberduckWeb] 3 commits. 352 additions. 363 deletions.

[Zomis/Duga] 1 closed issue. 1 issue comment.

[Zomis/minesweeper-server] 1 commit. 20 additions. 7 deletions.

[Minesweeper] New Users: 17, Games Played: 100, Bombs Used: 72, Moves Performed: 14089

Mathieu Guindon

12:29 AM

@IvenBach no but somewhat relatedly IIRC there's an open issue for one flagging superfluous instruction separators

I tested earlier and didn’t see an inspection come up.

I’d have thought it was one that would have been picked up early on.

Mathieu Guindon

I'll be happy to take a PR for it =)

12:48 AM

twitter.com/unclebobmartin/status/1133158434583531521

4 hours later…

4:57 AM

[rubberduck-vba/Rubberduck] IvenBach added label up-for-grabs to issue #4978: Statement separation inspection

[rubberduck-vba/Rubberduck] IvenBach added label feature-inspections to issue #4978: Statement separation inspection

[rubberduck-vba/Rubberduck] IvenBach opened issue #4978: Statement separation inspection

> **What**
Flag where `:` is used to separate statements as a code quality issue.

**Why**
Unlike other languages, C# as an example, VBA doesn't allow declaring and assigning variables on the same line. Using `:` is putting a round peg in the square hole. While syntactically it is valid it can hide issues with code and you're essentially fighting against the language. Having a line for declaration and subsequent line for assignment keeps code from being "cute" and squashing those potential b

[rubberduck-vba/Rubberduck] IvenBach added label enhancement to issue #4978: Statement separation inspection

At the very least you get an issue opened for it.

Night pond</iven>

6 hours later…

10:31 AM

@MathieuGuindon I think that link must be outdated - it's from 2016. Net core has targets for x86 and x64, so I think bitness has been addressed. I need to investigate some more, as the sample project runs fine for me - oddly, regsvr32 on SlimDucky reports success, but doesn't appear to actually register anything (need to regmon to confirm) - I had to register all the class/prog ids key by agonising key just to get office to even try and load it...

I have a feeling its something dumb I'm doing / not doing, just not clear what atm.

I've stripped out everything from slimducky except stubs for IDTExtensibility2, so really the only difference between my project and the dotnet sample is that they define their own COM interface, whereas I'm importing IDTExtensibility2...

11:13 AM

@MathieuGuindon Not only that, but they list it #1 above their own product!!

11:27 AM

@IvenBach That would be most excellent! May be very useful, but it's a bit spendy...

Mathieu Guindon

@mansellan that's very interesting! (and good news!)

12:00 PM

[rubberduck-vba/Rubberduck] bonzo-the-fifth starred us

2

12:33 PM

@mansellan did you define the DllRegisterServer/DlllUnregisterServer procedures?

@this iiuc that's handled by the new sdk when you specify UseComHost.

but will double check after work

12:56 PM

i don't see how it'd know that you need so and so keys registered.

maybe it does handle the COM keys fine but not necessarily Office addin keys

@MathieuGuindon LOL, Reorder Parameters--my first refactoring!

@this yeah that's plausible. in their demo they just have comguid attributes: github.com/dotnet/samples/blob/master/core/extensions/…

> He said pure functions, not immutable objects. A non-trivial program can't be exclusively composed of pure functions, however that doesn't take away the value of having as many as possible.

LOL, tell that to the Roslyn team...

The compiler is 100% pure functions from top to bottom so they can parallelize it.

@mansellan for that demo, it does not appear to me that they are registering anything; they're basically using a regfree activation

VB*, being from the "Put everything in registry!"-era, will have a spot of trouble finding stuff.

@this when you run dotnet build, it emits instructions to run regsvr32. they also demo SxS (which I didn't try)

their demo server registers correctly

but when I try and do so for IDTExtensibility2, no es beuno :-( must be something to do with it being an imported type rather than from source...

1:10 PM

does dotnet have an extensibility.dll?

that's where the managed definition for the IDExtensibility2 is

i just added it as a reference

hmm and that's still a framework DLL, is it?

oooh

would've thought it'd error when adding if there was a problem?

I'd think so, too

iiuc IAs are metadata only, so maybe it doesn't matter

also their demo proj file mentioned "using IServer in leui of PIAs"

1:13 PM

in which case, you need to define the IDTExtensiblity yourself.

rather than taking it from the DLL

ah ok, easy enough I think it's 1 type, 5 methods.

will try that later, thanks :-)

total brain fade after a long weekend. How the heck do I launch SSIS to start defining a new import process?

hangs head in shame

I'm just not finding it in the start menu...

depends on which version you have

but generally it is a favor of Visual Studio

derp

VS 17 -> New project -> Integration Services

So intuitive!

1:25 PM

Did I mention "looooong weekend"?

^^yeah, that...

I have had 3 large cups of coffee already this morning. Not helping at all

Did a lot of memorizing yesterday, eh? :D

Did a lot of work on the house this weekend, barely looked at a technology device at all. (Unless you consider cordless tools as "tech".)

Step 1) install VS updates (17.9.12)

Oh, hey, guess what this does? accounts.Count() == 0 || accounts.Count() > 1

There's an obviously simpler way to write that...

[rubberduck-vba/Rubberduck] JohnHubcr starred us

5

[rubberduck-vba/Rubberduck] JohnHubcr forked us into JohnHubcr/Rubberduck

2:25 PM

Having weird issues with SSIS - I can't drag n drop from the toolbox to the design area. A double-click will place the item there, though. Once it's there, I can't drag it to a new location.

It could be because I'm RDP to my work machine from home. That an issue anyone's run into?

I know I don't get any hover-text in a web browser when I'm RDP from home, so there may be some "issues".

I can't find it right now, but I read once that MS said that RDP had an easter egg that nobody found.

Did you just find it? :P

might be! Not much of an easter egg if you ask me. :/

@Hosch250 Are you trying to tell me I can't count to -5 items?!?

this is one I'd have rather left under the bush.

@MarkBalhoff Not with Linq's Count :D

2:38 PM

0

Q: Speed Up Excel Macro - Autofilter Copying

I am using this code which works fine, but runs painfully slow. The code filters an Excel Table and then extracts only certain columns and pastes them into another sheet (in a different order). Could it be sped up perhaps with a multi-dimensional array? With Application .ScreenUpdating = Fals...

BTW, if you ever need to f*** a computer, Symantec's got your back.

6

Also, don't loop over enumerables with for loops, folks.

I just changed a loop over an enumerable that called Count() and ElementAt() to a list.

It's way, way faster at 2k items.

Still not quite fast enough.

Hey @MathieuGuindon do you guys use `$5.00` or `$5,00` up your way?
Trying to figure out if I need to localize my currency now or later.

Mathieu Guindon

Localize now, or regret later ;-)

Both, @RubberDuck.

Decimal separator

A decimal separator is a symbol used to separate the integer part from the fractional part of a number written in decimal form. Different countries officially designate different symbols for the decimal separator. The choice of symbol for the decimal separator also affects the choice of symbol for the thousands separator used in digit grouping, so the latter is also treated in this article. Any such symbol can be called a decimal mark, decimal marker or decimal sign. But symbol-specific names are also used; decimal point and decimal comma refer to an (either baseline or middle) dot and comm...

Mathieu Guindon

I think the official notation is "5,00 $"

2:52 PM

They use decimal when using English and comma when using French.

Mathieu Guindon

I hate having spaces as thousands separator, so my setup is en-US =)

@Hosch250 AVG doesn't do a half bad job, either.

@MathieuGuindon WCAG 2.0 disapproves too.

@MathieuGuindon I'm already living with a bunch of regret. I've been localizing for nearly 3 weeks now.

@RubberDuck Want to hire me? I'm good at localizing.

I did RD :)

2:55 PM

Okay, so when in French, we do need to localize the currency. Thanks guys.

Only conditions are, I have to work remote, since I'm not moving to Ohio :)

In the old days it was much easier to 1099 someone around here... Big corporate overlords make that stuff harder now.

I'm actually kind of enjoying the work, but 3 weeks of fixing bad xaml wears on you a bit.

If I need to import a variety of files all of the same format, but with different file names, I can develop the SSIS package with one of them as my example, then parameterize the name later, correct?

Yeah. Html is worse, though, TBH. Change anything, and suddenly you have to redo the CSS too.

XAML has most of the styles kind of built in or declared on the element, so it's easier to see what to redo.

@Hosch250 not if you inline all your styles.

Mathieu Guindon

3:03 PM

shudder

LOL.

Mathieu Guindon

let me guess... and all margins are hard-coded?

Yeah, that's a pain if you have a ton of them :)

Mathieu Guindon

drag-and-drop xaml is criminal

3

OK, if you ever need to redo it from scratch, I'm happy to apply. I do enjoy web work, but I'd like to get back to desktop for a while.

3:05 PM

90% of what I've done over the last few weeks is undo drag&drop xaml

Mathieu Guindon

my sympathies

They're called grids & stack panels you dopes.

@RubberDuck I actually don't like stack panels that much anymore. They don't scale nicely. Most WPF experts I talk to don't like them either.

Grids and more grids for most things :)

Mathieu Guindon

I had that at a previous gig... back in 2013... the code-behind wasn't any better. everything happened in the control's constructor - spawning COM objects, connecting to & querying the database, pulling the results, ...no data bindings whatsoever, and all hard-coded margins.

"hey can you add an option button here?"

@MathieuGuindon Holy cow...

Mathieu Guindon

3:07 PM

"sure, gimme a few... oh wait. nope. gimme a month."

That's basically Winforms all over again :P

Mathieu Guindon

yes. and they paid big bucks for that user control, too

Seems to me that WinForms was the only one that did drag'n'drop decently.

Mathieu Guindon

no wonder they'd charge a fortune to tweak it

I've yet to see any good DnD designer for anything HTML-based or XML-based.

Mathieu Guindon

3:09 PM

the whole point of xaml is to ditch drag n' drop, and write markup instead

Yet... they provide DnD... O_o

@this WYSIWYG's aren't always that bad for trivial cases.

@this they just hid the mess from you in a partial class. But you've got a point. So does Mat.

But HTML really doesn't lend itself to DnD, being flow based instead of grid based.

Long weekends don't agree with me.

Yeah I know about the partial class and I don't think it's pretty to look but AIUI, whenever we messed with it, it regenerated the entire partial class, so I think that avoided the ugliness you would get if you DnD'd into a XML-based markup

3:12 PM

I'm just about ready to pop between trying to fix some crap left behind by the ancestral devs here and getting tickets "An error has occurred" with no reproduction tips in it.

@this As far as it goes, I couldn't stand the DnD editor in WinForms. I'd just edit the class.

what I do not want to deal with is the div soup that's popular nowadays.

Mathieu Guindon

@Hosch250 lol, having memories of the first GoDaddy "WebsiteBuilder" Rubberduck site, before @RubberDuck rewrote it

If I got it wrong, the designer would crash. If the designer displayed OK, it understood it :)

2

@MathieuGuindon :D

Mathieu Guindon

"if the designer displayed OK" -> in THAT browser

@MathieuGuindon I mean the WinForms designer in VS.

3:13 PM

@MathieuGuindon I'm sure Dreamweaver will do you better. :-D

For HTML, you really only need to get it to display in FF and Chrome if you are targeting the latest version of each browser.

Mathieu Guindon

eh, I'm starting to like ASP.NET MVC

just not the CSS bits

and JS

and...

and..

@MathieuGuindon Look up SASS.

And use Mads Torgenson's addin to compile it.

for me, I can deal with web API, no problem.

I can convert it for you, if you like. But you will need that addin.

3:14 PM

with web apps.... yeeech

@Hosch250 at least you knew where you stood!

I'm interviewing someone in 5 hr.

Helping interview, that is.

@MathieuGuindon I saw you guys just released a new version of the site.

I'm going to ask about Git, ASP.NET MVC, knockout JS or angular/react/other JS UI frameworks, security, accessibility, DI, unit testing, OOP/FP/general paradigms, C# 8 development.

I meant to ask, what are you targeting these days?

3:19 PM

@RubberDuck Same as before.

The last two questions are for scoping out where they are as a dev. Avid/less avid/I-just-wanna-go-home.

Maybe I'll poke at what it would take to get to Core.
MS is going to eventually drop support for Framework.

@RubberDuck Actually, not.

They are kind of merging core back into framework with .NET 5.

That's supposed to come out in late 2020, I heard.

Not quite. Framework is being deprecated in favor of Core, which is becoming the new Framework.

Oh. Well, that works :)

Hence why Raymond says "The new old thing"

3:22 PM

@RubberDuck +3 Gauntlets of Name Obsfucation and Confusion

oh, and @RubberDuck, nice to see you! Welcome back!!

Thanks @FreeMan. I mostly just stop by when I need something these days, but... ya know.

@RubberDuck We're always here :) I don't do much now lately, either :(

Mathieu Guindon

@RubberDuck aye - been meaning to get extensive xml-docs for all inspections for quite a while.. figured I'd just bite the bullet and do it.. and when that was done and I got to parse the xml and generate the inspections page I decided I wanted syntax highlighting for the code examples - and that was fun :)

@RubberDuck I think all that's preventing it to work with Core is the Rubberduck.Parsing and Rubberduck.SmartIndenter dependencies

the indenter could easily be ported. the parser.... not so sure.

I'm not sure about the parser either, but, FWIW, @MathieuGuindon, I'm doing a parser in .NET Core now for Amethyst.

Basically a parser for some basic C#-like expressions for calculating values based on provided values for the leaderboards feature.

Instead of running hand-crafted SQL scripts on a timer, we'll just calculate everything on an as-needed basis when the user provides data.

Mathieu Guindon

probably worth trying. Framework can reference Core, just not the other way around, right?

or they're completely separate silos?

3:29 PM

Different siloes.

Mathieu Guindon

hanselman.com/blog/…

That's targeting .NET Standard.

Mathieu Guindon

fml

Both implement Standard, and both have features that aren't part of the Standard spec.

Remember, Standard is a spec, not an implementation. Like an interface.

This ^

Mono also implements the spec.

Mathieu Guindon

3:32 PM

user image

YES!

@Hosch250 Looks like new math to me.

@IvenBach The simpler version would've been != 1.

Instead of != 0 || > 1

Since Count can't be negative.

@Hosch250 If count is negative, then my code review would (likely) include changing the name of count.

>=0 would suffice.

3:40 PM

^ that

Sorry, yes, that would work with my mistake.

The real version (see above) was count == 0 || count > 1.

whoops, I think i misread your last comment.

or did you edit it? wait i'm confused.

@Dair The top one that Iven pointed at first was right.

@RubberDuck :offers-condolences: There you go.

This was wrong: Instead of != 0 || > 1

3:43 PM

^ Made me give a funny 0.o face.

I don't know why, but I feel confused even though I don't think I should be.

@IvenBach appreciated

Gtg. Need to take a break before I teach my class in a few minutes. See yinz soon.

3:55 PM

I've been thinking about the column header ordering for the ToDoWindow. The setup done by CastleWinsor has me newing up 2 instances of the HeaderOrder. Does it make sense to have a static singleton that can be called to access the same instance for both locations?

Mathieu Guindon

why are there 2?

also no, a static singleton doesn't really make sense - if you want the same instance injected, you need CW to register it with a "singleton lifestyle", i.e. the same instance is injected everywhere it's requested

singleton is the default though

(with Ninject it's "transient"; each client gets its own instance)

possibly the registration for it is being done by a rule that changes the lifestyle to something else

Can't figure out how to supply a single instance to both locations. One is new'd up via default settings in ToDoListConfigProvide. The other in ToDoExplorerViewModel is supplied from _columnHeadingsOrder = _configService.Read().UserSettings.ToDoListSettings.ColumnHeadingsOrder; which is New'd up on deserialization.

I'll have to refresh because of the long weekend. I didn't think a singleton would be a valid use for it either.

Mathieu Guindon

that's fine...

deserialization will always create a new instance

that's why we use a provider :)

4:21 PM

I'm getting a #BrainTickle but can't explore it right now. Will definitely ping you when I can.

4:44 PM

SSIS question: I'm working on importing survey results. Row 1 of my data is the Question ID. Row 2 is the initial 50 or so characters of the question. Rows 3-x are the answers.

In the Flat File Connection Manager on the "Preview" page, is a "Data rows to skip" option. If I change that from 0 to 1, it doesn't show me the question text. I believe that this applies only to the preview, though, not to the actual data import. Is that correct?

How do I get the import to skip the 2nd row of the file, the 1st row of "data" which isn't, in this case, actual data?

Currently, I'm adjusting that row in my VBA code before importing in an attempt to get it to get the wide columns (>255 characters) without truncating, so I could remove it in code before calling the SSIS package to import, but I'd be happy to have SSIS do it for me if it can.

5:21 PM

9

Q: Modern approach to radio buttons

I am working on updating the UI/UX of a 20 year old application and I seem to be stuck at this particular use case. On clicking on the New button, the system asks the user to choose one of two options Create New Work Order Create new Task/Subtask for a pre-existing Work Order Keep in mind t...

6:04 PM

whatup

Hey Jelly.

Iven!

Whats up

Just finished an answer on CodeReview. Working on getting a feature for RD finished and ready for PR.

Still a day or so from being reviewable.

sweet

you guys are great!

The others are great, I'm just a tag-along-pleb.

6:09 PM

plebeian lol

my coworker uses that word gratuitously

Hey, @Jelly. How's it going?

@Hosch250 hey bud! I'm doing great. How are you?

@Jelly he's a plebeian. I'm a philistine.

@this this is a philistine free zone

lol

We are tolerant and accepting of all cultures in this space

Good. Just fighting horrible code at work. Interviewing someone in 1.75hr.

6:15 PM

:D

Boi! Look at you. From interviewee to interviewer in a year. Nice progression!

Got any interview questions for web dev off the top of your head?

Just wanting to make sure I'm grilling them hard enough :)

why not ask them to do a HTTP request over telnet?

I mean, if they can't do that....

Because I don't know how to?

I do my HTTP requests with Postman.

similar idea; only more typing involved.

it's not that hard, really! Doesn't Postman show you the raw HTTP request?

6:18 PM

Yeah...

I know for fact Fiddler does but can't remembmer if Postman does

You just put in the URL and the data and it goes.

And then you can do all sorts of fun stuff.

with a telnet, it's basically just telnet google.com 80

But, they'll know how to do that if they pass the other questions.

then put in HTTP 1.1, then rest of the request

6:19 PM

They're going to be asked about why would a dev do DI, and stuff.

If they pass these questions, they'd be better for for the architect team than my team.

Break the ice first and then ask questions

that's my strategy.

(I have never interviewed people before)

Sure, good questions. When I intereviewed some time ago, I found they don't even know the basics. They can shoot off all acronyms but when it comes to forming a basic HTTP request, they're like ".... I use a browser."

if they don't even know what a raw HTTP request/response look like, then how would they be expected to troubleshoot even most rudimentary errors?

TBH, if they can pass all my questions, I'm not really worried about whether than can do an HTTP request. They can learn that detail.

I came with barely any web experience, but I knew the C# language.

But, I might ask them to do that.

Won't hurt, anyway :)

It is true that one could get away building web apps with only C# (or maybe even a bit of CSS / JS sprinkled in), but when it comes to troubleshooting, they better know how a HTTP request/response look like

Funny thing, it took me like 6 months to figure out the Network tab in the dev tools.

6:23 PM

At least that's what I think - I honestly I don't think I was really effective at troubleshooting problems until I actually got to learning how to use telnet/Fiddler/Postman.

I got by with the console errors and the C# crashes.

And console.log.

then it finally clicked on how HTTP conversation should go, and from that, errors became easier to pinpoint

YMMV, obviously.

I knew the network side sort-of from my network classes in college. We covered the OSI layers a couple of times.

@Hosch250 have you used Blazor.NEt

i have seen a couple of videos after ms build conference

I actually have back in version 0.1 or something like that just for a bit.

6:28 PM

it looks pretty hot

I was at an NDC conference a couple weeks ago, and went to a talk on it.

it actually loads .net libs in the browser via webassemblyl

I'm going to test it out as soon as I get time. Maybe even next week on vaca.

you might kiss js goodbye lol

IKR?

Although, it'd be a Jon Snow-type kiss.

6:29 PM

sorry loads not looks

With a dagger in the back, LOL.

you watch game of thrones?

Nah, just read the spoilers :)

I'm not really one for the movies.

me either

You still in Seattle?

Maybe next year, I'll be out that way and be able to say hi in person :)

6:36 PM

hmm

im moving up to Canada to Vancouver BC but will be back to the US in a year or so.

Oh, nice. Lots of mountains in that area.

If you ever in seattle, please let me know.

in even better in BC. You come hang out for a couple of days.

I've seen lots of big hills, but never a real live (well...) mountain.

Are you into camping?

I like it, but I've only done it once.

6:37 PM

I have been indoctrinated into fishing here by a couple of a good guys

I'm actually looking to get into a backcountry camping group next summer.

right on!

I don't know that, so it's not safe for me to go in on my own, but I'd love to.

Get a gun and a map.

You're white. You will be fine lol

I've heard bears like white guys too :)

My parents said I have to move out if I carry a gun. They freaked out over the kabar I just got.

Well, my mom freaked out.

6:39 PM

lol.

Good parents.

I hate guns btw.

I don't carry them, but I don't dislike them. They can do a lot of harm, and they can prevent a lot of harm.

so you moving to seattle?

No, I thought about visiting some of the parks in the area.

dude come to portland then

Seattle is way too expensive to move to with a GS, because I'd need a house.

(German Shepherd.)

6:41 PM

we can go up to the ridgefield volanic observatory

Sounds cool.

I was actually thinking about going to the Utah canyons this summer, but went to the conference instead.

Next year, I'll just watch the content on YouTube after they put it up :)

Or if I go, I'll submit the application ahead of time so work pays for the whole thing.

what conference did you go?

NDC Minnesota.

You can see all the talks here: youtube.com/channel/UCTdw38Cw6jcm0atBPA39a0Q/videos

Troy Hunt, Jimmy Bogard, Mark Seemann, and more.

7:05 PM

niceee

It was. I got lots of new ideas from it.

Next thing for me is looking into kubernetes :)

7:51 PM

[rubberduck-vba/Rubberduck] dolemite7 starred us

3

8:02 PM

Interviewee is a no-show. Apparently he never confirmed and hasn't shown up.

@Hosch250 I watched the talks, except for kubernetes. What's next on my ToView list?

Whatever you think looks interesting.

I don't want to search out my own knowledge. It's easier to be spoonfed.

Not sure which one will give me the most benefit.

8:36 PM

@IvenBach the point is to look at what tickles your fancy

it's also usually the thing that will give you the most benefit

For me, I picked by who I wanted to see (Mark Seemann), what I was lacking in (Kubernetes, security), curious about (Blazor).

If I were you I'd watch Modern Web Application Bugs and Hackers, Hooligans, Heists, and History.

The first one features a lot of security attacks that aren't solely about web.

0

Q: Speeding Up Excel Distance Calculation Using Bing API Calls

I am writing VB code in Excel to calculate the distance between an employee's home address and work address using Bing Maps API calls. The process follows this general flow: 1) Convert the employee's address to Lat-Long values using the GetLatLong function 2) Convert the employee's work address...

vba excel web-scraping api

Mathieu Guindon

@QuackExchange looks like a textbook asynchronous Office-JS use case

8:52 PM

aww you crazy excel kids with your javascript

@QuackExchange I mean, if it takes an hour and it works, you shouldn't need to run this too often, unless the turnover is absurdly high

Mathieu Guindon

looks like they're UDFs

an hour to calculate a workbook is... I'd die.

I mean, I scream after 30 seconds, so...

9:11 PM

somewhat relatedly: Powerpoint Web does not expose grouped animations

which is ... a travesty and a tragedy...

I might have to hack around that

[rubberduck-vba/Battleship] VolkerConsult opened issue #21: Excel2013+ bug high CPU load if Freeze Panes line is zoomed out of sight

> Excel 2013+ seems to have a bug such that if you Freeze Panes and zoom in so that the freeze line is out of sight it starts to recalculate the worksheet's display constantly thereby causing high CPU load. In order to limit the scroll area and keep the battle fields on display use the worksheet property ScrollArea and limit to $A$1:$AF$32 as in the attachment.
[Excel2013up-bug_frozenPanesOutOfSight.xlsx](https://github.com/rubberduck-vba/Battleship/files/3229740/Excel2013up-bug_frozenPanesOut

@Duga that's so close to being a PullRequest :/

Mathieu Guindon

lol I did ask them to make a PR

eh

9:43 PM

@MathieuGuindon You're not trying hard enough then.

Mathieu Guindon

@Duga sent a frown + emailed the Excel DL

10:14 PM

hm

i think its dumb that you cant programatically set the parent control of an access form

forcing you to cut the control and paste it on the new parent control is stupid

Never tried but you might be able via a design view.

Several properties are not mutable when you are not in design view

yeah, i tried in design view :(

it said object doesnt support it

well, there's CreateControl....

which is LAME

true. that does work, but it doesnt let you go through and auto link controls that SHOULD have been linked

but arnet

especially when you are fixing up an older application that got jacked up.

define "jacked up"

10:28 PM

whoever built the form de-coupled the lables from the parent controls

or report

well, if you're talking about hundreds of them, you might want to do UI automation.

mumble mumble brain tickle mumble on right path.

10:53 PM

That path didn't lead me to where I wanted to go...

do share?

> We wants it. We needs it. Must have the precious. They stole it from us. Sneaky little Pathses. Wicked. Tricksy. False.

Working on the ToDoListSettings.ColumnOrdering issue. I have it serializing and deserializing as expected. When I display the ToDoWindow the order isn't according to the DisplayIndex I'm expecting.

@this Falsy this one be Truely.

SELECT
	ISNULL(SUM(IIF(i.foo IS NOT NULL AND i.bar IS NOT NULL, i.qty, 0)), 0) - ISNULL(SUM(IIF(d.foo IS NOT NULL AND d.bar IS NOT NULL, d.qty, 0)), 0)
FROM inserted AS i
LEFT JOIN deleted AS d
	ON i.ID = d.ID

#intuitive

« first day (1817 days earlier) ← previous day next day → last day (1363 days later) »

Transcript for

May '1928

VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ

antlr com-interop parsing rubberduck vb6 vba whiskey-tango-foxtrot

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile